php - cant get data to group in find in a cakephp HABTM -

-

i have habtm relationship of students , subjects. want display subjects associated student without repetition of student details. dont want student details keep repeating in data output. how student details shown below output once , subjects associated student output?

group didnt work. didnt see answer in docs sure simple task do.

http://book.cakephp.org/2.0/en/models/retrieving-your-data.html

  $this->student->recursive = -1;            $joinoptions = array(       //  $options['joins'] = array(             array('table' => 'students_subjects',                 'alias' => 'studentssubject',                 'type' => 'left',                 'conditions' => array(                 'student.id = studentssubject.student_id',                  )                  ),              array('table' => 'subjects',                 'alias' => 'subject',                 'type' => 'left',                 'conditions' => array(                 'studentssubject.subject_id=subject.id',                  )                  ),                );              $fieldoptions =  array('student.id,student.last_name,student.first_name,student.address_street,student.address_suburb,'                                 . 'subject.name,subject.id, studentssubject.id, student.first_name,student.last_name,student.address_lat,student.address_long,student.tutor_gender_preference'                                );              $student=$this->student->find('all',array(                'conditions'=>   array( 'student.id' => $student_id),                 'fields'=>$fieldoptions,                 'joins'=> $joinoptions,               //  'group' => 'student.id',                 'recursive' =>-1,                 ));    array(     (int) 0 => array(         'student' => array(             'id' => '216',             'last_name' => 'ncc',             'first_name' => 'acc',             'address_street' => '8 sdsdt',             'address_suburb' => 'hasdsdk',             'address_lat' => 'xx',             'address_long' => 'xx',             'tutor_gender_preference' => 'no preference'         ),         'subject' => array(             'name' => 'english: year 7 - 10',             'id' => '9'         ),         'studentssubject' => array(             'id' => '531'         )     ),     (int) 1 => array(         'student' => array(             'id' => '216',             'last_name' => 'ncc',             'first_name' => 'acc',             'address_street' => '8 sdsdt',             'address_suburb' => 'hasdsdk',             'address_lat' => 'xx',             'address_long' => 'xx',             'tutor_gender_preference' => 'no preference'         ),         'subject' => array(             'name' => 'maths: year 7 - 10',             'id' => '16'         ),         'studentssubject' => array(             'id' => '532'         )     ),     (int) 2 => array(         'student' => array(             'id' => '216',             'last_name' => 'ncc',             'first_name' => 'acc',             'address_street' => '8 sdsdt',             'address_suburb' => 'hasdsdk',             'address_lat' => 'xx',             'address_long' => 'xx',             'tutor_gender_preference' => 'no preference'         ),         'subject' => array(             'name' => 'physics: year 11',             'id' => '28'         ),         'studentssubject' => array(             'id' => '583'         )     ) )


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more