CakePHP: accessing data from query in view

Question

I have a hasMany relationship set up. User hasMany Projects. In my users controller in the profile view I can see the projects being returned for that user in the SQL dump.

I want to display each project in my profile view for that user. So I have set up a association between user and projects. User hasMany projects. I have created a profile action in the users controller with the associated profile view. When I navigate to the profile view of one of the users with, I can see that it is querying for the projects in the SQL dump.

This is the SQL dump with the correct userid:

SELECT `Project`.`id`, `Project`.`title`, `Project`.`created`, `Project`.`website`, `Project`.`language_id`, `Project`.`user_id`, `Project`.`description`, `Project`.`tags`, `Project`.`creator_id` FROM `projects` AS `Project` WHERE `Project`.`user_id` = (5)

How can I use the data from this query?

Project Model

var $belongsTo = array(
    'User' => array(
        'className'    => 'User',
        'foreignKey'    => 'user_id',
        'counterCache' => 'num_of_projects'
        ),
    'Language'
     );  
?>

User Model

  var $hasMany = array('Project' => 
                                array('className'     => 'Project', 
                                      'conditions'    => '',
                                      'order'         => '', 
                                      'limit'         => '',                    
                                      'foreignKey'    => 'user_id',              
                                      'dependent'     => true,                   
                                      'exclusive'     => false,                  
                                      'finderQuery'   => '',                      
                                      'fields'        => '',                      
                                      'offset'        => '',                      
                                      'counterQuery'  => ''
                                      )           
                    );

User_Controller's profile action

function profile($id = null) {
    $this->User->id = $id;
    $this->set('user', $this->User->read());
}

James Zaghini · Accepted Answer · 2010-09-08 13:21:28Z

1

In your view

foreach($user['Project'] as $project)
{
   echo $project['title'].'<br />';
}

To see the bigger picture, just use pr(), you should be able to see how to access the rest of the data from there.

pr($user);

edited Sep 8, 2010 at 13:21

answered Sep 8, 2010 at 12:05

James Zaghini

4,0114 gold badges47 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

iamjonesy Over a year ago

thanks for you reply, tried it but getting this error: invalid argument supplied for foreach(). Does it know what projects is? It's not set as it would be in the controller. It's via the association

James Zaghini Over a year ago

Ok... can you confirm that we're not even involving views at the moment. You just want to loop over each 'project' in the 'users' controller? So you're doing something like: $users = $this->User->find(); and a user hasMany projects? If you post some code it would really help out, I'm just guessing here :D

iamjonesy Over a year ago

I have updated my question, thanks for helping me out with this!

James Zaghini Over a year ago

I've updated my answer. Keep in mind, that since CakePHP is just returning arrays you can just dump it out with print_r(), or cake's built in pr(), which makes it easier to read by wrapping it in html pre tags. That way, you should always be able to see what data you have, and how to access it.

Collectives™ on Stack Overflow

CakePHP: accessing data from query in view

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related