php中form表单feild,php – zf2 form：使用来自数据库的数据填充select字段

This can be done easily by following the below 2 steps in Zend

Framework2 Step 1.

add The instance of the adapter what instantiating form class in the

controller action

$dbAdapter = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter');

$form = new TestForm ($dbAdapter);

Step 2 in your form

namespace Test\Form;

use Zend\Form\Form;

use Zend\Db\Adapter\AdapterInterface;

use Zend\Db\Adapter\Adapter;

class TestForm extends Form

{

protected $adapter;

public function __construct(AdapterInterface $dbAdapter)

{

$this->adapter =$dbAdapter;

parent::__construct("Test Form");

$this->setAttribute('method', 'post');

//your select field

$this->add(array(

'type' => 'Zend\Form\Element\Select',

'name' => 'name',

'tabindex' =>2,

'options' => array(

'label' => 'Author',

'empty_option' => 'Please select an author',

'value_options' => $this->getOptionsForSelect(),

)

));

// another fields

}

public function getOptionsForSelect()

{

$dbAdapter = $this->adapter;

$sql = 'SELECT id,name FROM newsauthor where active=1 ORDER BY sortorder ASC';

$statement = $dbAdapter->query($sql);

$result = $statement->execute();

$selectData = array();

foreach ($result as $res) {

$selectData[$res['id']] = $res['name'];

}

return $selectData;

}

}

And here you go you are ready to rock.I hope it helps you