Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 12月06号：小型MVC框架
Blogger Information
Blog 36
fans 2
comment 0
visits 23560
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框架
Rambo-Yang
Original
794 people have browsed it

文件结构

Db.php

  1. namespace mvc;
  2. use PDO;
  3. session_start();
  4. ini_set('date.timezone','Asia/Shanghai');
  6. class Db
  7. {
  8.     //数据库配置信息
  9.     private $dbConfig = [
  10.         'db' => 'mysql',
  11.         'host' => 'localhost',
  12.         'username' => 'root',
  13.         'password' => 'root',
  14.         'dbname' => 'mvc',
  15.     ];
  16.     //新增主键id
  17.     public static $insertId = null;
  18.     //受影响的记录数量
  19.     public static $num = 0;
  20.     //数据库的连接
  21.     private static $pdo = null;
  23.     //构造方法接收参数
  24.     private function __construct(...$params)
  25.     {
  26.         $dsn = "{$this->dbConfig['db']}:host={$this->dbConfig['host']};dbname={$this->dbConfig['dbname']}";
  27.         $username = "{$this->dbConfig['username']}";
  28.         $password = "{$this->dbConfig['password']}";
  29.         try {
  30.             self::$pdo = new PDO($dsn, $username, $password);
  31.         } catch (\PDOException $e) {
  32.             die('数据库连接失败：' . $e->getMessage());
  33.         }
  34.     }
  36.     //单例模式判断连接
  37.     public static function connect(...$params)
  38.     {
  40. //        如果没有实例化 就实例化，已经实例化就返回
  41.         if (is_null(self::$pdo)){
  42.             new self(...$params);
  43.         }
  44.         return self::$pdo;
  45.     }
  46.     //禁止外部访问克隆方法
  47.     private function __clone()
  48.     {
  50.     }
  52.     // 新增，更新，删除操作
  53.     public static function exec($sql)
  54.     {
  55.         $stmt = self::$pdo->prepare($sql);
  56.         $stmt->execute();
  57.         if ($stmt->rowCount()>0){
  58.             //如果是新增操作，初始化新增主键id属性
  59.             if(null !==self::$pdo->lastInsertId()){
  60.                 self::$insertId = self::$pdo->lastInsertId();
  61.             }
  62.            self::$num = $stmt->rowCount();  //返回受影响的记录数量
  63.         }else {
  64.             $error = self::$pdo->errorInfo(); //获取最后操作的错误信息的数组
  66.             //[0]错误标识符[1]错误代码[2]错误信息
  67.             print '操作失败'.$error[0].':'.$error[1].':'.$error[2];
  68.         }
  69.     }
  70.     //获取单条数据
  71.     public static function fetch($sql)
  72.     {
  73.         $stmt = self::$pdo->prepare($sql);
  74.         $stmt->execute();
  76.         return $stmt->fetch(PDO::FETCH_ASSOC);
  77.     }
  78.     //获取多条数据
  79.     public static function fetchAll($sql)
  80.     {
  81.         $stmt = self::$pdo->prepare($sql);
  82.         $stmt->execute();
  83.         return $stmt->fetchAll(PDO::FETCH_ASSOC);
  84.     }
  86. }

Model.php

  1. namespace mvc;
  3. require 'Db.php';
  5. class Model
  6. {
  8.     public $data = null;
  10.     //链接数据库
  11.     public function __construct()
  12.     {
  13.         Db::connect();
  14.     }
  16.     //获取单条数据
  17.     public function get($id)
  18.     {
  19.         $sql = "SELECT * FROM `users` WHERE id = {$id}";
  20.         $this->data = Db::fetch($sql);
  21.         return $this->data;
  22.     }
  24. //    获取多条数据
  25.     public function getAll()
  26.     {
  27.         $sql = "SELECT * FROM `users` WHERE `status` = 1";
  28.         $this->data = Db::fetchAll($sql);
  29.         return $this->data;
  30.     }
  32.     //删除单条数据
  33.     public function del($id)
  34.     {
  35.         $sql = "UPDATE `users` SET `status` = 0 WHERE id = {$id}";
  36.         $this->data = Db::exec($sql);
  37.         return $this->data;
  38.     }
  39. }

Controller.php

  1. //控制器
  2. namespace mvc;
  4. require './model/Model.php';
  5. require './view/View.php';
  7. //服务容器
  8. class Container
  9. {
  10. //    创建容器数组，存放实例方法
  11.     public $int = null;
  13. //放进去，将类实例化过程绑定到容器
  14.     public function bind($alias, \Closure $process)
  15.     {
  16.         $this->int[$alias] = $process;
  17.     }
  19. //取出来，执行容器中的实例方法
  20.     public function make($alias, $params = [])
  21.     {
  22.         //
  23.         return call_user_func_array($this->int[$alias], $params);
  24.     }
  25. }
  27. $container = new Container();
  28. $container->bind('model', function () {return new Model();});
  29. $container->bind('view', function () {return new View();});
  31. //门面模式
  32. class Facade
  33. {
  34.     //接收实例化容器
  35.     protected static $container = null;
  36.     //绑定数据
  37.     protected static $data;
  38.     protected static $id;
  40.     //用服务容器给它初始化, 将容器注入
  41.     public static function initialize(Container $container)
  42.     {
  43.         static::$container = $container;
  44.     }
  46.     //将模型中的方法静态化
  47.     public static function getAll()
  48.     {
  49.         static::$data = static::$container->make('model')->getAll();
  50.     }
  51.     //将模型中的方法静态化--查询单条数据
  52.     public static function get($id)
  53.     {
  54.         static::$id = static::$container->make('model')->get($id);
  55.     }
  56.     //将模型中的方法静态化--删除单条数据
  57.     public static function del($id)
  58.     {
  59.         static::$id = static::$container->make('model')->del($id);
  60.     }
  61.     //将模型中的方法静态化--更新数据
  62.     public static function update($sql)
  63.     {
  64.         static::$id = static::$container->make('model')->del($sql);
  65.     }
  66.     //将视图中的方法静态化
  67.     public static function fetch()
  68.     {
  69.         return static::$container->make('view')->fetch(static::$data);
  70.     }
  71.     //将视图中的方法静态化--单条数据
  72.     public static function find()
  73.     {
  74.         return static::$container->make('view')->find(static::$id);
  75.     }
  76.     //将视图中的方法静态化--删除单条数据
  77.     public static function del1()
  78.     {
  79.         return static::$container->make('view')->del1(static::$id);
  80.     }
  83. }
  85. //创建控制器
  86. class Controller
  87. {
  88.     //初始化,调用 Facade里面的初始化方法
  89.     public function __construct(Container $container)
  90.     {
  91.         Facade::initialize($container);
  92.     }
  94.     //调用单条数据
  95.     public function find($id='')
  96.     {
  97.         $id = isset($_GET['id']) ? $_GET['id'] : $id;
  99.         if (empty($id)){
  100.             die('非法操作');
  101.         }
  102.         //获取数据
  103.         Facade::get($id);
  105.         //渲染模板
  106.         return Facade::find();
  108.     }
  109.     //调用全部数据
  110.     public function getAll()
  111.     {
  112.         Facade::getAll();
  113.         return Facade::fetch();
  114.     }
  116.     //删除单条数据
  117.     public function del1($id='')
  118.     {
  119.        if(@$_SESSION['name'] != 'admin'){
  120.            echo '<script>alert("你不是管理员不能删除数据");history.back();</script>';
  121.            exit();
  122.        }
  123.         $id = isset($_GET['id']) ? $_GET['id'] : $id;
  124.         if (empty($id)){
  125.             die('非法操作');
  126.         }
  127.         Facade::del($id);
  128.         return Facade::del1();
  129.     }
  130.     //登录
  131.     public function login()
  132.     {
  133.         require dirname(__DIR__).'/'.'login.php';
  134.     }
  135.     //验证登录
  136.     public function check()
  137.     {
  138.         require dirname(__DIR__).'/'.'check.php';
  139.     }
  140.     //退出登录
  141.     public function logout()
  142.     {
  143.         require dirname(__DIR__).'/'.'logout.php';
  144.     }
  145. }
  146. $controller = new Controller($container);

View.php

  1. //视图:渲染数据
  2. namespace mvc;
  4. class View
  5. {
  6.     //获取所有数据
  7.     public function fetch($data)
  8.     {
  10.         $table = '<table align="center" cellpadding="10">';
  11.         $table .= '<caption>学生信息表</caption>';
  12.         $table .= '<tr><th>ID</th><th>姓名</th><th>性别</th><th>爱好</th><th>录入时间</th><th>操作</th></tr>';
  13.         foreach ($data as $item){
  14.             $item['sex'] = $item['sex']==1 ? '男' : '女';
  15.             $item['entry_time'] = date('Y-m-d H:i:s',$item['entry_time']);
  16.             $table .='<tr>';
  17.             $table .='<td>'. $item['id'].'</td>';
  18.             $table .='<td>'. $item['name'].'</td>';
  19.             $table .='<td>'. $item['sex'] . '</td>';
  20.             $table .='<td>'. $item['hobby'].'</td>';
  21.             $table .='<td>'. $item['entry_time'].'</td>';
  22.             $table .='<td><a href="?a=find&id=' . $item['id'] . '">详细  </a><a href="?a=del1&id=' . $item['id'] . '">  删除</a></td>';
  23.             $table .= '</tr>';
  24.         }
  25.         $table .= '</table>';
  26.         $table .= '<p align="center">共计 ' . count($data). ' 条数据</p> ';
  27.         return $table;
  28.     }
  29.     //获取单条数据
  30.     public function find($data)
  31.     {
  33.         $table = '<table align="center" cellpadding="10">';
  34.         $table .= '<caption>学生信息表</caption>';
  35.         $table .= '<tr><th>ID</th><th>姓名</th><th>性别</th><th>手机</th>
  36.                     <th>爱好</th><th>生日</th><th>录入时间</th><th>状态</th></tr>';
  38.             $data['sex'] = $data['sex']==1 ? '男' : '女';
  39.             $data['entry_time'] = date('Y-m-d H:i:s',$data['entry_time']);
  40.             $data['status'] = $data['status']==1 ? '正常' : '已删除';
  41.             $table .='<tr>';
  42.             $table .='<td>'. $data['id'].'</td>';
  43.             $table .='<td>'. $data['name'].'</td>';
  44.             $table .='<td>'. $data['sex'] . '</td>';
  45.             $table .='<td>'. $data['tel'].'</td>';
  46.             $table .='<td>'. $data['hobby'].'</td>';
  47.             $table .='<td>'. $data['birthday'].'</td>';
  48.             $table .='<td>'. $data['entry_time'].'</td>';
  49.             $table .='<td>'. $data['status'].'</td>';
  51.             $table .= '</tr>';
  53.         $table .= '</table>';
  54.         return $table;
  55.     }
  56.     //删除单条数据
  57.     public function del1($data)
  58.     {
  59.         return '成功删除了' .Db::$num. '条数据';
  60.     }
  61. }
  63. echo '<style>
  64. a { text-decoration: none; color: #333;}
  65. table a:first-of-type{ color: red}
  66. table {border-collapse: collapse; border: 1px solid; width: 60%; text-align: center }
  67. caption {font-size: 1.2rem; margin-bottom: 10px;}
  68. tr:first-of-type { background-color:lightblue;}
  69. td,th {border: 1px solid}
  70. td:first-of-type {text-align: center}
  71. </style>';

index.php

  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  6.     <title>首页</title>
  7.     <style>
  8.         body {
  9.             text-align: center
  10.         }
  12.         nav {
  13.             width: 60%;
  14.             margin: 20px auto;
  15.             height: 40px;
  16.             background: #444;
  17.             line-height: 40px;
  18.             padding: 0 20px;
  19.         }
  21.         nav a {
  22.             font-size: 16px;
  23.             color: #fff;
  24.             padding: 0 10px;
  25.         }
  26.     </style>
  27. </head>
  28. <body>
  29. <?php
  30. require 'controller/Controller.php';
  31. ?>
  32. <nav><a href="/">首页</a>
  33.     <?php if (isset($_SESSION['name'])) {
  34.         echo '<a >' . $_SESSION['name'] . '</a><a href="index.php?a=logout">退出</a>';
  35.     } else {
  36.         echo '<a href="index.php?a=login">登录</a>';
  37.     } ?>
  38. </nav>
  39. <?php
  40. //获取方法
  41. $a = isset($_GET['a']) ? $_GET['a'] : 'getAll';
  42. //执行控制器方法
  43. echo $controller->$a();
  44. ?>
  45. </body>
  46. </html>

login.php

  1. <?php
  2. if(isset($_SESSION['name'])){
  3.     echo '<script>alert("你已登录，请不要重复登录");location.assign("index.php");</script>';
  4. }
  5. ?>
  7. <h2>用户登陆</h2>
  8. <form action="index.php?a=check" method="post">
  9.     <p>
  10.         用户名：<input type="text" name="name">
  11.     </p><p>
  12.         密码：<input type="password" name="pwd">
  13.     </p>
  14.     <p>
  15.         <input type="submit" value="提交">
  16.     </p>
  17. </form>

check.php

  1. namespace mvc;
  2. //print_r($_SERVER);
  3. if ($_SERVER['REQUEST_METHOD'] === 'POST'){
  4.     $name = $_POST['name'];
  5.     $pwd = md5($_POST['pwd']);
  7.     Db::connect();
  8.     $sql = "SELECT * FROM `admin` WHERE `username` = '{$name}' AND `password` = '{$pwd}'";
  9.     $user = Db::fetch($sql);
  11.     if(false === $user){
  12.         echo '<script>alert("账号或密码错误");history.back();</script>';
  13.         die();
  14.     }
  16.     $_SESSION['name'] = $user['username'];
  17.     echo '<script>alert("登录成功");location.assign("index.php");</script>';
  18.     exit();
  19. }else{
  20.     die("非法操作");
  21. }

logout.php

  1. if(isset($_SESSION['name'])){
  2.     session_destroy();
  3.     echo '<script>alert("退出成功");location.assign("index.php");</script>';
  4. }else{
  5.     echo '<script>alert("请先登录");location.assign("login.php");</script>';
  6. //    echo '<script>alert("请先登录");location.assign("login.php");</script>';
  7. }

总结

  • 又看了几遍老师录的从零开始开发框架，模仿着写，总算跑起来了。写的很乱，很lower，修改数据和添加数据传参没有思路，还不知道怎么下手。
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