Wednesday, June 4, 2014

Re: display data 3 tables

You are referencing the $user variable when you have set a $tutor variable. Add this to your view so you can inspect the shape of the $tutor variable and work out how to access the key you are looking for:

die(debug($tutor));

It’ll probably look something like this:

array(
‘Tutorsession’ => array(
‘id’ => 1,
‘user_id’ => 123,
‘other_fields’ => ‘other_values’,
‘User’ => array(
‘id’ => 123,
‘username’ => ‘the_user_name'
)
)
)

If it does, you access the username with:

$tutor[‘Tutorsession’][‘User’][‘username’]


On 4 Jun 2014, at 23:45, ajt <jagguy999@gmail.com> wrote:

This still doesnt work as I get an error when I reference the user table which should be linked unless I need to do this another way?

view
 echo '<td>'. $item['User']['username'].'</td>'; ///////error user undefined


$this->set(
'tutor',
$this->Tutorsession->find(
'first',
array(
'conditions' => array('Teacher.user_id' => $id),
'contain' => 'User.username'
)
)
);

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: