我无法将变量从控制器传递到Codeigniter中的视图

Question

I get error saying:

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: data

Filename: views/businessinfo_view.php

My model:

function getPosts(){
   $query = $this->db->query("SELECT * FROM customer WHERE 
   customer_id=12;");           
   return $query->result_array();
}

My controller:

 function ind() {
   $data['customerinfo'] = $this->user_model->getPosts(); 
   $this->load->view('businesssinfo_view', $data); 
 }

MY view:

<?php foreach($data as $d){?>
 <tr>
     <td><?php echo $d->customer_id;?></td>
     <td><?php echo $d->first_name);?></td>
  </tr>     
<?php }?>  

I tried 100 different ways, still can pass the variables, I know my query is correct, I can fetch and echo data in controller, I can't just pass it into view. someone please help me!

Answer 1

Try if you have the $data['customerinfo'] then on the view you would use like $customerinfo

http://www.codeigniter.com/user_guide/general/views.html#creating-loops

Controller

function ind() {
  $data['customerinfo'] = array();
  $data['customerinfo'] = $this->user_model->getPosts(); 
  $this->load->view('businesssinfo_view', $data); 
}

Model

function getPosts(){
   $this->db->where('customer_id', '12');
   $query = $this->db->get('customer');
   return $query->result_array();
}

View

<?php foreach($customerinfo as $d){?>
 <tr>
     <td><?php echo $d['customer_id'];?></td>
     <td><?php echo $d['first_name'];?></td>
  </tr>     
<?php }?>  

When model function returns result_array() <?php echo $d['first_name'];?>

When model function returns result() <?php echo $d->first_name;?>

Example found here