我有两个表Patient(名称,id_paz)和访问(id_visita,id_paz,日期),其中1个患者可能有更多访问。如下所示,我检查错误:“未定义的变量:查询”和“为foreach()提供的参数无效”
模型:
function result_getall(){
$this->db->select('*');
$this->db->from('paziente');
$this->db->join('visita', 'paziente.id_paz = visita.id_visita', 'left');
$query = $this->db->get();
return $query->result($sql);
}
视图:
<?php foreach ($query as $row): ?>
<?php echo $row->id_paz?><br>
<?php echo $row->nome?><br>
<?php echo $row->cognome?><br>
<?php echo $row->id_visita ?>
<?php endforeach; ?>
控制器:
function getall(){
$this->load->model('visita_model');
$data['query'] =$this->visita_model->result_getall();
print_r($data['query']);
die();
$this->load->view('aggiungi_view', $data);
}
最佳答案
也许您的数组未设置。
尝试使用print_r
进行检查,或添加如下if语句:
<?php
if(isset($query)){
foreach ($query as $row): ?>
<?php echo $row->id_paz?><br>
<?php echo $row->nome?><br>
<?php echo $row->cognome?><br>
<?php echo $row->id_visita ?>
<?php endforeach;
}
?>
并在您的控制器中更改以下内容:
return $query->result($sql);
对此:
$return = array();
foreach ($query->result() as $row)
array_push($return, $row);
return $return;
关于php - 与codeigniter连接时出错:变量查询,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/23793186/