Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 12月06日_简单MVC框架实现
Blogger Information
Blog 38
fans 1
comment 0
visits 28743
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
12月06日_简单MVC框架实现
fkkf467
Original
637 people have browsed it

1. 目录结构

2. 代码文件

Db.php 

  1. <?php
  3. // 定义命名空间
  4. namespace goods\model;
  6. // 引入外部类的别名
  7. use PDO;
  8. use PDOException;
  10. // 数据库连接类
  11. // 用单例模式实现
  12. class Db
  13. {
  14.     // 连接属性
  15.     public static $pdo = null;
  17.     // 连接方法
  18.     private function connect()
  19.     {
  20.         try {
  21.             self::$pdo = new PDO('mysql:host=localhost;dbname=test','root','root');
  22.         }catch (PDOException $e){
  23.             die('数据库连接失败，错误信息为：' . $e->getMessage());
  24.         }
  25.     }
  27.     // 构造方法私有化
  28.     private function __construct()
  29.     {
  30.         $this->connect();
  31.     }
  33.     public static function getInstance()
  34.     {
  35.         if (is_null(self::$pdo)){
  36.             new self();
  37.         }
  38.         return self::$pdo;
  39.     }
  41.     // 禁用克隆魔术方法
  42.     private function __clone()
  43.     {
  45.     }
  46. }

Model.php 

  1. <?php
  3. namespace goods\model;
  5. require 'Db.php';
  7. use PDO;
  9. // 公共模型类
  10. class Model
  11. {
  12.     public $pdo = null;
  13.     // 该属性用于获取本类的类名
  14.     public $className = self::class;
  16.     // 构造方法实现数据库连接
  17.     public function __construct()
  18.     {
  19.         $this->pdo = Db::getInstance();
  20.     }
  22.     // 查询多条记录
  23.     public function select($table, $where = '', $order = '', $limit = '')
  24.     {
  25.         // 创建SQL语句
  26.         $sql = 'SELECT * FROM ' . $table;
  27.         // 查询条件
  28.         if (!empty($where)) {
  29.             $sql .= ' WHERE ' . $where;
  30.         }
  31.         // 排序方式
  32.         if (!empty($order)) {
  33.             $sql .= ' ORDER BY ' . $order;
  34.         }
  35.         // 分页
  36.         if (!empty($limit)) {
  37.             $sql .= ' LIMIT ' . $limit;
  38.         }
  39.         $sql .= ';';
  40.         // 创建PDO预处理对象
  41.         $stmt = $this->pdo->prepare($sql);
  42.         // 执行查询操作
  43.         if ($stmt->execute()) {
  44.             if ($stmt->rowCount() > 0) {
  45.                 $stmt->setFetchMode(PDO::FETCH_CLASS, $this->className);
  46.                 return $stmt->fetchAll();
  47.             }
  48.         }
  49.         return '查询失败';
  50.     }
  52.     // 查询单条
  53.     public function find($table, $where = '')
  54.     {
  55.         $sql = 'SELECT * FROM ' . $table;
  56.         if (!empty($where)) {
  57.             $sql .= ' WHERE ' . $where;
  58.         }
  59.         $sql .= ' LIMIT 1;';
  60.         $stmt = $this->pdo->prepare($sql);
  61.         if ($stmt->execute()) {
  62.             if ($stmt->rowCount() > 0) {
  63.                 $stmt->setFetchMode(PDO::FETCH_CLASS, $this->className);
  64.                 return $stmt->fetch();
  65.             }
  66.         }
  67.         return '查询失败';
  68.     }
  70.     // 新增记录
  71.     public function insert($table, $data = [])
  72.     {
  73.         $sql = 'INSERT INTO ' . $table . ' SET ';
  74.         if (is_array($data)) {
  75.             foreach ($data as $k => $v) {
  76.                 $sql .= "{$k}='{$v}', ";
  77.             }
  78.         } else {
  79.             return '要以关联数组形式传入数据';
  80.         }
  81.         $sql = rtrim(trim($sql), ',') . ';';
  82.         $stmt = $this->pdo->prepare($sql);
  83.         if ($stmt->execute()) {
  84.             if ($stmt->rowCount() > 0) {
  85.                 return '添加成功了' . $stmt->rowCount() . '条数据';
  86.             }
  87.         }
  88.         return '添加失败';
  89.     }
  91.     // 更新数据
  92.     public function update($table, $data = [], $where = '')
  93.     {
  94.         $sql = "UPDATE {$table} SET ";
  95.         if (is_array($data)) {
  96.             foreach ($data as $k => $v) {
  97.                 $sql .= "{$k}='{$v}', ";
  98.             }
  99.         }
  100.         $sql = rtrim(trim($sql), ',');
  101.         if (!empty($where)) {
  102.             $sql .= ' WHERE ' . $where;
  103.         }
  104.         $stmt = $this->pdo->prepare($sql);
  105.         if ($stmt->execute()) {
  106.             if ($stmt->rowCount() > 0) {
  107.                 return '成功修改了' . $stmt->rowCount() . '条数据';
  108.             }
  109.         }
  110.         return '修改失败';
  111.     }
  113.     // 删除数据
  114.     public function delete($table, $where = '')
  115.     {
  116.         $sql = 'DELETE FROM ' . $table;
  117.         if (!empty($where)) {
  118.             $sql .= ' WHERE ' . $where;
  119.         }
  120.         $stmt = $this->pdo->prepare($sql);
  121.         if ($stmt->execute()) {
  122.             if ($stmt->rowCount() > 0) {
  123.                 return '删除成功了' . $stmt->rowCount() . '条数据';
  124.             }
  125.         }
  126.         return '删除失败';
  127.     }
  129.     public function __destruct()
  130.     {
  131.         $this->pdo = null;
  132.     }
  133. }

Goods.php 

  1. <?php
  3. namespace goods\model;
  5. require 'Model.php';
  7. // 商品类
  8. class Goods extends Model
  9. {
  10.     public $className = self::class;
  11.     private $id;
  12.     private $name;
  13.     private $price;
  14.     private $color;
  15.     private $content;
  16.     private $addtime;
  17.     private $status;
  19.     public function __construct()
  20.     {
  21.         parent::__construct();
  22.         $this->addtime = date('Y/m/d',$this->addtime);
  23.     }
  25.     public function __get($name)
  26.     {
  27.         return $this->$name;
  28.     }
  30.     public function __set($name, $value)
  31.     {
  32.         $this->$name = $value;
  33.     }
  34. }

View.php 

  1. <?php
  4. namespace goods\view;
  6. // 视图类
  7. class View
  8. {
  9.     public function showData($data)
  10.     {
  11.         return $data;
  12.     }
  13.     public function showTable($data)
  14.     {
  15.         $table = '<table>';
  16.         $table .= '<caption>商品信息表</caption>';
  17.         $table .= '<tr><th>商品ID</th><th>商品名称</th><th>商品价格</th><th>商品颜色</th><th>商品描述</th><th>添加时间</th><th>操作</th></tr>';
  18.         if (is_array($data)) {
  19.             foreach ($data as $value){
  20.                 $table .= '<tr>';
  21.                 $table .= '<td>' . $value->id . '</td>';
  22.                 $table .= '<td>' . $value->name . '</td>';
  23.                 $table .= '<td>' . $value->price . '</td>';
  24.                 $table .= '<td>' . $value->color . '</td>';
  25.                 $table .= '<td>' . $value->content . '</td>';
  26.                 $table .= '<td>' . $value->addtime . '</td>';
  27.                 $table .= '<td><a href="./update.php?id=' . $value->id . '" style="margin-right: 20px">修改</a><a href="?id= '. $value->id . '&&func=delete">删除</a></td>';
  28.                 $table .= '</tr>';
  29.             }
  30.         } else {
  31.             $table .= '<tr>';
  32.             $table .= '<td>' . $data->id . '</td>';
  33.             $table .= '<td>' . $data->name . '</td>';
  34.             $table .= '<td>' . $data->price . '</td>';
  35.             $table .= '<td>' . $data->color . '</td>';
  36.             $table .= '<td>' . $data->content . '</td>';
  37.             $table .= '<td>' . $data->addtime . '</td>';
  38.             $table .= '<td><a href="./update.php?id=' . $data->id . '" style="margin-right: 20px">修改</a><a href="?id= '. $data->id . '&&func=delete">删除</a></td>';
  39.             $table .= '</tr>';
  40.         }
  41.         $table .= '</table>';
  42.         return $table;
  43.     }
  45.     public function showResult($result)
  46.     {
  47.         return '<h4>' . $result . '</h4>';
  48.     }
  49. }
  51. echo '<style>
  52. table {
  53.     border-collapse: collapse;
  54.     border: 1px solid;
  56.     margin: 0 auto;
  57. }
  58. caption {
  59.     font-size: 1.4rem;
  60.     margin-bottom: 10px;
  61. }
  62. tr:first-of-type {
  63.     background-color: lightseagreen;
  64. }
  65. th {
  66.     height: 40px;
  67. }
  68. td, th {
  69.     border: 1px solid;
  70.     min-width: 100px;
  71. }
  72. img {
  73.     width: 100px;
  74.     height: 100px;
  75. }
  76. </style>';

Container.php 

  1. <?php
  3. namespace goods\controller;
  5. use Closure;
  7. // 服务容器类
  8. class Container
  9. {
  10.     // 容器属性：用来保存创建对象的方法
  11.     protected $instance = [];
  13.     // 将类的实例化过程绑定到容器中
  14.     public function bind($alias, Closure $process)
  15.     {
  16.         $this->instance[$alias] = $process;
  17.     }
  19.     // 执行容器中的实例化方法
  20.     public function make($alias,$params = [])
  21.     {
  22.         return call_user_func_array($this->instance[$alias],$params);
  23.     }
  24. }

Facade.php 

  1. <?php
  4. namespace goods\controller;
  6. //Facade门面类
  7. class Facade
  8. {
  9.     protected static $container = null;
  10.     protected static $data = [];
  11.     protected static $result = null;
  13.     // 用服务容器将静态属性初始化
  14.     public static function initialize(Container $container)
  15.     {
  16.         static::$container = $container;
  17.     }
  19.     // 用静态代理方式将模型类中的 select() 静态化
  20.     public static function select($model, $table, $where = '', $order = '', $limit = '')
  21.     {
  22.         static::$data = static::$container->make($model)->select($table, $where, $order, $limit);
  23.     }
  25.     // 用静态代理方式将模型类中的 find() 静态化
  26.     public static function find($model, $table, $where = '')
  27.     {
  28.         static::$data = static::$container->make($model)->find($table, $where);
  29.     }
  31.     // 用静态代理方式将模型类中的 insert() 静态化
  32.     public static function insert($model,$table, $data = [])
  33.     {
  34.         static::$result = static::$container->make($model)->insert($table,$data);
  35.     }
  37.     // 用静态代理方式将模型类中的 update() 静态化
  38.     public static function update($model,$table, $data = [], $where = '')
  39.     {
  40.         static::$result = static::$container->make($model)->update($table,$data,$where);
  41.     }
  43.     // 用静态代理方式将模型类中的 delete() 静态化
  44.     public static function delete($model,$table, $where = '')
  45.     {
  46.         static::$result = static::$container->make($model)->delete($table,$where);
  47.     }
  49.     // 用静态代理方式将视图类中的 showData() 静态化
  50.     public static function showData($view)
  51.     {
  52.         return static::$container->make($view)->showData(static::$data);
  53.     }
  55.     // 用静态代理方式将视图类中的 showTable() 静态化
  56.     public static function showTable($view)
  57.     {
  58.         return static::$container->make($view)->showTable(static::$data);
  59.     }
  61.     // 用静态代理方式将视图类中的 showResult() 静态化
  62.     public static function showResult($view)
  63.     {
  64.         return static::$container->make($view)->showResult(static::$result);
  65.     }
  66. }

Controller.php 

  1. <?php
  4. namespace goods\controller;
  6. // 控制器类
  7. class Controller
  8. {
  9.     // 使用构造方法，自动调用Facade里面的初始化方法
  10.     public function __construct(Container $container)
  11.     {
  12.         Facade::initialize($container);
  13.     }
  15.     // 查询多条数据
  16.     public function select($model, $view, $table, $where = '', $order = '', $limit = '')
  17.     {
  18.         Facade::select($model, $table, $where, $order, $limit);
  19.         return Facade::showTable($view);
  20.     }
  22.     // 查询一条
  23.     public function find($model, $view, $table, $where = '')
  24.     {
  25.         Facade::find($model, $table, $where);
  26.         return Facade::showTable($view);
  27.     }
  29.     // 查询一条
  30.     public function find1($model, $view, $table, $where = '')
  31.     {
  32.         Facade::find($model, $table, $where);
  33.         return Facade::showData($view);
  34.     }
  36.     // 添加数据
  37.     public function insert($model, $view, $table, $data = [])
  38.     {
  39.         Facade::insert($model, $table, $data);
  40.         return Facade::showResult($view);
  41.     }
  43.     // 更新数据
  44.     public function update($model, $view, $table, $data = [], $where = '')
  45.     {
  46.         Facade::update($model, $table, $data, $where);
  47.         return Facade::showResult($view);
  48.     }
  50.     // 删除数据
  51.     public function delete($model, $view, $table, $where = '')
  52.     {
  53.         Facade::delete($model, $table, $where);
  54.         return Facade::showResult($view);
  55.     }
  56. }

autoload.php 

  1. <?php
  3. namespace goods;
  4. // 类的自动加载器
  5. spl_autoload_register(function ($className){
  6.     $path = str_replace('\\', '/', $className);
  7.     require dirname(__DIR__) . DIRECTORY_SEPARATOR . $path . '.php';
  8. });

header.php 

  1. <?php
  3. namespace goods;
  5. require __DIR__ . '/autoload.php';
  7. use goods\controller\Container;
  8. use goods\controller\Controller;
  9. use goods\model\Goods;
  10. use goods\view\View;
  12. $container = new Container();
  13. $container->bind('goods', function () {
  14.     return new Goods();
  15. });
  16. $container->bind('tb', function () {
  17.     return new View();
  18. });
  19. $controller = new Controller($container);
  20. ?>

index.php 

  1. <?php
  2. require __DIR__ . '/header.php';
  3. ?>
  5. <!doctype html>
  6. <html lang="en">
  7. <head>
  8.     <meta charset="UTF-8">
  9.     <title>Document</title>
  10. </head>
  11. <body>
  12. <form action="" method="get" style="text-align: center">
  13.     <label for="find">请输入要查找的商品ID</label>
  14.     <input type="text" id="find" name="find" value="">
  15.     <button>查找</button>
  16.     <a href="insert.php"><input type="button" name="insert" value="添加"></a>
  17. </form>
  18. </body>
  19. </html>
  21. <?php
  22. // 查找一条数据
  23. if (!empty($_GET['find'])) {
  24.     $find = $_GET['find'];
  25.     echo $controller->find('goods','tb','goods','id=' . $find);
  26. } else {
  27.     echo $controller->select('goods', 'tb', 'goods');
  28. }
  30. // 删除数据
  31. if (!empty($_GET['func']) && $_GET['func'] == 'delete') {
  32.     echo $controller->delete('goods','tb','goods','id=' . $_GET['id']);
  33. }

insert.php 

  1. <?php
  2. require __DIR__ . '/header.php';
  3. ?>
  4. <!doctype html>
  5. <html lang="en">
  6. <head>
  7.     <meta charset="UTF-8">
  8.     <title>Document</title>
  9. </head>
  10. <body>
  11. <form method="post">
  12.     <p>
  13.     <label for="name">商品名称</label>
  14.     <input type="text" id="name" name="name" value="" required>
  15.     </p>
  16.     <p>
  17.         <label for="price">商品价格</label>
  18.         <input type="text" id="price" name="price" value="" required>
  19.     </p>
  20.     <p>
  21.         <label for="color">商品颜色</label>
  22.         <input type="text" id="color" name="color" value="" required>
  23.     </p>
  24.     <p>
  25.         <label for="content">商品描述</label>
  26.         <input type="text" id="content" name="content" value="" required>
  27.     </p>
  28.     <p>
  29.         <label for="addtime">添加时间</label>
  30.         <input type="date" id="addtime" name="addtime" value="" required>
  31.     </p>
  32.     <button>添加</button>
  33.     <a href="index.php">返回</a>
  34. </form>
  35. </body>
  36. </html>
  38. <?php
  39. $_POST['addtime'] = strtotime($_POST['addtime']);
  40. echo $controller->insert('goods','tb','goods',$_POST);
  41. ?>

update.php 

  1. <?php
  2. require __DIR__ . '/header.php';
  4. if (!empty($_GET['id'])) {
  5.     $result = $controller->find1('goods', 'tb', 'goods', 'id=' . $_GET['id']);
  6. }
  8. ?>
  9. <!doctype html>
  10. <html lang="en">
  11. <head>
  12.     <meta charset="UTF-8">
  13.     <title>Document</title>
  14. </head>
  15. <body>
  16. <form method="post">
  17.     <p>
  18.         <label for="name">商品名称</label>
  19.         <input type="text" id="name" name="name" value="<?php echo $result->name;?>" required>
  20.     </p>
  21.     <p>
  22.         <label for="price">商品价格</label>
  23.         <input type="text" id="price" name="price" value="<?php echo $result->price;?>" required>
  24.     </p>
  25.     <p>
  26.         <label for="color">商品颜色</label>
  27.         <input type="text" id="color" name="color" value="<?php echo $result->color;?>" required>
  28.     </p>
  29.     <p>
  30.         <label for="content">商品描述</label>
  31.         <input type="text" id="content" name="content" value="<?php echo $result->content;?>" required>
  32.     </p>
  33.     <p>
  34.         <label for="addtime">添加时间</label>
  35.         <input type="date" id="addtime" name="addtime" value="<?php echo $result->addtime;?>" required>
  36.     </p>
  37.     <button>修改</button>
  38.     <a href="index.php">返回</a>
  39. </form>
  40. </body>
  41. </html>
  42. <?php
  43. $_POST['addtime'] = strtotime($_POST['addtime']);
  44. echo $controller->update('goods','tb','goods',$_POST,'id=' . $_GET['id']);
  45. ?>

3. 运行效果

4. 总结

经过了几天努力，总算实现了，虽然很简单，但对MVC有了很深刻的理解。

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：看上去流程很流畅, 是不是参考了我几年前录制的一个小教程?哈, 不错, 继续
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post