<\/a>\n<\/p>\n\n\u3053\u306e\u3088\u3046\u306a\u95a2\u4fc2\u304c\u3042\u308b\u3068\u304d\u3001\u96d1\u8a8c\u306e\u4e00\u89a7\u3092\u6b21\u306e\u3088\u3046\u306b\u53d6\u5f97\u3057\u305f\u3044\u3068\u601d\u3046\u8a33\u3067\u3059\u3002\n<\/p>\n
- \n
- \u96d1\u8a8cID<\/li>\n
- \u96d1\u8a8c\u540d<\/li>\n
- \u51fa\u7248\u793e\u540d<\/li>\n
- \u51fa\u7248\u793e\u306e\u6240\u5728\u5730\/\u90fd\u9053\u5e9c\u770c<\/li>\n<\/ul>\n
\n\u3053\u308c\u3092\u901a\u5e38\u306a\u3089\u3070\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d3\u30e5\u30fc\u3092\u4f5c\u3063\u3066\u3001\n<\/p>\n
- \n
- id<\/li>\n
- magazine_name<\/li>\n
- publisher_name<\/li>\n
- publisher_state<\/li>\n<\/ul>\n
\n\u306e\u3088\u3046\u306a\u5f62\u3067\u53d6\u5f97\u3057\u3066\u3082\u826f\u3044\u306e\u3067\u3059\u304c\u3001\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5909\u66f4\u3067\u304d\u306a\u304b\u3063\u305f\u308a\u3001\u30c7\u30fc\u30bf\u7ba1\u7406\u306f\u5225\u306e\u4f1a\u793e\u304c\u69cb\u7bc9\u3057\u305f\u3082\u306e\u3060\u3063\u305f\u308a\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u9593\u306b\u306f\u5927\u304d\u306a\u6e9d\u304c\u3042\u308b\u306e\u304c\u5e38\u3060\u3063\u305f\u308a\u3057\u307e\u3059\u3002\n<\/p>\n
\n# \u5c0f\u3055\u306a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306a\u3089\u3070\u3044\u3044\u3093\u3067\u3059\u3051\u3069\u306d\u3002
\n# \u3042\u3068\u3001\u3082\u306e\u5206\u304b\u308a\u826f\u3044(\u4ee5\u4e0b\u7565\n<\/p>\n\n\u3068\u3044\u3046\u8a33\u3067 http:\/\/servername\/magazines\/lists \u3067\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002
\n\u307e\u305a\u306f\u3001\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3001\u666e\u901a\u306e\u30e2\u30c7\u30eb\u3092\u4f7f\u3063\u3066\u3044\u308b\u3088\u3046\u306b\u66f8\u304d\u307e\u3059\u3002\u3068\u3044\u3046\u304b\u66f8\u304d\u305f\u3044\u308f\u3051\u3067\u3059\u3002\n<\/p>\n\r\n<!-- views\/magazines\/lists.ctp -->\r\n<h2>\u96d1\u8a8c\u4e00\u89a7(\u72ec\u81ea)<\/h2>\r\n<table>\r\n\t<tr>\r\n\t\t<td>id<\/td>\r\n\t\t<td>name<\/td>\r\n\t\t<td>Publisher.name<\/td>\r\n\t\t<td>State.name<\/td>\r\n\t<\/tr>\r\n<?php foreach($MagazineLists as $item) : ?>\r\n\t<tr>\r\n\t\t<td><?php echo $item['Magazine']['id'] ?><\/td>\r\n\t\t<td><?php echo $item['Magazine']['name'] ?><\/td>\r\n\t\t<td><?php echo $item['Publisher']['name'] ?><\/td>\r\n\t\t<td><?php echo $item['State']['name'] ?><\/td>\r\n\t<\/tr>\r\n<?php endforeach ; ?>\r\n<\/table>\r\n<\/pre>\n
\n\u3053\u308c\u306b\u5408\u308f\u305b\u3066\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306b lists \u30e1\u30bd\u30c3\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\n<\/p>\n
\r\n<?php\r\nclass MagazinesController extends AppController {\r\n\tvar $name = 'Magazines';\r\n\tvar $uses = array('Magazine','Publisher','MagazineList');\r\n\tfunction index() {\r\n\t\t$this->set('Magazines',$this->Magazine->find('all'));\r\n\t\t$this->set('Publishers',$this->Publisher->find('all'));\r\n\t}\r\n\t\/\/ \u72ec\u81ea\u306e\u96d1\u8a8c\u30ea\u30b9\u30c8 \u2605\r\n\tfunction lists() {\r\n\t\t$this->set('MagazineLists',$this->MagazineList->findAll());\r\n\t}\r\n}\r\n?>\r\n<\/pre>\n\nfindAll \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u3044\u308b\u306e\u306f\u3001\u4ed6\u306e\u30e2\u30c7\u30eb\u3068\u63c3\u3048\u308b\u305f\u3081\u3067\u3059\u3002\u3044\u308f\u3086\u308b\u5143\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u30aa\u30fc\u30d0\u30fc\u30e9\u30a4\u30c9\u3059\u308b\u3068\u3044\u3046\u5974\u3067\u3059\u3002
\n\u30e2\u30c7\u30eb\u306e\u30af\u30e9\u30b9\u540d\u306f\u300cMagazineList\u300d\uff08\u30d5\u30a1\u30a4\u30eb\u540d\u306f\u547d\u540d\u898f\u5247\u3067 magazine_list.php\uff09\u306b\u306a\u308a\u307e\u3059\u3002\n<\/p>\n\r\n<!-- models\/magazine_list.php -->\r\n<?php\r\nclass MagazineList extends AppModel\r\n{\r\n\tvar $name = 'MagazineList';\r\n\tvar $useTable = false;\t\/\/ \u2605\u30c6\u30fc\u30d6\u30eb\u306b\u9023\u7d50\u3055\u305b\u306a\u3044\r\n\r\n\tfunction findAll()\r\n\t{\r\n\t\t$sql = <<< HERE\r\nSELECT\r\n Magazine.id,\r\n Magazine.name,\r\n Publisher.id,\r\n Publisher.name,\r\n State.id,\r\n State.name\r\nFROM\r\n magazines as Magazine\r\n inner join publishers as Publisher \r\n on ( Magazine.publisher_id = Publisher.id ) \r\n inner join states as State\r\n on ( Publisher.state_id = State.id )\r\n order by \r\n Magazine.id\r\nHERE;\r\n\t\treturn $this->query($sql); \/\/ \u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\r\n\t}\r\n\r\n}\r\n?>\r\n<\/pre>\n\n\u72ec\u81ea\u306b\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u306e\u3067\u3001Mode::query \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002\u6975\u60aa\u3067\u3059\u306d\uff57\u3002
\n\u30af\u30a8\u30ea\u6587\u81ea\u4f53\u306f\u3001\u30d2\u30a2\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u3057\u3066\u304a\u3044\u3066\u3001MySQL Workbench \u306a\u3069\u3067\u30c6\u30b9\u30c8\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u3066\u304a\u304f\u306e\u304c\u30df\u30bd\u3067\u3059\u3002\n<\/p>\n
<\/a><\/p>\n\n\u3042\u3068\u306f\u3001\u7d50\u679c\u3092\u8fd4\u3059\u6642\u306b\u3001\u300cMagazine.id\u300d\u306e\u3088\u3046\u306b\u8fd4\u3057\u3066\u304a\u304f\u3068\uff08\u591a\u5206as\u3067\u5225\u540d\u3092\u5b9a\u7fa9\u3057\u3066\u3082OK\u304b\u3068) $item[‘Magazine’][‘id’] \u306e\u3088\u3046\u306b\u3042\u305f\u304b\u3082 CakePHP \u306e findAll \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u305f\u3088\u3046\u306b\u7d50\u679c\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\n<\/p>\n
\n\u3053\u308c\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u3053\u3093\u306a\u611f\u3058\u3002\n<\/p>\n
<\/a><\/p>\n\n\u5f53\u7136\u3067\u3059\u304c\u3001\u30af\u30a8\u30ea\u6587\u306f query \u30e1\u30bd\u30c3\u30c9\u3067\u5b9f\u884c\u3057\u305f\u3082\u306e\u304c\u4f7f\u308f\u308c\u3066\u3044\u307e\u3059\u3002left join \u3067\u306a\u3044\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5c4b\u3055\u3093\u3068\u3057\u3066\u306f\u3059\u3063\u304d\u308a\u3068\u3044\u3046\u611f\u3058\u3067\u3059\u306d\u3002\n<\/p>\n
\n\uff5e\n<\/p>\n
\n\u79c1\u898b\u3067\u3059\u304c\u3001\u305d\u3082\u305d\u3082O\/R\u30de\u30c3\u30d4\u30f3\u30b0(ORM)\u3063\u3066\u306e\u306f\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6307\u5411\u3068\u30c7\u30fc\u30bf\u6307\u5411\u3092\u7d50\u3073\u3064\u3051\u308b\u3068\u3044\u3046\u306e\u304c\u76ee\u7684\u3067\u3001\u306a\u306b\u3082\u30af\u30e9\u30b9(\u30aa\u30d6\u30b8\u30a7\u30af\u30c8)\u3068\u30c6\u30fc\u30d6\u30eb\u30921\u5bfe1\u306b\u3059\u308b\u3001\u3068\u3044\u3046\u306e\u304c\u76ee\u7684\u3067\u306f\u306a\u3044\u306e\u3067\u3059\u306d(\u521d\u624b\u3068\u3057\u3066\u306f\u826f\u3044\u306e\u3067\u3057\u3087\u3046\u304c)\u3002\n<\/p>\n
<\/a><\/p>\n\nO\/R \u30de\u30c3\u30d4\u30f3\u30b0\u3092\u3059\u308b\u3068\u304d\u306b\u3001\u53f3\u306e\u30c7\u30fc\u30bf\u306f\u65e2\u306b\u6b63\u898f\u5316<\/b>\u3055\u308c\u3066\u3044\u308b\u72b6\u614b\u306a\u306e\u3067\u3001\u305d\u306e\u307e\u307e\u30af\u30e9\u30b9\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u3059\u308b\u306e\u306f\u4e0d\u4fbf\u3067\u3059\u3002\u3068\u8a00\u3044\u307e\u3059\u304b\u3001\u975e\u6b63\u898f\u5316<\/b>\u306e\u72b6\u614b\u306b\u623b\u3055\u306a\u3044\u3068\u4f7f\u3048\u307e\u305b\u3093\u3002RDB \u81ea\u4f53\u304c\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u3067\u3042\u308b\u3053\u3068\u3092\u57fa\u672c\u3068\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u3072\u3068\u3064\u306e\u73fe\u5b9f\u3092\u8868\u3059\u306e\u306b publisher_id \u3084 state_id \u306a\u3069\u306e identify \u3092\u4f7f\u3046\u8a33\u3067\u3001\u3053\u308c\u3092 id \u306e\u307e\u307e\u30de\u30c3\u30d4\u30f3\u30b0\u3059\u308b\u3088\u308a\u3082\u3001\u5143\u306e\u975e\u6b63\u898f\u5316<\/b>\u306e\u72b6\u614b\u306b\u623b\u3057\u3066\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6307\u5411\u306e\u4e16\u754c\u3078\u3068\u8a98\u3046\u306e\u304c\u3088\u3044\u304b\u3068\u601d\u3063\u3066\u3044\u307e\u3059\u3002\n<\/p>\n
\n\u307e\u3001\u6a5f\u80fd\u3068\u4f7f\u3044\u65b9\u306f\u8272\u3005\u306a\u306e\u3067\u3001\u5229\u7528\u3059\u308b\u6642\u306b\u5408\u308f\u305b\u308b\u306e\u304c\u30d9\u30bf\u30fc\u304b\u3068\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
CakePHP\u306e\u5834\u5408\u3001\u30e2\u30c7\u30eb\u3068\u30c6\u30fc\u30d6\u30eb\u304c1\u5bfe1\u3068\u60f3\u5b9a\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u3053\u308c\u4ee5\u5916\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u3092\u3059\u308b\u5834\u5408\u306f\u3001\u72ec\u81ea\u306e Model \u3092\u4f5c\u3063\u305f\u307b\u3046\u304c\u3044\u3044\u3068\u601d\u3044\u307e\u3059\u3002 \u4f8b\u3048\u3070\u3001\u5148\u306e\u8a18\u4e8b\u306e\u3088\u3046\u306b\u3001\u51fa\u7248\u793e(Publisher)\u304b\u3089\u5fc5\u305a\u90fd\u9053\u5e9c … \u7d9a\u304d\u3092\u8aad\u3080