codeIgniter打印结果在视图上失败

Question

I want to get and send data from MySQL to views in my CodeIgniter.

This is my function in my Model :

public function getProduct()
{
   // EDIT : remove ; from ->from('table') and add ' ' to select ->select('*');
   $a = $this->db->select('*')
             -from('table')
             ->get();
   return $a->result();
}

This is my Function in controller :

public function sendView()
{ 
    $d['product'] = $this->model->getProduct();
    $this->load->view('product', $d);
}

This is my views :

<a href="#"><?php echo $product; ?></a>

It's not getting all product data from MySQL.

Answer 1

You was return the data using result. But, check your model ->from('table'); dont use ; in the end of that row. So, just ->from('table')

So what you need to do in you view is

<?php foreach($product as $pr)
      { ?>
         <a href="#"><?php echo $pr->example_product_name; ?></a>
<?php } ?>

You can try it, change example_product_name into your column_name you wanted to call it.