PHP MVC操作mysql小案例

首先看数据表：

 

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>

最后，翠花，上酸菜：

posted @ 2022-04-10 17:48  崇尚技术  阅读(63)  评论(0)  编辑  收藏  举报