php - CodeIgniter - 添加默认值到 form_dropdown

Question

我想知道是否有人可以帮助我。我有一个 form_dropdown，我正在用数据库中的选项填充它。我想在列表顶部添加一个默认的“请选择”值，但不知道如何在不将其添加到数据库的情况下执行此操作。

我的代码如下:

function populatedropdown()
{
    $query = $this->db->query('SELECT * FROM '.$this->table_name.' WHERE active=1 ORDER BY brand');
    $dropdowns = $query->result();

    foreach($dropdowns as $dropdown) {
        $dropDownList[$dropdown->brand] = $dropdown->brand;
    }
    $finalDropDown = $dropDownList;

    return $finalDropDown;
}

Answer 1

另一种写法是:

function populatedropdown()
{
    $query = $this->db->query('SELECT * FROM '.$this->table_name.' WHERE active=1 ORDER BY brand');

    if ($query->num_rows() > 0) {
        $dropdowns = $query->result();

        $dropDownList[''] = 'Please Select';    // default selection item
        foreach($dropdowns as $dropdown) {
            $dropDownList[$dropdown->brand] = $dropdown->brand;
        }

        return $dropDownList;
    } else {
        return false;       // return false if no items for dropdown
    }
}