我一直在尝试通过控制器函数传递一些变量来建模,以便该变量可以在数据库中的相应查询中使用。这是我的代码
public function chooseGroup()
{
$data['area']=$_GET['area']; //variable from a view source;this is loaded successfully in this function, i have printed an echo to be sure.
$this->load->model('information_model',$data);
$groupdata['rows']= $this->information_model->getGroupDetails();
// var_dump($groupdata);
}
型号代码:
function getGroupDeatils() {
$this->db->select('area'); //area is suppose to contain the value
$q = $this->db->get('group'); //group is the table name
if ($q->num_rows() > 0)
foreach ($q->result() as $rows) {
$data[] = $rows;
}
return $data;
}
由于某种原因,information_model无法识别值 $data['area'],因此未处理查询。我哪里出错了?:(请帮忙!
在控制器中,对模型的调用应如下所示
public function chooseGroup()
{
$data['area']=$_GET['area'];
$this->load->model('information_model');
$groupdata['rows']= $this->information_model->getGroupDetails($data);
}
然后在您的模型中声明如下方法
function getGroupDetail($data) {
// query code here
}