search

博客列表 >12月06日_简单MVC框架实现

12月06日_简单MVC框架实现

fkkf467
fkkf467原创
2019年12月12日 12:55:16635浏览

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有了很深刻的理解。

上一条：域名是否被微信拦截，微信域名检测api接口分享下一条：029-12月05日-PHP第19节-单例、工厂模式、依赖注入、面向接口编程等
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多