Community Learn Tools Library Leisure
search
English
Home > List of blog posts > PHP实现分页
Blogger Information
Blog 36
fans 1
comment 0
visits 26427
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
640 people have browsed it

php分页操作演示

page.php代码

  1. <?php
  3. namespace _0819;
  5. use PDO;
  7. // 连接
  8. $db = new PDO('mysql:dbname=phpedu', 'root', 'root');
  10. // 1. 页数
  11. $page = $_GET['p'] ?? 1;
  12. echo '当前页数: p = ' . $page . '<br>';
  14. // 2. 数量
  15. $num = 5;
  16. echo '当前数量: num = ' . $num . '<br>';
  19. // 3. 偏移量 = (页数 - 1) * 数量
  20. $offset = ($page - 1) * $num;
  21. echo '当前偏移量: offset = ' . $offset . '<br>';
  23. // 4. 计算总记录数
  24. // SELECT CEIL(COUNT(*)/5) AS `total` FROM `staff`
  25. // SELECT COUNT(*) AS `total` FROM `staff`
  26. $sql = 'SELECT COUNT(*) AS `total` FROM `staff`';
  27. $stmt = $db->prepare($sql);
  28. $stmt->execute();
  29. // 将总数量绑定到一个变量上
  30. $stmt->bindColumn('total', $total);
  31. $stmt->fetch();
  32. echo '当前总记录数量: total = ' . $total . '<br>';
  33. // 5. 计算总页数
  34. // 向上取整
  35. $pages = ceil($total / $num);
  36. echo '当前总页数: pages = ' . $pages . '<br>';
  37. $sql = <<< SQL
  38.     SELECT *
  39.     FROM `staff`
  40.     LIMIT $offset, $num;
  41. SQL;
  43. $stmt = $db->prepare($sql);
  44. $stmt->execute();
  45. $staffs = $stmt->fetchAll(PDO::FETCH_ASSOC);
  46. echo '<hr>';
  49. /**
  50.  * 生成分页码
  51.  *
  52.  * @param integer $page 当前页
  53.  * @param integer $pages 总页数
  54.  * @return array
  55.  */
  56. // function createPages(int $page, int $pages): array
  57. // {
  58. // 当前是第8页, 共计20页
  59. // [1,  ...    6, 7, 8, 9, 10,  ....    20]
  60. // 当前是第10页, 共计20页
  61. // [1,  ...    8, 9, 10, 11, 12,  ....    20]
  63. // 1. 生成与总页数长度相同的递增的整数数组
  64. $pageArr = range(1, $pages);
  66. // 2. 只需要当前和前后二页, 其它页码用 false/null 来标记
  68. $paginate =  array_map(function ($p) use ($page, $pages) {
  69.     return ($p == 1 || $p == $pages || abs($page - $p) <= 2) ? $p : null;
  70. }, $pageArr);
  72. // dump($paginate);
  73. // 去重, 替换
  74. $before = array_unique(array_slice($paginate, 0, $page));
  75. $after = array_unique(array_slice($paginate, $page));
  78. // 用解构进行合并
  79. // return   [...$before, ...$after];
  80. $page_ret =  [...$before, ...$after];
  81. // }
  1. <?php
  2. require 'page.php';
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="zh-CN">
  7. <head>
  8.     <meta charset="UTF-8">
  9.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11.     <title>PHP实现分页</title>
  12. </head>
  13. <style>
  14.     table {
  15.         width: 400px;
  16.         border-collapse: collapse;
  17.         text-align: center;
  18.     }
  20.     table th,
  21.     table td {
  22.         border: 1px solid;
  23.         padding: 5px;
  24.     }
  26.     table thead {
  27.         background-color: lightcyan;
  28.     }
  30.     table caption {
  31.         font-size: larger;
  32.         margin-bottom: 8px;
  33.     }
  35.     body>p {
  36.         display: flex;
  37.     }
  39.     p>a {
  40.         text-decoration: none;
  41.         color: #555;
  42.         border: 1px solid;
  43.         padding: 5px 10px;
  44.         margin: 10px 2px;
  45.     }
  47.     .active {
  48.         background-color: seagreen;
  49.         color: white;
  50.         border: 1px solid seagreen;
  51.     }
  52. </style>
  54. <body>
  55.     <table>
  56.         <caption>员工信息表</caption>
  57.         <thead>
  58.             <tr>
  59.                 <th>ID</th>
  60.                 <th>姓名</th>
  61.                 <th>性别</th>
  62.                 <th>邮箱</th>
  63.             </tr>
  64.         </thead>
  65.         <tbody>
  66.             <?php foreach ($staffs as $staff) : extract($staff) ?>
  67.                 <?php $sex = $sex ? '男' : '女';
  68.                 ?>
  70.                 <tr>
  71.                     <td><?= $id ?>
  72.                     </td>
  73.                     <td><?= $name ?>
  74.                     </td>
  75.                     <td><?= $sex ?>
  76.                     </td>
  77.                     <td><?= $email ?>
  78.                     </td>
  79.                 </tr>
  80.             <?php endforeach ?>
  81.         </tbody>
  82.     </table>
  83.     <p>
  85.         <?php
  87.         $a = $page - 1;
  88.         if ($page <= 0) {
  89.             echo "<script>alert('前面没有了');history.go(-1);</script>";
  90.             $a = 1;
  91.         }
  92.         $dqpage = $_SERVER['PHP_SELF'] . '?p=' . $a;
  93.         ?>
  94.         <a href="<?= $dqpage ?>">上一页</a>
  95.         <?php foreach ($page_ret as $k => $v) : ?>
  96.             <?php
  97.             // 页码跳转的url
  98.             if ($v === null) {
  99.                 $v = '...';
  100.             }
  101.             if ($v === '...') {
  102.                 $url = '#';
  103.             } else {
  104.                 $url =  $_SERVER['PHP_SELF'] . '?p=' . $v;
  105.             }
  106.             // 实现页码高亮
  107.             $page = $_GET['p'] ?? 1;
  108.             $active = ($v == $page) ? 'active' : null;
  109.             ?>
  110.             <a href="<?= $url ?>" class="<?= $active ?>"><?= $v ?></a>
  111.         <?php endforeach ?>
  113.         <?php
  114.         $b = $page + 1;
  115.         if ($page > $pages) {
  116.             echo "<script>alert('后面没有了');history.go(-1);</script>";
  117.             $a = $pages;
  118.         }
  119.         $dqpage = $_SERVER['PHP_SELF'] . '?p=' . $b;
  120.         ?>
  121.         <a href="<?= $dqpage ?>">下一页</a>
  122.     </p>
  123. </body>
  125. </html>

运行效果

Correcting teacher：PHPzPHPz

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