search

博客列表 >PHP分页_MVC_服务容器综合示例

PHP分页_MVC_服务容器综合示例

大A
大A原创
2020年05月14日 19:45:32790浏览

代码

model.php

  1. <?php
  2. class Db
  3. {
  4.     private $pdo;
  5.     public function __construct()
  6.     {
  7.         $this->pdo = new PDO('mysql:host=localhost;dbname=phpedu', 'root', 'root');
  8.     }
  9. //查询显示数据
  10.     public function table_select($limit, $page, &$count)
  11.     {
  12.         $sql = "SELECT COUNT(*) AS 'count' FROM `staffs`";
  13.         $sql_obj = $this->pdo->prepare($sql);
  14.         $sql_obj->execute();
  15.         $count = ceil($sql_obj->fetch()['count'] / 10);
  16.         $offset = $limit * ($page - 1);
  17.         $sql = "SELECT * FROM `staffs` LIMIT $limit OFFSET $offset";
  18.         $sql_obj = $this->pdo->prepare($sql);
  19.         $sql_obj->execute();
  20.         return $sql_obj->fetchall();
  21.     }
  22.     //更新数据
  23.     public function update($array)
  24.     {
  25.         extract($array);
  26.         $time = strtotime($time);
  27.         $sql = "UPDATE `staffs` SET `name`='$name',`sex`='$sex',`position`='$position',`tel`='$tel',`time`='$time' WHERE `id`='$id'";
  28.         $sql_obj = $this->pdo->prepare($sql);
  29.         $sql_obj->execute();
  30.         if ($sql_obj->rowCount() > 0) :
  31.             return true;
  32.         else :
  33.             return false;
  34.         endif;
  35.     }
  36. //删除数据
  37.     public function del($id)
  38.     {
  39.         $sql="DELETE FROM `staffs` WHERE `id`=$id";
  40.         $sql_obj = $this->pdo->prepare($sql);
  41.         $sql_obj->execute();
  42.         if ($sql_obj->rowCount() > 0) :
  43.             return true;
  44.         else :
  45.             return false;
  46.         endif;
  47.     }
  48. }

view.php

  1. <?php
  2. class View
  3. {
  4.     private $html = <<< head
  5.     <link rel="stylesheet" href="style.css">
  6.     <table>
  7.         <caption>会员管理系统</caption>
  8.         <tr>
  9.         <th>ID</th><th>姓名</th><th>性别</th><th>职业</th><th>电话</th><th>注册时间</th><th>操作</th>
  10.         </tr>
  11.     head;
  12. //显示主页
  13.     public function index($array, $count, $page)
  14.     {
  15.         $path = $_SERVER['PHP_SELF'];
  16.         $tr = <<< tr
  17.             <tr>
  18.             <th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th>
  19.             <tr>
  20.         tr;
  21.         $deit = <<<button
  22.         <button onclick="location.href='%s'">编辑</button>
  23.         <button onclick="location.href='%s'" style="color:red">删除</button>
  24.         button;
  25.         foreach ($array as $value) {
  26.             $time = date('Y/m/d', $value[5]);
  27.             $request_edit = $path . "?action=edit&ID=$value[0]&name=$value[1]&sex=$value[2]&position=$value[3]&tel=$value[4]&time=$time";
  28.             $request_del = $path . '?action=del&id=' . $value[0];
  29.             $html .= sprintf(
  30.                 $tr,
  31.                 $value[0],
  32.                 $value[1],
  33.                 $value[2],
  34.                 $value[3],
  35.                 $value[4],
  36.                 $time,
  37.                 sprintf($deit,  $request_edit, $request_del)
  38.             );
  39.         }
  40.         return $this->html . $html . '</table>' . $this->show_page($count, $page);
  41.     }
  42. //显示分页页码
  43.     private function show_page($count, $page)
  44.     {
  45.         $path = $_SERVER['PHP_SELF'];
  46.         $a = "<a href='$path?p=%s' class='%s'>%s</a>";
  47.         $start = $page - 3;
  48.         if ($start < 1) : $start = 1;
  49.         else : $frist = true;
  50.         endif;
  51.         if ($count - $page < 3) $start = $count - 6;
  52.         if ($page <= 1) $page = 1;
  53.         $html .= sprintf($a, $page - 1 ? $page - 1 : 1, '', '上一页');
  54.         if ($frist && $page > 5) :
  55.             $html .= sprintf($a, 1, '', '1');
  56.             $html .= sprintf($a, 1, '', '2');
  57.         endif;
  58.         for ($i = $start; $i < $start + 7; $i++) {
  59.             $class = $i == $page ? 'active' : '';
  60.             $title = $i;
  61.             if ($i == ($start + 6) && $count - $page > 3) $title = '......';
  62.             if ($frist) : $title = '......';
  63.                 $frist = false;
  64.             endif;
  65.             $html .= sprintf($a, $i, $class, $title);
  66.         }
  67.         if ($count - $page > 4) :
  68.             $html .= sprintf($a, $count - 1, '', $count - 1);
  69.             $html .= sprintf($a, $count, '', $count);
  70.         endif;
  71.         $html .= sprintf($a, ($page + 1) < $count ? $page + 1 : $count, '', '下一页');
  72.         return '<p>' . $html . '</p>';
  73.     }
  75.     public function edit($array)
  76.     {
  77.         extract($array);
  78.         $request = $_SERVER['PHP_SELF'] . '?action=update';
  79.         $html = require('edit.php');
  80.         return sprintf($html, $request, $ID, $name, $sex, $position, $tel, $time);
  81.     }
  82. }

index.php

  1. <?php
  2. require('view.php');
  3. require('model.php');
  4. //服务容器类
  5. class container
  6. {
  7.     private $obj = [];
  8.     public function bind($name, $func)
  9.     {
  10.         $this->obj[$name] = $func;
  11.     }
  13.     public function make($name, $params = [])
  14.     {
  15.         return call_user_func_array($this->obj[$name], $params);
  16.     }
  18.     public function destroy()
  19.     {
  20.         unset($this->obj);
  21.     }
  23. }
  24. //绑定
  25. $con = new container();
  26. $con->bind('Db', function () {
  27.     return new Db();
  28. });
  29. $con->bind('View', function () {
  30.     return new View();
  31. });
  33. $db = $con->make('Db');
  34. $index = $con->make('View');
  35. //判断显示内容
  36. switch (filter_input(INPUT_GET, 'action')) {
  37.     case null:
  38.         $p = $_GET['p'];
  39.         if ($p === null) $p = 1;
  40.         echo $index->index($db->table_select(10, $p, $count), $count, $p);
  41.         break;
  42.     case 'edit':
  43.         echo $index->edit($_GET);
  44.         break;
  45.     case 'del':
  46.         if ($db->del($_GET['id'])) :
  47.             echo '删除成功<br><a href="index.php">返回</a>';
  48.         else :
  49.             echo '删除失败<br><a href="index.php">返回</a>';
  50.         endif;
  51.         break;
  52.     case 'update':
  53.         if ($db->update($_POST)) :
  54.             echo '修改成功<br><a href="index.php">返回</a>';
  55.         else :
  56.             echo '修改失败<br><a href="index.php">返回</a>';
  57.         endif;
  58.         break;
  59.     default:
  61.         break;
  62. }
  63. $con->destroy();

edit.php

  1. <?php
  2. return <<< html
  3. <link rel="stylesheet" href="style.css">
  4. <div>
  5. <h3 class='in'>修改用户信息</h3>
  6.     <form action="%s" method="post">
  7.         <div class='in'>
  8.             <label for="id">ID</label>
  9.             <input type="text" name="id" id="id" value="%s"></div>
  10.         <div class='in'><label for="name">姓名</label>
  11.             <input type="text" name="name" id="name" value="%s"></div>
  12.         <div class='in'><label for="sex">性别</label>
  13.             <input type="text" name="sex" id="sex" value="%s"></div>
  14.         <div class='in'><label for="position">职业</label>
  15.             <input type="text" name="position" id="position" value="%s"></div>
  16.         <div class='in'><label for="tel">电话</label>
  17.             <input type="text" name="tel" id="tel" value="%s"></div>
  18.         <div class='in'><label for="time">注册时间</label>
  19.             <input type="text" name="time" id="time" value="%s"></div>
  20.             <input type="submit" id='submit' value="修改">
  21.     </form>
  22. </div>
  23. html;

style.css

  1. td,
  2. th {
  3.     border: 1px solid black;
  4. }
  6. table {
  7.     width          : 80%;
  8.     border-collapse: collapse;
  9. }
  11. caption {
  12.     font-size: 1.9rem;
  13.     margin   : 10px;
  14. }
  16. body {
  17.     display       : flex;
  18.     flex-direction: column;
  19.     align-items   : center;
  20. }
  22. p {
  23.     margin-top: 20px;
  24. }
  26. p>a {
  27.     text-decoration: none;
  28.     color          : #555;
  29.     border         : 1px solid;
  30.     padding        : 5px 10px;
  31.     margin         : 10px 2px;
  32. }
  34. .active {
  35.     background-color: red;
  36.     color           : white;
  37.     border          : 1px solid red;
  38. }
  40. label {
  41.     width  : 80px;
  42.     display: inline-block;
  43. }
  45. h3 {
  46.     text-align: center;
  47. }
  49. #submit {
  50.     float     : right;
  51.     width     : 100px;
  52.     height    : 30px;
  53.     margin-top: 20px;
  54. }

演示效果

上一条：安全狗服务器(CentOS-7)安装下一条：PHP 分页导航的实践与总结
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多