doukucai0099 2017-12-06 06:41
浏览 14
已采纳

codeIgniter打印结果在视图上失败

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.

  • 写回答

1条回答 默认 最新

  • douyi3307 2017-12-06 06:44
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?