[ã‚¹ãƒ†ãƒƒãƒ—ã‚¢ãƒƒãƒ—ï¼ CakePHP]ç”»åƒã‚’データベースã«ä¿å˜ã™ã‚‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚iPadã€ã™ã§ã«3,000円以上ã®ã‚¢ãƒ—リを買ã£ã¦ã‚‹tanakaã§ã™ã€‚GoodReaderåˆã‚ã¦ä½¿ã„ã¾ã—ãŸãŒä¾¿åˆ©ã§ã™ãï¼ CakePHP連載6回目。今回ã¯ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã•ã‚ŒãŸç”»åƒã‚’データベースã«ä¿å˜ã™ã‚‹æ–¹æ³•ã‚’紹介ã—ã¾ã™ã€‚ 実ã¯ã‚ã‚“ã¾ã‚ŠCakePHPã¨ã¯é–¢ä¿‚ãªã„ã§ã™ãŒã€CakePHPã®ãŠã‹ã’ã§å®Ÿè£…ãŒå®¹æ˜“ã«ãªã‚‹éƒ¨åˆ†ã‚‚ã‚ã‚Šã¾ã™ã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ ç”»åƒæ ¼ç´ç”¨ãƒ†ãƒ¼ãƒ–ル ã¾ãšã¯ç”»åƒã‚’ä¿å˜ã™ã‚‹ãŸã‚ã®ãƒ†ãƒ¼ãƒ–ルを用æ„ã—ã¾ã™ã€‚ CREATE TABLE `images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filename` varchar(60) NOT NULL, `contents` mediumblob NOT NULL, PRIMARY KEY (`id`) ); filenameã¯ã€URLä¸ã®ãƒ•ã‚¡ã‚¤ãƒ«åã¨ã—ã¦ä½¿ã„ã¾ã™ã€‚(URLã«idを使ã†å ´åˆã¯ä¸è¦)cont
![[ã‚¹ãƒ†ãƒƒãƒ—ã‚¢ãƒƒãƒ—ï¼ CakePHP]ç”»åƒã‚’データベースã«ä¿å˜ã™ã‚‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚](https://cdn-ak-scissors.b.st-hatena.com/image/square/1f4390ea5b2b558adfd9c349b9a080aae407daff/height=288;version=1;width=512/https%3A%2F%2Fbashalog.c-brains.jp%2Fshared%2Fpublic%2Fimg%2Fcommon%2Ficon_ogp02.png)
{{#tags}}- {{label}}
{{/tags}}