Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 12月6号作业 MVC小案例
Blogger Information
Blog 34
fans 2
comment 0
visits 23154
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月6号作业 MVC小案例
遗忘了寂寞
Original
553 people have browsed it

文件目录

controller/StaffsController.php

  1. <?php
  2. // 控制器
  3. class StaffsController
  4. {
  5.     //获取全部数据
  6.     public function listAll()
  7.     {
  8.         //实例化模型，获取数据
  9.         $sta = new StaffsModel();
  10.         $data = $sta->getAll();
  11.         require 'view/StaffslistAll.php';
  12.     }
  13.     //获取单条数据
  14.     public function info($id=1)
  15.     {
  16.         $id = isset($_GET['id']) ? $_GET['id'] : $id;
  17.         $sta = new StaffsModel();
  18.         $data = $sta->get($id);
  19.         require 'view/Staffslistinfo.php';
  21.     }
  22. }

model/db.php

  1. <?php
  3. //数据库的基本操作
  4. class Db
  5. {
  6.     //数据库的基本参数
  7.     private $dbConfig=[
  8.         'type' => 'mysql',            //数据库类型
  9.         'host' => 'localhost',        //服务器地址
  10.         'dbname' => 'tj_ys',        //数据库名称
  11.         'username' => 'root',        //用户名
  12.         'password' => '123123'        //密码
  13.     ];
  14.     //单例模式，保存本类实例
  15.     private static $instance = null;
  16.     //保存数据库连接实例
  17.     private static $conn = null;
  18.     //新增ID
  19.     public $insertID = null;
  20.     //受影响的数量
  21.     public $num = 0;
  22.     //构造方法私有化，
  23.     private function __construct($params)
  24.     {
  25.         //初始化连接参数
  26.         $this->dbConfig = array_merge($this->dbConfig,$params);
  28.         //连接数据库
  29.         $this->connect();
  30.     }
  31.     //克隆方法私有化，
  32.     private function __clone()
  33.     {
  35.     }
  36.     //获取当前类的单一实例
  37.     public static function getInstance($params=[])
  38.     {
  39.         if(!self::$instance instanceof self){
  40.             self::$instance=new self($params);
  41.         }
  42.         return self::$instance;
  43.     }
  44.     //数据库连接
  45.     private function connect()
  46.     {
  48.         try {
  49.             //连接参数
  50.             $dsn = "{$this->dbConfig['type']}:host={$this->dbConfig['host']};dbname={$this->dbConfig['dbname']}";
  51.             //数据库连接
  52.             $this->conn = new PDO($dsn, $this->dbConfig['username'], $this->dbConfig['password']);
  55.         } catch (PDOException $e) {
  56.             die('连接失败' . $e->getMessage());
  57.         }
  58.     }
  59.     //数据表的写操作，新增、更新、删除
  60.     //返回受影响的记录数，如果是新增返回新增ID
  61.     public function exec($sql)
  62.     {
  63.         $num = $this->conn->exec($sql);
  64.         if ($num > 0){
  65.             // 如果是新增返回新增ID
  66.             if ($this->conn->lastInsertId() !== null){
  67.                 $insertID = $this->conn->lastInsertId();
  68.             }
  69.             $this->num = $num;    //返回受影响的数量
  70.         }else{
  71.             $error = $htis->conn->errorInfo();    //获取最后操作的错误信息的数组
  72.             //[0]:错误标识符；[1]:错误代码；[2]:错误信息
  73.             print '操作失败' . $error[0] . ': ' . $error[1] . ': ' . $error[2];
  74.         }
  75.     }
  76.     //查询操作：获取单条数据
  77.     public function fetch($sql)
  78.     {
  79.         return $this->conn->query($sql)->fetch(PDO::FETCH_ASSOC);
  80.     }
  82.     //查询操作：获取多条数据
  83.     public function fetchAll($sql)
  84.     {
  85.         return $this->conn->query($sql)->fetchAll(PDO::FETCH_ASSOC);
  86.     }
  89. }

model/Model.php

  1. <?php
  3. //公共模型
  4. class Model
  5. {
  6.     protected $db = null;    //数据库连接对象
  7.     public $data = null;    //当前数据内容
  9.     public function __construct()
  10.     {
  11.         $this->init(); //完成数据连接
  12.     }
  14.     private function init()
  15.     {
  16.         $dbConfig=[
  17.             'dbname' => 'tj_ys',        //数据库名称
  18.             'username' => 'root',        //用户名
  19.             'password' => '123123'
  20.         ];
  21.         $this->db = Db::getInstance($dbConfig);
  22.     }
  24.     //获取全部数据
  25.     public function getAll()
  26.     {
  27.         $sql="SELECT * FROM staffs";
  28.         return $this->data = $this->db->fetchAll($sql);
  29.     }
  30.     //获取全部数据
  31.     public function get($id)
  32.     {
  33.         $sql="SELECT * FROM staffs WHERE id = {$id}";
  34.         return $this->data = $this->db->fetch($sql);
  35.     }
  38. }

model/StaffsModel.php

  1. <?php
  2. // 用户自定义模型
  3. class StaffsModel extends Model
  4. {
  6. }

view/StaffslistAll.php

  1. <!DOCTYPE html>
  2. <html lang="zh">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  6.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  7.     <title></title>
  8.     <style>
  9.     table {border-collapse: collapse; border: 1px solid; width: 500px;height: 150px}
  10.     caption {font-size: 1.2rem; margin-bottom: 10px;}
  11.     tr:first-of-type { background-color:lightblue;}
  12.     td,th {border: 1px solid}
  13.     td:first-of-type {text-align: center}
  14.     </style>
  15. </head>
  16. <body>
  18.     <table>
  19.         <caption><h2>人物信息表</h2></caption>
  20.         <tr>
  21.             <th>ID</th>
  22.             <th>姓名</th>
  23.             <th>职位</th>
  24.             <th>操作</th>
  25.         </tr>
  26.         <?php foreach($data as $data_sta): ?>
  28.         <tr>
  29.             <td><?php echo $data_sta['id']; ?></td>
  30.             <td><?php echo $data_sta['name']; ?></td>
  31.             <td><?php echo $data_sta['position']; ?></td>
  32.             <td><a href="index.php?a=info&id=<?php echo $data_sta['id']; ?>">查看详情</a></td>
  33.         </tr>
  34.         <?php endforeach;  ?>
  36.     </table>
  37.     总计：<?php echo count($data); ?>条记录
  38. </body>
  39. </html>

view/Staffslistinfo.php

  1. <!DOCTYPE html>
  2. <html lang="zh">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  6.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  7.     <title></title>
  8.     <style>
  9.     table {border-collapse: collapse; border: 1px solid; width: 500px;height: 150px}
  10.     caption {font-size: 1.2rem; margin-bottom: 10px;}
  12.     td,th {border: 1px solid}
  13.     td:first-of-type {text-align: center}
  14.     </style>
  15. </head>
  16. <body>
  18.     <table>
  19.         <caption><h2><?php echo $data['name']; ?>个人信息表</h2></caption>
  20.         <tr>
  21.             <th>ID</th>
  22.             <th><?php echo $data['id']; ?></th>
  24.         </tr>
  25.         <tr>
  26.             <th>姓名</th>
  27.             <th><?php echo $data['name']; ?></th>
  29.         </tr>
  30.         <tr>
  31.             <th>年龄</th>
  32.             <th><?php echo $data['age']; ?></th>
  34.         </tr>
  35.         <tr>
  36.             <th>性别</th>
  37.             <th><?php echo $data['sex']; ?></th>
  39.         </tr>
  40.         <tr>
  41.             <th>职位</th>
  42.             <th><?php echo $data['position']; ?></th>
  44.         </tr>
  45.     </table>
  46.     <a href="index.php?a=listAll">显示全部信息</a>
  47. </body>
  48. </html>

index.php

  1. <?php
  2. //入口文件
  3. //加载模型类
  4. require 'model/db.php';
  5. require 'model/Model.php';
  6. require 'model/StaffsModel.php';
  7. //获取控制器名称
  8. $controller = isset($_GET['c']) ? $_GET['c'] : 'Staffs';
  9. //控制器加后缀
  10. $controller .='Controller';
  11. //加载控制器类
  12. require 'controller/' . $controller . '.php';
  14. // 获取方法
  15. $action =  isset($_GET['a']) ? $_GET['a'] : 'listAll';
  17. $Sta = new $controller();
  18. $Sta->$action();

运行图

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