php 取数据库值到下拉列表,php – 将数据从数据库显示到下拉列表CodeIgniter

我从db到dropdown的显示数据有困难.

这是我尝试过的：

Model.php

public function __construct()

{

parent::__construct();

}

function getAllGroups()

{

/*

$query = $this->db->get('location');

foreach ($query->result() as $row)

{

echo $row->description;

}*/

$query = $this->db->query('SELECT description FROM location');

foreach ($query->result() as $row)

{

echo $row->description;

}

//echo 'Total Results: ' . $query->num_rows();

}

Controller.php这样

class Delivery_controller extends CI_Controller{

public function __construct()

{

parent::__construct();

$this->load->model('delivery_model');

}

public function index()

{

$data['title']= 'Warehouse - Delivery';

$this->load->view('include/header',$data);

$this->load->view('include/navbar',$data);

$this->load->view('delivery_view', $data);

$this->load->view('include/sidebar',$data);

$this->load->view('include/footer',$data);

$data['groups'] = $this->delivery_model->getAllGroups();

}

}

View.php

$data = $this->delivery_model->getAllGroups();

foreach($description as $each)

{ ?><?php echo $each['description']; ?>';

?>

但结果显示在我的页面顶部.它没有出现在下拉列表中.我在这里做错了什么？非常感谢帮助.谢谢.