您一直在尝试从我的数据库中检索记录,但我在几个字段中不断收到此错误“严重性:警告消息:非法字符串偏移”.
这是我的控制器view_logs.php
class View_Logs extends CI_Controller {
function View_Logs()
{
parent::__construct();
}
function Logs(){
$id = $this->uri->segment(3);
$this->load->model('log_listmodel');
$this->log_listmodel->log_list_get($id);
}
}
?>
这是我的模型log_listmodel.php
class Log_Listmodel extends CI_Model{
function Log_Listmodel()
{
parent::__construct();
}
function log_list_get($id){
$query = $this->db->get_where('test_request_log', array('test_request_id' => $id));
//return $query->result();
$results=$query->result_array();
$data['query']=$results[0];
$this->load->view('logs_list_view',$data);
}
}
?>
这是我的视图页面log_list_view.php
Updated | <?php echo $row['id'];?>. | <?php echo $row['new_testing_reason'];?> | <?php echo $row['new_applicant_name'];?> | <?php echo $row['new_authorizer_name'];?> | <?php echo $row['new_received_by'];?> | <?php echo $row['new_test_required'];?> | <?php echo $row['new_laboratory_number'];?> | <?php echo $row['log_date'];?> | <?php echo $row['who'];?> |
解决方法:
您已将$data [‘query’]设置为结果的第一行,但在视图中您正在使用它,因为它将拥有整个数据集.
所以你需要改变
$data['query']=$results[0];
至
$data['query']=$results;
要么
$data['query']=$query->result_array();
标签:php,codeigniter
来源: https://codeday.me/bug/20190723/1508543.html