cakephp dropdown from another table

Question

i have two tables

voices:

id
Lecturer_id
...

Lecturers:

id
Lecturer
code

add.ctp is for voices but there is a drop-down which list lecturers. then the id of Lecturer should be saved in Lecturer_id of voices table

PersianMan · Accepted Answer · 2013-02-22 19:04:16Z

3

i solved the issue and wanted to share it with u:

in Voice module:

public $belongsTo = 'Lecturer';

and i added some code to Add action in Voicescontroller:

    $this->set('lecturers', $this->Voice->Lecturer->find(
            'list',
            array(
                'fields' => array('Lecturer.Lecturer'),
                'order' => array('Lecturer.Lecturer')
            )));

and in add.ctp for my dropdown:

        echo $this->Form->input('lecturer_id',  array(
            'options' => array($lecturers),
            'empty' => '(choose one)'
             ));

answered Feb 22, 2013 at 19:04

PersianMan

2,7992 gold badges20 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

cakephp dropdown from another table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related