Saturday, August 30, 2014

Dispay data from HABTM in a view

Hi ,

I have the odd situation where I can retrieve data from a HABTM model (from debug array)but cant actually display any of it in the view. I keep getting index undefined error for everything. I want data from both tables but it doesnt work


//view doesnt work
  foreach ($student as $item2):
           echo '<td>'. $item2['Lesson']['id'].'</td>';   
       echo '<td>'. $item2['Student']['first_name'].'</td>'; //error undefined index


//controler

class LessonsController extends AppController {

...
  $this->Lesson->recursive = -1;
    
            $options['joins'] = array(
               array('table' => 'lessons_students',
                'alias' => 'LessonsStudent',
                'type' => 'LEFT',
                'conditions' => array(
                'Lesson.id = LessonsStudent.lesson_id',
                 )
                 ),
               
                array('table' => 'students',
                'alias' => 'Student',
                'type' => 'LEFT',
                'conditions' => array(
                'LessonsStudent.student_id=Student.id',
                 )
                 ),
                       
            );
           
            $options['conditions'] = array('Student.id' => 2);
      //  $Item->find('all', $options);
           
     $student=$this->set( 'student',$this->Lesson->find('all', $options));

--
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: