您不应该从视图中调用模型。而是
$data['groups']在加载视图之前尝试调用模型和设置。
也不要在模型中回显行结果,除非您希望将其显示在页面上。
控制器:
<?php if ( ! defined('basePATH')) exit('No direct script access allowed');class Delivery_controller extends CI_Controller{ public function __construct() { parent::__construct(); $this->load->model('delivery_model'); } public function index() { $data['title']= 'Warehouse - Delivery'; $data['groups'] = $this->delivery_model->getAllGroups(); $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); }}模型:
public function __construct() { parent::__construct(); } function getAllGroups() { $query = $this->db->query('SELECt description FROM location'); return $query->result(); //echo 'Total Results: ' . $query->num_rows(); }视图:
<select > <?php foreach($groups as $row) { echo '<option value="'.$row->description.'">'.$row->description.'</option>'; } ?> </select>


