{"id":1799,"date":"2011-01-28T11:03:09","date_gmt":"2011-01-27T17:03:09","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/archives\/1799"},"modified":"2011-01-28T11:04:44","modified_gmt":"2011-01-28T02:04:44","slug":"cakephp%e3%81%a73%e3%81%a4%e3%81%ae%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%92%e9%80%a3%e7%b5%90%e3%81%95%e3%81%9b%e3%82%8b%e3%80%82","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/1799","title":{"rendered":"CakePHP\u30673\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u9023\u7d50\u3055\u305b\u308b\u3002"},"content":{"rendered":"

\n\u3055\u3066\u3001\u96d1\u8a8c(magazines)\u3068\u51fa\u7248\u793e(publishers)\u3092 Model::$belongsTo \u3067\u9023\u7d50\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u304c\u3001\u4eca\u5ea6\u306f\u90fd\u9053\u5e9c\u770c(states)\u3068\u51fa\u7248\u793e\u3092\u9023\u7d50\u3055\u305b\u3066\u30013\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3044\u307e\u3059\u3002\n<\/p>\n

\n\u5b9f\u7528\u7684\u306a\u554f\u984c\u3068\u3057\u3066\u3001\u3072\u3068\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u53ce\u307e\u308b\u3053\u3068\u306f\u307e\u305a\u7121\u3044\u8a33\u3067\u3001\u30ed\u30b0\u3084\u3089\u5358\u7d14\u306a\u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb\u7a0b\u5ea6\u306a\u3089\u3070\u3044\u3044\u306e\u3067\u3059\u304c\u3001\u3010\u771f\u9762\u76ee\u306b\u3011\u30c6\u30fc\u30d6\u30eb\u3092\u6b63\u898f\u5316\u3057\u3066\u3044\u308c\u3070\u30013 \u3064\u4ee5\u4e0a\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u9023\u7d50\u3059\u308b\u306e\u306f\u5f53\u305f\u308a\u524d\u3067\u3059\u30c3!!! … \u3060\u3068\u3044\u3044\u306a\u3041\u3001\u3068\u3044\u3046\u5e0c\u671b\u7684\u89b3\u6e2c\u3082\u542b\u3081\u3066(\u82e6\u7b11)\u3002\n<\/p>\n

\r\n-- \u96d1\u8a8c\u30c6\u30fc\u30d6\u30eb\r\ncreate table magazines (\r\n id int not null,\r\n name varchar(50),\r\n publisher_id int,\r\n price int\r\n);\r\n-- \u51fa\u7248\u793e\u30c6\u30fc\u30d6\u30eb\r\ncreate table publishers (\r\n id int not null,\r\n name varchar(50),\r\n state_id int\r\n);\r\n-- \u90fd\u9053\u5e9c\u770c\u30c6\u30fc\u30d6\u30eb\r\ncreate table states (\r\n id int not null,\r\n name varchar(20)\r\n);\r\n<\/pre>\n
\n# \u8aac\u660e\u304c\u9762\u5012\u306a\u306e\u3067\u3001T100 \u3092 magazines \u306b\u3001T200 \u3092 publishers \u306b\u5909\u66f4\u3057\u307e\u3057\u305f\uff57\n<\/p>\n
\nER \u56f3\u306f\u3053\u3093\u306a\u611f\u3058\u3067\u30011\u5bfe\u591a\u306e\u95a2\u4fc2\u3067\u3059\u3002\n<\/p>\n
<\/a><\/p>\n
\n\u3053\u308c\u3092\u51fa\u7248\u793e\u3092\u4e2d\u5fc3\u306b\u3057\u3066(cakephp \u306f left join \u3067\u9023\u7d50\u3055\u305b\u308b\u306e\u3067)\u3001\n<\/p>\n
\r\n<h2>\u51fa\u7248\u793e\u4e00\u89a7<\/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>Magazine.name<\/td>\r\n\t\t<td>State.name<\/td>\r\n\t<\/tr>\r\n<?php foreach($Publishers as $item) : ?>\r\n\t<tr>\r\n\t\t<td><?php echo $item['Publisher']['id'] ?><\/td>\r\n\t\t<td><?php echo $item['Publisher']['name'] ?><\/td>\r\n\t\t<td><?php echo $item['Magazine']['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\u306e\u3088\u3046\u306b\u3001\u90fd\u9053\u5e9c\u770c\u540d(State)\u3092\u8868\u793a\u3055\u305b\u3088\u3046\u3068\u3059\u308b\u3068\u3001Publisher \u30e2\u30c7\u30eb\u30af\u30e9\u30b9\u306b\u6b21\u306e\u3088\u3046\u306b\u52a0\u7b46\u3057\u307e\u3059\u3002\n<\/p>\n
\r\n<!-- models\/publisher.php -->\r\n<?php\r\nclass Publisher extends AppModel\r\n{\r\n\tvar $name = 'Publisher ';\r\n    var $belongsTo = array(\r\n    \t'Magazine' => array(\r\n\t\t\t'className' => 'Magazine',\r\n\t\t\t'conditions' => 'Magazine.publisher_id = Publisher.id',\r\n\t\t\t'order' => 'Publisher.id ASC',\r\n\t\t\t'foreignKey' => ''),\r\n        'State' => array (\t\t\t\t\/\/ \u3053\u3053\u304b\u3089\u8ffd\u52a0\r\n\t    \t'className' => 'State',\r\n\t\t\t'conditions' => '',\r\n\t\t\t'order' => 'State.id ASC',\r\n\t\t\t'foreignKey' => 'state_id')\r\n        );\r\n}\r\n?>\r\n<\/pre>\n
\n\u95a2\u4fc2\u304c\n<\/p>\n