Codeigniter从mysql数据库获取值并在html表中显示[关闭]

Codeigniter从mysql数据库获取值并在html表中显示[关闭]

问题描述:

I want to know what is the correct procedure of getting the all rows of the mysql database and showing them in a html table. i know the view is used for the html, model used for the database insert, etc, and controller used between view and model.

An example of the model,view,controller, is fine. Trying to get something like, in a table.

Id  Firstname   Lastname
1   John    Doe
2   Mary    Moe
3   Julie   Dooley

我想知道获取mysql数据库的所有行并在html中显示它们的正确步骤是什么 表。 我知道视图用于html,用于数据库插入的模型等,以及视图和模型之间使用的控制器。 p>

模型,视图,控制器的一个例子很好 。 试着在桌子上找到类似的东西。 p>

  Id名字姓氏
1 John Doe 
2 Mary Moe 
3 Julie Dooley 
  code>  pre> \  n  div>

Make a model to get the records
Lets assume your model name is mymodel

class Mymodel extends CI_Model {

    public function __construct() {
        parent::__construct();
        $this->load->database();
    }
    function getInfos()
    {
        $this->db->select("*");//better select specific columns  
        $this->db->from('YOUR_TABLE_NAME');
        $result = $this->db->get()->result();
        return $result;
    }
}

Now your controller. Lets assume your controller name is mycontroller

class Mycontroller extends  CI_Controller
{
    function __construct() {
        parent::__construct();
        $this->load->model('mymodel');
    }
    public function index()
    {


        $data['infos']=$this->mymodel->getInfos();
        $this->load->view("myview",$data);//lets assume your view name myview

    }

}

Now your view-myveiw.php

<table>
    <thead>
         <tr>
             <th>ID</th>
             <th>Firstname</th>
             <th>Lastname</th>
         </tr>
     </thead>
     <tbody>
         <?php if((sizeof($infos))>0){
                foreach($infos as $info){
                ?>
                    <tr>
                       <td><?php echo $info->Id;?></td>
                       <td><?php echo $info->Firstname;?></td>
                       <td><?php echo $info->Lastname;?></td>
                     </tr>

                <?php
                }
          }else{ ?>
                <tr><td colspan='3'>Data Not Found</td></tr>
           <?php } ?>
     </tbody>


</table>

Hope this help you