ansaurus

Question

CakePHP: accessing data from query in view

Answer 1

+1 A:

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);

Jamesz 2010-09-08 12:05:32

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

iamjonesy 2010-09-08 12:25:46

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

Jamesz 2010-09-08 12:40:54

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

iamjonesy 2010-09-08 13:05:55

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.

Jamesz 2010-09-08 13:25:18

thanks a lot Jamesz! Sorry for complicating it!

iamjonesy 2010-09-08 13:53:14

ansaurus

tags:

views:

answers:

CakePHP: accessing data from query in view

related questions