php - 在 codeigniter 中根据 ID 显示表数据

Question

我有一张表，里面存储了ID、ID Login、Name等数据，但我只想显示基于ID Login的数据

这里是我的 Controller :

function index(){
    $data['hasil'] = $this->M_user_lapor->index_model();
    $this->load->view('v_user_lapor/index', $data);
}

我的模型:

function index_model(){
    $baca = $this->db->query('select * from user_lapor');
    if($baca->num_rows() > 0){
        foreach ($baca->result() as $data){
            $hasil[] = array(
                'id_login'=>$data->id_login,
                'id_lapor'=>$data->id_lapor,
                'nm_unit'=>$data->nm_unit,
                'pic_1'=>$data->pic_1,
                'pic_2'=>$data->pic_2,
                'ip_wan'=>$data->ip_wan,
                'ip_lan'=>$data->ip_lan,
                'prov'=>$data->prov,
                'icn_sid'=>$data->icn_sid,
                'tlkm_sid'=>$data->tlkm_sid,
                'status'=>$data->status,

            );
        }
        return json_encode ($hasil);
    }else{
        return false;
    }
}   

查看:

 <tbody>
    <?php
       if ($hasil){
         $no = 1;
         $array = json_decode($hasil, true);
         foreach($array as $data) {
         ?>
       <tr>
          <td class="text-center"><?php echo $no++;?></td>
          <td><?php echo $data['nm_unit'];?></td>
          <td><?php echo $data['pic_1'];?></td>
          <td><?php echo $data['pic_2'];?></td>
          <td><?php echo $data['ip_wan'];?></td>
          <td><?php echo $data['ip_lan'];?></td>
          <td><?php echo $data['prov'];?></td>
          <td><?php echo $data['icn_sid'];?></td>
          <td><?php echo $data['tlkm_sid'];?></td>
       </tr>
       <?php
          }
           }
       ?>
     </tbody>

如您所见，我的模型中有 id_login，我想显示基于它的表数据，希望有人能帮助我，因为我只是在使用 codeigniter，thnaks

Answer 1

我自己解决了这个问题，哈哈。我只是从 session 中传递 id_login 值，所以我将其添加到我的 Controller 中:

function index(){
    $id_login = $this->session->id_login;
    $data['hasil'] = $this->M_user_lapor->index_model($id_login);
    $this->load->view('v_user_lapor/index', $data);
}

并将其调用到我的模型中:

function index_model($id_login){
    $baca = $this->db->query('select * from user_lapor where id_login='.$id_login);
    if($baca->num_rows() > 0){
        foreach ($baca->result() as $data){
            $hasil[] = array(
                'id_login'=>$data->id_login,
                'id_lapor'=>$data->id_lapor,
                'nm_unit'=>$data->nm_unit,
                'pic_1'=>$data->pic_1,
                'pic_2'=>$data->pic_2,
                'ip_wan'=>$data->ip_wan,
                'ip_lan'=>$data->ip_lan,
                'prov'=>$data->prov,
                'icn_sid'=>$data->icn_sid,
                'tlkm_sid'=>$data->tlkm_sid,
                'status'=>$data->status,
            );
        }
        return json_encode ($hasil);
    }else{
        return false;
    }
}