在codeigniter中获取id=$id的所有行 - Get all rows form database where id=$id in codeigniter

Get all rows form database where id=$id in codeigniter

本文关键字：id codeigniter 获取 | 更新日期: 2023-09-27

这是我的代码

 $this -> db -> select('*');
        $this -> db -> from('events');
        $this -> db -> where('user_id',$session_data['id']);

        $query = $this -> db -> get();
        $result = $query->result();
        if($result)
        {
            $events_array = array();
            foreach($result as $row)
            {
                $events_array = array(
                    'id' => $row->id,
                    'title' => $row->title,
                    'ev_img_name' => $row->ev_img_name,
                );
                $this->session->set_userdata('events',$events_array);
            }
            $session_data = $this->session->userdata('events');
            $id = $this->session->userdata('id');
            $data['id'] = $id;
            $data['id'] = $session_data['id'];
            $title = $this->session->userdata('title');
            $data['title'] = $title;
            $data['title'] = $session_data['title'];
            $ev_img_name = $this->session->userdata('ev_img_name');
            $data['ev_img_name'] = $ev_img_name;
            $data['ev_img_name'] = $session_data['ev_img_name'];

它只得到表的第一行，但我需要得到所有行相同的user_id。我怎么能那样做呢?

在foreach中，您正在将值重新分配给相同的数组。尝试使用

 $events_array = array();
 foreach($result as $row)
 {
      $events_array[] = array(
          'id' => $row->id,
          'title' => $row->title,
          'ev_img_name' => $row->ev_img_name,
      );
}
$this->session->set_userdata('events',$events_array);

这样，您将在$events_array .

中拥有返回结果中的所有行。

现在在你的视图中你可以这样做

<?php foreach($events_array as $event) { ?>
   <div class="event">
      Title: <?= $event['title'] ?>
      Image: <br>
      <img src="<?= $event['ev_img_name'] ?>">
   </div>
<?php } ?>

尝试此代码，您可以直接从codeigniter SQL查询中以数组格式获取任何您想要的数据(字段数)，然后将该数组直接设置为会话事件，如下所示，

 $this->db->select('id,title,ev_img_name');
 $this->db->from('events');
 $this->db->where('user_id',$session_data['id']);
 $result = $this->db->get()->result_array();
 if(count($result)>0){
      $this->session->set_userdata('events',$result);
 }