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

如何从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条)

报告相同问题?

悬赏问题

  • ¥50 可视化界面构建,实现信息模块功能
  • ¥15 基于bert-base-chinese的中文文本处理
  • ¥15 高价求抖音抓包技术,抖音抓包无网络问题
  • ¥15 【matlab】已知功率谱密度反求时域信号
  • ¥15 mindspore项目_模型适配
  • ¥15 openstack使用cinder后,实例运行时分配的总空间不能大于ceph的总空间
  • ¥15 [pcl::PLYWriter::writeASCII] Error during opening (?鶂?)!
  • ¥15 得到XY两轴的数据如何绘制成圆,输入整形器
  • ¥29 PHP读取PDF文件添加多个数字签名
  • ¥25 联邦学习vgg修改最后一个全连接层报错(默认是1000个输出,我的改为11就报错,改为200就没问题)