简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）Melayu（MS）Français（FR）Deutsch（DE）
Home
Article
Q&A
Course
Topic
Download
Game
Dictionary
Recent Updates

博客列表 >PHP基础-查询分页/外部对象的两种注入方式

PHP基础-查询分页/外部对象的两种注入方式

岂几岂几
岂几岂几原创
2020年05月18日 00:33:48735浏览

查询分页

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. */

学习心得

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

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

上一条：PHP实战案例：路由解析下一条：larvael 设置cookei
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多