How to create a select - option in Zend Framework +MySQL Table

Question

How to create a select - option in Zend Framework +MySQL Table

COntroller:

$persons = new Application_Model_DbTable_Persons();
$data_persons = $persons->findPersons();

Controller and View? How to? o.O

Answer 1

In Controller

   $this->view->dataPerson = $data_persons;

View Html.

  foreach($this->dataPerson as $datPers):
               //Example Get person name.
          echo $this->escape($datPers->name);
           and etc.

 endforeach;

Answer 2

The options to the Select box can be added as an array using addMultiOptions() function

$persons = new Application_Model_DbTable_Persons();
$data_persons = $persons->findPersons();
$data_persons_array = array();

foreach($this->dataPerson as $datPers)
    $data_persons_array[$datPers->id] =  $datPers->name


$name = new Zend_Form_Element_Text('name');
$name->setLabel('name')
        ->setRequired(true)
        ->addValidator('NotEmpty');
        ->addMultiOptions($data_persons_array); //Will add the options to select box