ZF2:如何从数据库中获取下拉选项 - ZF2: how to get options for dropdown from db

ZF2: how to get options for dropdown from db

本文关键字：获取选项数据库 ZF2 | 更新日期: 2023-09-27

我学习了教程。但我找不到任何方法来填充从这样的数据库中选择的表格：

// Blog/src/Blog/Form/BlogItemForm.php
$blogCategoryTable = new Model'BlogCategoryTable;
$this->add(new Element'Select('category_id',
    array('label' => 'Category', 'value_options' => $blogCategoryTable->getFormChoices())
    ));

有人有什么想法吗？

我使用一个函数来检索数据并将其设置为形式：

来自我的工厂：

    $option_for_select = $this->model->getWhatEver();
    $this->add($factory->createElement(array(
        'name' => 'what_ever',
        'type' => 'Zend'Form'Element'Select',
        'attributes' => array(
            'options' => $option_for_select,
        ),
        'options' => array(
            'label' => 'What ever:',
        ),
    )));

来自模型：

public function getWhatEver()
{
    $sql = "SELECT something";
    $statement = $this->adapter->query($sql);
    $res =  $statement->execute();
    // set the first option
    $rows[0] = array (
        'value' => '0',
        'label' => 'Top',
        'selected' => TRUE,
        'disabled' => FALSE
    );
    foreach ($res as $row) {
        $rows[$row['triplet_id']] = array (
            'value' => $row['col1'],
            'label' => $row['col2'],
        );
    }
    return $rows;
}