首先看数据表：
index.php 入口文件
<?php
include "StudentController.php";
StudentController.php 控制器
<?php
require_once ("StudentModel.class.php");
$modelObj = new StudentModel();
$arrs=$modelObj->fetchAll();
include "StudentView.html";
StudentModel.class.php 模型
<?php
class StudentModel{
//获取多行数据
public function fetchAll(){
$db=mysqli_connect("localhost","root","root","myschool");
//构建查询的sql语句
$sql = "select * from students";
$result=$db->query($sql);
while($row=mysqli_fetch_all($result,3)){
$rows=$row;
}
return $rows;
}
}
StudentView.html 视图
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<div align="center">
<h2>显示学生的MVC</h2>
/*前端css显示自己看着办*/
<table width="600" border="1" bordercolor="#ccc" rules="all">
<tr style="
<td>编号</td><td>姓名</td><td>性别</td><td>年龄</td>
</tr>
<?php foreach($arrs as $arr){ ?>
<tr>
<td><?php echo $arr["stuid"]; ?></td>
<td><?php echo $arr["stuname"]; ?></td>
<td><?php echo $arr["stusex"]; ?></td>
<td><?php echo $arr["age"]; ?></td>
</tr>
<?php } ?>
</table>
</div>
</body>
</html>
最后，翠花，上酸菜：
原创文章，作者：jamestackk，如若转载，请注明出处：https://blog.ytso.com/244547.html