duandangqin0559
2018-03-06 11:43
浏览 89
已采纳

如何从Codeigniter中的数据库中获取数据..?

I Have A Problem to Fetch Data From Database in Codeigniter .. its gives an Error This is My View:-

       <tr>  
        <td><?php echo $row->Country_id;?></td>  
        <td><?php echo $row->country_name;?></td>  
        </tr>  

Model:-

     //data is retrive from this query  
     $query = $this->db->get('country');  
     return $query->result_array();  

Controller:-

     //load the database  
     $this->load->database();  
     //load the model  
     $this->load->model('select');  
     //load the method of model  
     $data['h']=$this->select->select();  
     //return the data in view  
     $this->load->view('select_view', $data);  
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

4条回答 默认 最新

  • dsyo9700 2018-03-06 11:47
    已采纳

    Your Controller

     $this->load->database();  
     //load the model  
     $this->load->model('select');  
     //load the method of model  
     $data['h']=$this->select->get_data();  //You can change the function name
     //return the data in view  
     $this->load->view('select_view', $data);
    

    Your Model

    $query = $this->db->get('country');
    return $query->result_array();
    

    Your view

    Use foreach loop to show your data

    <tr> 
        <td><?php echo $row['Country_id'];?></td>  
        <td><?php echo $row['country_name'];?></td>  
     </tr> 
    
    评论
    解决 无用
    打赏 举报
查看更多回答(3条)

相关推荐 更多相似问题