我想知道是否有人可以帮助我.我有一个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;
}
写它的另一种方法是：
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
}
}
