Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 实例演示简单分页操作
Blogger Information
Blog 21
fans 0
comment 0
visits 10918
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
实例演示简单分页操作
晨
Original
502 people have browsed it

分页数据准备代码showpages.php

  1. <?php
  2. namespace staff_table;
  3. use PDO;
  4. $db = new PDO('mysql:dbname=phpedu', 'root', 'root');
  5. $page = $_GET['p'] ?? 1;
  6. echo "当前页： p= $page <br>";
  8. $num = 10;
  9. $sql = 'SELECT COUNT(`id`) AS `total` FROM `staff`';
  10. $stmt = $db->prepare($sql);
  11. $stmt->execute();
  12. $stmt->bindColumn('total',$total);
  13. $stmt->fetch(PDO::FETCH_ASSOC);
  14. echo "总记录数量：$total <br>";
  15. $pages = ceil($total / $num);
  16. echo "总页数： $pages <br>";
  17. $offset = ($page - 1) * $num;
  18. echo "偏移量：$offset <br>";
  20. $sql = "SELECT * FROM `staff` LIMIT $offset,$num";
  21. $stmt = $db->prepare($sql);
  22. $stmt->execute();
  23. $staffs = $stmt->fetchAll(PDO::FETCH_ASSOC);

页面展示分页数据presentation.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  3.     <?php 
  4.     require 'showpages.php'
  5.     ?>
  6. <head>
  7.     <meta charset="UTF-8">
  8.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  9.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  10.     <title>页面展示分页数据</title>
  11.     <style>
  12.         table {
  13.             width: 400px;
  14.             border-collapse: collapse;
  15.             text-align: center;
  16.         }
  18.         table th,
  19.         table td {
  20.             border: 1px solid;
  21.             padding: 5px;
  22.         }
  24.         table thead {
  25.             background-color: lightcyan;
  26.         }
  28.         table caption {
  29.             font-size: larger;
  30.             margin-bottom: 8px;
  31.         }
  33.         p>a {
  34.             text-decoration: none;
  35.             color: #555;
  36.             border: 1px solid;
  37.             padding: 5px 10px;
  38.             margin: 10px 2px;
  39.         }
  41.         .active {
  42.             background-color: seagreen;
  43.             color: white;
  44.             border: 1px solid seagreen;
  45.         }
  46.     </style>
  47. </head>
  48. <body>
  49.     <table>
  50.         <caption>员工信息表</caption>
  51.         <thead>
  52.             <tr>
  53.                 <td>ID</td>
  54.                 <td>姓名</td>
  55.                 <td>性别</td>
  56.                 <td>邮箱</td>
  57.             </tr>
  58.         </thead>
  59.         <tbody>
  60.             <?php foreach ($staffs as $staff) : extract($staff) ?>
  61.             <tr>
  62.                 <td><?=$id ?></td>
  63.                 <td><?=$name ?></td>
  64.                 <td><?=($sex ? '女' : '男')?></td>
  65.                 <td><?=$email ?>></td>
  66.             </tr>
  67.              <?php endforeach ?>
  68.         </tbody>
  69.     </table>
  70.     <p>
  71.         <?php for ($i = 1 ; $i <= $pages; $i++) : ?>
  73.             <?php
  74.             $url = $_SERVER['PHP_SELF'] . '?p=' . $i;
  75.             $active = $i == $_GET['p'] ? 'active' : null;
  76.             ?>
  77.             <a href="<?= $url ?>" class="<?= $active ?>"><?= $i ?></a>
  79.         <?php endfor ?>
  80.     </p>
  81. </body>
  82. </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