Community Learn Tools Library Leisure
search
English
Home > List of blog posts > PHP基础-查询分页/外部对象的两种注入方式
Blogger Information
Blog 57
fans 3
comment 0
visits 60373
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
PHP基础-查询分页/外部对象的两种注入方式
岂几岂几
Original
741 people have browsed it

查询分页

1. 创建库表和初始数据

player数据表

初始数据(部分)

1. 数据库链接脚本connect.php

  1. <?php
  2. try {
  3.     // PDO对象
  4.     $pdo = new PDO('mysql:host=localhost;dbname=phpedu;port=3306;charset=utf8', 'root', 'root');
  5. } catch (Exception $e) {
  6.     printf('链接异常, 异常信息: %s', $e->getMessage());
  7.     die;
  8. }

2. 封装分页类pagination.php

  1. <?php
  2. class Pagination
  3. {
  4.     // 第一页
  5.     private $start = 1;
  6.     // 一页可容纳的记录数
  7.     private $pageSize = 3;
  8.     // 显示的页码个数
  9.     private $pageNumSize = 5;
  10.     // 显示的页码列表
  11.     private $pageNumList = [];
  12.     // 总页数
  13.     private $pageCount = 0;
  14.     // 页码左右偏移量
  15.     private $pageNumOffset = 0;
  16.     // 当前页码
  17.     private $currentPage = 1;
  18.     // 记录总数
  19.     private $rowCount = 0;
  21.     public function __construct(int $rowCount, int $currentPage = 1, int $pageSize = 3, int $pageNumSize = 5)
  22.     {
  23.         // 初始化各种属性
  24.         $this->rowCount = $rowCount;
  25.         $this->pageSize = $pageSize;
  26.         $this->pageNumSize = $pageNumSize;
  27.         $this->pageNumOffset = ($pageNumSize - 1) / 2;
  28.         $this->pageCount = ceil(floatval($rowCount) / $pageSize);
  29.         /* 当传入的当前页码效于最小页码时，初始化为1；大于最大页码时，初始化为最大页码 */
  30.         $this->currentPage = $currentPage < 1 ? 1 : ($currentPage > $this->pageCount ? $this->pageCount : $currentPage);
  31.         $this->getPageNumList();
  32.     }
  34.     /**
  35.      * 获取要显示的页码列表
  36.      */
  37.     private function getPageNumList()
  38.     {
  39.         // 如果要显示的页码数量>=总页码数量，则显示所有页码。
  40.         if ($this->pageCount <= $this->pageNumSize) {
  41.             $this->pageNumList = range(1, $this->pageCount, 1);
  42.             return;
  43.         }
  45.         // 起始页码，取“当前页码-页码偏移量”和起始页码的最大值。
  46.         $pageNumStart = ($this->currentPage - $this->pageNumOffset) < $this->start ? $this->start : ($this->currentPage - $this->pageNumOffset);
  47.         // 结束页码，取“当前页码+页码偏移量”和总页码数的最小值。
  48.         $pageNumEnd = ($pageNumStart + $this->pageNumSize - 1) > $this->pageCount ? $this->pageCount : ($pageNumStart + $this->pageNumSize - 1);
  49.         // 若结束页码等于总页码，则再计算一次起始页码（避免当前页到结束页码的差值小于页码偏移量的情况）
  50.         if ($pageNumEnd === $this->pageCount) {
  51.             // 起始页码，取“最大页码-要显示的页码数量+1”和起始页码的最大值。
  52.             $pageNumStart = ($this->pageCount - $this->pageNumSize + 1) < $this->start ? $this->start : ($this->pageCount - $this->pageNumSize + 1);
  53.         }
  55.         // 生成要显示的页码数组
  56.         $this->pageNumList = range($pageNumStart, $pageNumEnd, 1);
  57.     }
  59.     // 拼接字符串，形成分页HTML代码字符串。
  60.     public function getPagination()
  61.     {
  62.         $pageHtml = '<div class="pagination">';
  63.         // 首页
  64.         $tmpHtml = $this->currentPage === 1 ? '<span class="pageNum disabled">首页</span>'
  65.             : sprintf('<a class="pageNum" href="%s?p=1&r=%d">首页</a>', $_SERVER['PHP_SELF'], $this->pageSize);
  66.         $pageHtml .= $tmpHtml;
  68.         // 上一页
  69.         $tmpHtml = $this->currentPage === 1 ? '<span class="pageNum disabled">上一页</span>'
  70.             : sprintf('<a class="pageNum" href="%s?p=%d&r=%d">上一页</a>', $_SERVER['PHP_SELF'], $this->currentPage - 1, $this->pageSize);
  71.         $pageHtml .= $tmpHtml;
  73.         // 间隔符
  74.         $tmpHtml = $this->pageNumList[0] >= 2 ? '...' : '';
  75.         $pageHtml .= $tmpHtml;
  77.         // 页码
  78.         foreach ($this->pageNumList as $pageNum) {
  79.             $tmpHtml = $pageNum == $this->currentPage ? sprintf('<span class="active">%d</span>', $pageNum)
  80.                 : sprintf('<a class="pageNum {$pageNum}" href="%s?p=%d&r=%d">%d</a>', $_SERVER['PHP_SELF'], $pageNum, $this->pageSize, $pageNum);
  81.             $pageHtml .= $tmpHtml;
  82.         }
  84.         // 间隔符
  85.         $tmpHtml = $this->pageNumList[array_key_last($this->pageNumList)] + 1 <= $this->pageCount ? '...' : '';
  86.         $pageHtml .= $tmpHtml;
  88.         // 下一页
  89.         $tmpHtml = $this->currentPage >= $this->pageCount ? '<span class="pageNum disabled">下一页</span>'
  90.             : sprintf('<a class="pageNum" href="%s?p=%d&r=%d">下一页</a>', $_SERVER['PHP_SELF'], $this->currentPage + 1, $this->pageSize);
  91.         $pageHtml .= $tmpHtml;
  93.         // 末页
  94.         $tmpHtml = $this->currentPage >= $this->pageCount ? '<span class="pageNum disabled">末页</span>'
  95.             : sprintf('<a class="pageNum" href="%s?p=%d&r=%d">末页</a>', $_SERVER['PHP_SELF'], $this->pageCount, $this->pageSize);
  96.         $pageHtml .= $tmpHtml;
  98.         // 总页码
  99.         $pageHtml .= "<span>共{$this->pageCount}页</span>";
  101.         // 页码跳转表单
  102.         $tmpHtml = "<form action='{$_SERVER['PHP_SELF']}' method='get'> <input type='text' name='p'><input type='hidden' name='r' value='{$this->pageSize}'><button type='submit'>跳转</button></form>";
  103.         $pageHtml .= $tmpHtml;
  105.         $pageHtml .= '</div>';
  107.         return $pageHtml;
  108.     }
  110.     // 直接向浏览器输出分页信息
  111.     public function echoPagination()
  112.     {
  113.         echo $this->getPagination();
  114.     }
  115. }

3.查询球员分页信息脚本player.php

  1. <?php
  2. require('../out.php');
  4. require('connect.php');
  6. // 查询记录总数
  7. $sql = 'SELECT count(`id`) as row_count FROM `player`';
  8. $count = ($pdo->query($sql)->fetch(PDO::FETCH_NUM))[0] ?? 0;
  11. // 单页球员数量
  12. $rowPerPage = ($_GET['r'] && !empty($_GET['r'])) ? $_GET['r'] : 3;
  13. $rowPerPage = filter_var($rowPerPage, FILTER_VALIDATE_INT) ? $rowPerPage : 3;
  14. // 当前页
  15. $currentPage = ($_GET['p'] && !empty($_GET['p'])) ? $_GET['p'] : 1;
  16. $currentPage = filter_var($currentPage, FILTER_VALIDATE_INT, ['option' => []]) ? $currentPage : 1;
  17. $currentPage = $currentPage < 1 ? 1 : ($currentPage > ceil(floatval($count) / $rowPerPage) ? ceil(floatval($count) / $rowPerPage) : $currentPage);
  19. // 查询页面数据
  20. $start = ($currentPage - 1) * $rowPerPage;
  21. $sql = "SELECT * FROM `player` LIMIT {$start}, {$rowPerPage}";
  22. $players = $pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
  24. // 加载显示列表数据的模板
  25. require('player_list.php');

4. 球员信息列表player_list.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  4. <head>
  5.     <meta charset="UTF-8">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>球员列表</title>
  8.     <style>
  9.         @import 'style/page_style.css';
  11.         @import 'style/page_style.css';
  13.         @import 'style/list.css';
  14.     </style>
  15. </head>
  16. <?php
  17. require('pagination.php');
  18. ?>
  20. <body>
  21.     <table cellspacing="0" align="center">
  22.         <caption>球员列表</caption>
  23.         <thead>
  24.             <tr>
  25.                 <th>ID</th>
  26.                 <th>姓名</th>
  27.                 <th>球队</th>
  28.                 <th>身高(cm)</th>
  29.                 <th>体重(kg)</th>
  30.                 <th>位置</th>
  31.                 <th>创建时间</th>
  32.                 <th>修改时间</th>
  33.                 <th>操作</th>
  34.             </tr>
  35.         </thead>
  36.         <tbody>
  37.             <?php if (!empty($players) && count($players) > 0) : ?>
  38.                 <?php foreach ($players as $player) : ?>
  39.                     <tr>
  40.                         <td><?php echo $player['id']; ?></td>
  41.                         <td><?php echo $player['name']; ?></td>
  42.                         <td><?php echo $player['team']; ?></td>
  43.                         <td><?php echo $player['height']; ?></td>
  44.                         <td><?php echo $player['weight']; ?></td>
  45.                         <td><?php echo $player['position']; ?></td>
  46.                         <td><?php echo date('Y-m-d H:i:s', $player['create_time']); ?></td>
  47.                         <td><?php echo date('Y-m-d H:i:s', $player['update_time']); ?></td>
  48.                         <td>
  49.                             <a href="edit_player.php?id=<?php echo $player['id']; ?>&pos=<?php echo urlencode($_SERVER['QUERY_STRING']); ?>">修改</a>
  50.                             <a href="del_player.php?id=<?php echo $player['id']; ?>&name=<?php echo $player['name']; ?>&pos=<?php echo urlencode($_SERVER['QUERY_STRING']); ?>">删除</a>
  51.                         </td>
  52.                     </tr>
  53.                 <?php endforeach; ?>
  54.             <?php else : ?>
  55.                 <tr>
  56.                     <td colspan="9">啥也没查到...</td>
  57.                 </tr>
  58.             <?php endif ?>
  59.         </tbody>
  60.     </table>
  61.     <?php (new Pagination($count, $currentPage, $rowPerPage, 5))->echoPagination();
  62.     ?>
  63.     <?php //echo (new Pagination($count, $currentPage, 3, 5)); 
  64.     ?>
  66. </body>
  68. </html>

5. 处理更新的脚本do_update.php

  1. <?php
  2. require_once('connect.php');
  3. require_once('../out.php');
  6. $sql = "UPDATE `player` SET `name` = :name, `team` = :team, `height` = :height, `weight` = :weight, `position` = :position, `update_time` = :update_time WHERE `id` = :id";
  7. $param = $_POST;
  8. $param['update_time'] = time();
  9. $pos = $param['pos'];
  10. unset($param['pos']);
  12. $stmt = $pdo->prepare($sql);
  13. $stmt->execute($param);
  15. if ($stmt->rowCount() === 1) {
  16. if (empty($pos))
  17. echo ("<script>alert('修改成功');window.history.back();</script>");
  18. else {
  19. $pos = urldecode($pos);
  20. echo ("<script>alert('修改成功');window.location='/0512/player.php?{$pos}';</script>");
  21. }
  22. } else {
  23. echo ("<script>alert('修改失败');</script>");
  24. }

6. 更新球员信息界面edit_player.php

  1. <?php
  2. require 'connect.php';
  3. require('../out.php');
  5. $id = $_GET['id'];
  6. if (empty($id) || !filter_var($id, FILTER_VALIDATE_INT, ['options' => ['min-range' => 1]])) {
  7.     echo ("<script>alert('无效的ID值!');window.history.go(-1);</script>");
  8.     die;
  9. }
  11. $sql = "SELECT * FROM `player` WHERE `id` = ?";
  12. $stmt = $pdo->prepare($sql);
  13. $stmt->execute([$id]);
  15. if ($stmt->rowCount() !== 1) {
  16.     echo ("<script>alert('无效的ID值');window.history.go(-1);</script>");
  17.     die;
  18. }
  20. $player = $stmt->fetch(PDO::FETCH_ASSOC);
  21. ?>
  23. <!DOCTYPE html>
  24. <html lang="en">
  26. <head>
  27.     <meta charset="UTF-8">
  28.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  29.     <title>修改球员信息</title>
  30.     <style>
  31.         @import url('style/common.css');
  33.         @import url('style/edit.css');
  34.     </style>
  35. </head>
  37. <body>
  38.     <section>
  39.         <div class="player-edit-header">修改球员信息</div>
  40.         <div class="player-info">
  41.             <form action="do_update.php" method="post">
  42.                 <input type="hidden" name="id" value="<?php echo $player['id']; ?>">
  43.                 <input type="hidden" name="pos" value="<?php echo $_GET['pos']; ?>">
  44.                 <div class="info-item">
  45.                     <label for="name">姓名: </label>
  46.                     <input type="text" name="name" id="name" value="<?php echo $player['name']; ?>" required autofocus>
  47.                 </div>
  48.                 <div class="info-item">
  49.                     <label for="team">球队: </label>
  50.                     <input type="text" name="team" id="team" value="<?php echo $player['team']; ?>" required>
  51.                 </div>
  52.                 <div class="info-item">
  53.                     <label for="height">身高(cm): </label>
  54.                     <input type="number" name="height" id="height" value="<?php echo $player['height']; ?>" required>
  55.                 </div>
  56.                 <div class="info-item">
  57.                     <label for="weight">体重(kg): </label>
  58.                     <input type="number" name="weight" id="weight" value="<?php echo $player['weight']; ?>" required>
  59.                 </div>
  60.                 <div class="info-item">
  61.                     <label for="position">位置: </label>
  62.                     <input type="text" name="position" id="position" value="<?php echo $player['position']; ?>" required>
  63.                 </div>
  64.                 <div class="info-item">
  65.                     <button type="submit">保存</button>
  66.                 </div>
  67.         </div>
  68.         </form>
  69.     </section>
  70. </body>
  72. </html>

7. 执行删除球员的脚本do_del.php

  1. <?php
  2. require_once('../out.php');
  4. // 球员id
  5. $id = filter_var($_GET['id'], FILTER_VALIDATE_INT, ['options' => ['min_range' => 1]]);
  6. // 球员列表的分页参数
  7. $pos = !empty($_GET['pos']) ? '?' . urldecode($_GET['pos']) : '';
  9. // 无效的id，不处理
  10. if(!$id) {
  11.     echobr("<script>alert('无效的参数');window.location.href='/0512/player.php{$pos}'</script>");
  12. }
  14. require('connect.php');
  16. $sql = "DELETE FROM `player` WHERE `id` = :id";
  18. $stmt = $pdo->prepare($sql);
  19. $stmt->execute(['id' => $id]);
  21. // 判断处理条数
  22. if ($stmt->rowCount() === 1) {
  23.     echobr("<script>alert('删除成功');window.location.href='/0512/player.php{$pos}'</script>");
  24. } else {
  26.     echobr("更新失败");
  27.     printfpre($stmt->errorInfo());
  28.     echobr("<a href='/0512/player.php{$pos}'>返回</a>");
  29. }
  30. ?>

8. 询问是否删除球员的页面del_player.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  6.     <title>确认删除</title>
  7.     <style>
  8.         @import url('style/common.css');
  10.         @import url('style/del.css');
  11.     </style>
  12. </head>
  13. <body>
  14.     <section>
  15.         <span>确认要删除<strong><?php echo $_GET['name'] ?></strong>吗?</span>
  16.         <a href="/0512/player.php<?php echo $_GET['pos'] ? '?' . $_GET['pos'] : ''; ?>" class="btn">取 消</a>
  17.         <a href="do_del.php?id=<?php echo $_GET['id'] ?>&pos=<?php echo urlencode($_GET['pos']) ?>">确 认</a>
  18.     </section>
  19. </body>
  20. </html>

运行效果：

    1. 球员列表, 首页, 首页/上一页按钮不能点击

    1. 指定页面记录数为5的球员列表, 中间页码, 激活首页/上一页按钮

    1. 更新球员信息

    1. 删除球员

外部对象的两种注入方式

1. 球员操作类1(基于构造方法的注入方式)PlayerOpera1.php

  1. <?php
  2. namespace di\operate;
  4. use PDO;
  6. // 基于构造方法的注入方式
  8. class PlayerOpera1 {
  9.     // PDO实例
  10.     private $pdo = null;
  12.     public function __construct($pdo)
  13.     {
  14.         $this->pdo = $pdo;
  15.     }
  17.     /**
  18.      * 查询所有球员信息
  19.      */
  20.     public function allPlayers() {
  21.         return $this->pdo->query("SELECT * FROM `player`")->fetchAll(PDO::FETCH_ASSOC);
  22.     }
  24.     /**
  25.      * 查询某个球员
  26.      */
  27.     public function player($id) {
  28.         if(filter_var($id, FILTER_VALIDATE_INT, ['options' => ['min_range' => 1]]))
  29.             return $this->pdo->query("SELECT * FROM `player` WHERE `id` = {$id}")->fetch(PDO::FETCH_ASSOC);
  30.         else {
  31.             echo('无效的参数');die;
  32.         }
  33.     }
  34. }

2. 球员操作类2(基于类方法参数的注入方式)PlayerOpera2.php

  1. <?php
  2. namespace di\operate;
  4. // 基于方法参数的注入方式
  6. use PDO;
  8. class PlayerOpera2 {
  9.     public function __construct()
  10.     {
  12.     }
  13.     /**
  14.      * 查询所有球员信息
  15.      */
  16.     public function allPlayers(PDO $pdo) {
  17.         return $pdo->query("SELECT * FROM `player`")->fetchAll(PDO::FETCH_ASSOC);
  18.     }
  20.     /**
  21.      * 查询某个球员
  22.      */
  23.     public function player(int $id, PDO $pdo) {
  24.         if(filter_var($id, FILTER_VALIDATE_INT, ['options' => ['min_range' => 1]])) 
  25.             return $pdo->query("SELECT * FROM `player` WHERE `id` = {$id}")->fetch(PDO::FETCH_ASSOC);
  26.         else {
  27.             echo ('无效的参数');die;
  28.         }
  29.     }
  30. }

3. 客户端操作脚本client.php

  1. <?php
  2. namespace di;
  4. require('../out.php');
  5. require('PlayerOpera1.php');
  6. require('PlayerOpera2.php');
  7. use di\operate\PlayerOpera1;
  8. use di\operate\PlayerOpera2;
  10. // 客户端
  11. require('../0512/connect.php');
  12. // 1. 基于构造方法的注入方式
  13. $playerOpera1 = new PlayerOpera1($pdo);
  14. // 查询出所有球员数据
  15. $players = $playerOpera1->allPlayers();
  16. // printfpre($players);
  17. /* result:
  18. Array
  19. (
  20.     [0] => Array
  21.         (
  22.             [id] => 1
  23.             [name] => 勒布朗-詹姆斯
  24.             [team] => 湖人
  25.             [height] => 203
  26.             [weight] => 113
  27.             [position] => F-G
  28.             [create_time] => 1589387682
  29.             [update_time] => 1589477867
  30.         )
  32.     [1] => Array
  33.         (
  34.             [id] => 2
  35.             [name] => 安东尼-戴维斯
  36.             [team] => 湖人
  37.             [height] => 208
  38.             [weight] => 115
  39.             [position] => F-C
  40.             [create_time] => 1589387682
  41.             [update_time] => 1589387682
  42.         )
  43. 略...
  44. */
  46. // 2. 基于方法参数的注入方式
  47. $playerOpera2 = new PlayerOpera2;
  48. // 查询某个球员的信息
  49. $id = 1;
  50. $player = $playerOpera2->player($id, $pdo);
  51. printfpre($player);
  52. /* result:
  53. Array
  54. (
  55.     [id] => 1
  56.     [name] => 勒布朗-詹姆斯
  57.     [team] => 湖人
  58.     [height] => 203
  59.     [weight] => 113
  60.     [position] => F-G
  61.     [create_time] => 1589387682
  62.     [update_time] => 1589477867
  63. )
  64. */

学习心得

  • 分页的实现, 封装成了一个分页类, 可以在其他地方使用, 慢慢体会到封装类带来的代码复用的遍历.

  • 两种注入方式: 当只需要对类中的某个方法中注入外部对象时, 使用基于方法参数的注入即可. 若类中的多个方法都需要注入某个相同的外部对象, 使用基于方法参数的注入方式, 会使得代码冗余. 此时, 使用基于构造方法的注入方式, 把外部对象通过构造方法注入并设定为类的一个属性值, 这样在用到该外部对象的时候, 直接使用指向该外部对象的类属性即可.

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