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

Question

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);  

Answer 1

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>