01.18 php saved
kain
Tags add more
recursion in cake 1.  
Note
querying Blog model to fetch User.UserGroup or User.UserState doesn't work anymore.
  1.     function index() {
  2.         $limit = $this->preferences['limit_blogposts_in_index'];
  3.         $this->Blog->recursive = 2;
  4.         $this->paginate = array('limit' => $limit, 'order' => 'Blog.created DESC');
  5.         $this->set('posts', $this->paginate(null, array('Blog.published = 1')));
  6.     }
  7.  
  8. example result:
  9.  
  10. Array
  11. (
  12.     [0] => Array
  13.         (
  14.             [Blog] => Array
  15.                 (
  16.                     [id] => 5
  17.                     [user_id] => 1
  18.                     [title] => Aggiornamento sulla versione stabile
  19.                     [body] => Salve a tutti,
  20.                     [url] => aggiornamento_sulla_versione_stabile
  21.                     [created] => 2007-01-15 17:00:53
  22.                     [published] => 1
  23.                 )
  24.  
  25.             [User] => Array
  26.                 (
  27.                     [id] => 1
  28.                     [userstate_id] => 1
  29.                     [usergroup_id] => 1
  30.                     [language_id] => 0
  31.                     [username] => kain
  32.                     [password] => d65be92f2drdb01d4517636b3cbbf6e9
  33.                     [email] => claudio@kuht.it
  34.  
  35.                 )
  36.  
  37.         )
  38.  
  39. should be
  40.  
  41.             [User] => Array
  42.                 (
  43.                     [id] => 1
  44.                     [userstate_id] => 1
  45.                     [usergroup_id] => 1
  46.                     [language_id] => 0
  47.                     [username] => kain
  48.                     [password] => d65be92f2drdb01d4517636b3cbbf6e9
  49.                     [email] => claudio@kuht.it
  50.  
  51.                 )
  52. [UserGroup] etc
  53.  
  54.  
  55. CREATE TABLE `users` (
  56.   `id` int(11) NOT NULL auto_increment,
  57.   `userstate_id` int(2) NOT NULL default '2',
  58.   `usergroup_id` int(10) unsigned NOT NULL default '0',
  59.   `language_id` int(2) NOT NULL,
  60.   `username` varchar(120) collate utf8_unicode_ci NOT NULL,
  61.   `password` varchar(32) collate utf8_unicode_ci NOT NULL,
  62.   `email` varchar(120) collate utf8_unicode_ci NOT NULL,
  63.   PRIMARY KEY  (`id`),
  64.   KEY `username` (`username`,`email`)
  65. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=103 ;
  66.  
  67. CREATE TABLE `blogs` (
  68.   `id` int(11) NOT NULL auto_increment,
  69.   `user_id` int(11) NOT NULL default '0',
  70.   `title` varchar(255) character set utf8 NOT NULL default '',
  71.   `body` text character set utf8 NOT NULL,
  72.   `url` varchar(255) character set utf8 NOT NULL default '',
  73.   `created` datetime NOT NULL default '0000-00-00 00:00:00',
  74.   `published` tinyint(1) NOT NULL,
  75.   PRIMARY KEY  (`id`),
  76.   KEY `user_id` (`user_id`)
  77. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
  78.  
  79. CREATE TABLE `user_groups` (
  80.   `id` int(10) unsigned NOT NULL auto_increment,
  81.   `name` varchar(20) default NULL,
  82.   PRIMARY KEY  (`id`)
  83. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
  84.  
  85. class User extends AppModel {
  86.     var $name = 'User';
  87.  
  88.     var $displayField = 'username';
  89.  
  90.     var $belongsTo = array(
  91.         'UserGroup' => array(
  92.             'className' => 'UserGroup'
  93.         ),
  94.         'UserState' => array(
  95.             'className' => 'UserState'
  96.         )
  97.     );
  98.  
  99. class Blog extends AppModel {
  100.     var $name = 'Blog';
  101.  
  102.     var $belongsTo = array(
  103.         'User' => array('className' => 'User')
  104.     );
Parsed in 0.151 seconds, using GeSHi 1.0.7.14

Modify this Paste