Try $belongsTo instead of $hasOne.
$belongsTo = array('User');
On Feb 22, 7:03 pm, deek <derek.bon...@gmail.com> wrote:
> First of all let me say I'm very new to CakePHP and complex PHP in
> general. I based the blog I am working on off the tutorial on the
> CakePHP website. I skipped creating ACL or a more complex management
> of permissions because as of now the only people who will be posting
> content will be Authorized users so using the Auth component in both
> of my controllers with an appropriate beforeFilter() function has done
> exactly what I needed. What I am trying to do is in my display of
> posted articles have $post['Post']['user_id']; look up the in the
> users post table the display name, I haven't found a simple answer for
> this so that is why I am posting.
>
> I've looked through the cakePHP book online and thought I might need
> to do something to link models together but I didn't have any success
> with that. I tried having the Post model include var $hasOne = User
> but that ended up breaking everything. Any suggestions would be
> greatly appreciated.
>
> Below are my table structures, models, and view I am working with
>
> -- Table structure for table `posts`
>
> CREATE TABLE IF NOT EXISTS `posts` (
> `id` int(10) unsigned NOT NULL auto_increment,
> `user_id` int(11) NOT NULL,
> `title` varchar(50) default NULL,
> `category` varchar(50) default NULL,
> `body` text,
> `frontpage` tinyint(1) NOT NULL,
> `created` datetime default NULL,
> `modified` datetime default NULL,
> PRIMARY KEY (`id`)
> )
> -- Table structure for table `users`
>
> CREATE TABLE IF NOT EXISTS `users` (
> `id` int(11) NOT NULL auto_increment,
> `username` char(50) default NULL,
> `password` char(40) default NULL,
> `displayname` varchar(50) NOT NULL,
> PRIMARY KEY (`id`),
> UNIQUE KEY `username` (`username`)
>
> Post Model:
> class Post extends AppModel {
> var $name = 'Post';
> var $validate = array (
> 'title' => array(
> 'rule' => 'notEmpty'
> ),
> 'category' => array(
> 'rule' => 'notEmpty'
> ),
> 'body' => array(
> 'rule' => 'notEmpty'
> ),
> 'frontpage' => array(
> 'rule' => 'numeric'
> )
> );}
>
> User model:
> class User extends AppModel {
> var $name = 'User';
> var $validate = array(
> 'username' => array(
> 'rule' => 'notEmpty',
> 'message' => 'Please enter your Username'
> ),
> 'displayname' => array(
> 'rule' => 'notEmpty'
> 'message' => 'Please enter the name you wish displayed
> with your posts'
> ),
> 'password' => array(
> 'rule' => 'notEmpty',
> 'message' => 'Pelase enter your Password'
> )
> );}
>
> index.ctp: This view is on my main page and loops through all the
> posts that are tagged to be on the front page
>
> <?php foreach (array_reverse($posts) as $post){if ($post['Post']
> ['frontpage']==true){ ?>
> <?php echo $html->link($post['Post']['title'],
> array('controller' => 'posts', 'action' => 'view', $post['Post']
> ['id'])); ?><br/>
> <?php echo $post['Post']['category']; ?><br/>
> <?php echo $post['Post']['created']; ?><br/>
> <?php echo $post['Post']['body']; ?><br/>
> <?php echo $post['Post']['user_id']; ?><br/><br/>
> <?php }}; ?>
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
