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