在CakePHP中将prename和lastname显示为select选项

Question

I want to show a form with CakePHP where users can select an employee. Cake shows the inputfield as "select" which is good. Unfortunately the select input field only shows the id of the employee rather than the prename and lastname.

Model:

Reminder:

worker_id (reference to Worker model)

Worker:

id
prename
lastname

Here is the PHP part:

echo $this->Form->create('Reminder', 
    array('action' => 'add',
        'inputDefaults' => array(
            'label' => false,
            'div' => false
        )
    )
); 

echo $this->Form->input('worker_id', array('empty' => 'Choose an employee'));
echo $this->Form->button('Save', array('type' => 'submit', 'class' => 'btn btn-green')); 

I did not find a way to show the prename and lastname of class Worker but keep the id as option value in the select field.

How can this be done?

Answer 1

You have need to create $your_listing as below

$your_listing = array('2'=>'John Fleming','3'=>'Justin Bond');

and used this array in your form helper as below

echo $this->Form->input('worker_id', array('empty' => 'Choose an employee','options'=>$your_listing)); 

So in above example, select box become

<select name="worker_id">
  <option id="">Choose an employee</option>
  <option id="2">John Fleming</option>
  <option id="3">Justin Bond</option>
  </select>

</div>