Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 分页展示数据—-上一页、下一页/仿PHP中文网分页
Blogger Information
Blog 20
fans 0
comment 0
visits 8140
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中文网分页
P粉191340380
Original
450 people have browsed it

仿PHP中文网分页

  1. <?php 
  2. require 'page_refer.php' ;
  4. // $pageChange = createPages()
  5. // use PDO;
  7. // 连接
  8. $db = new PDO('mysql:dbname=phpedu', 'root', 'root');
  10. // 1. 页数
  11. $page = $_GET['p'] ?? 1;
  13. // 2. 数量
  14. $num = 5;
  16. // 3. 偏移量 = (页数 - 1) * 数量
  17. $offset = ($page - 1) * $num;
  19. // 4. 计算总记录数
  20. $sql = 'SELECT COUNT(*) AS `total` FROM `staff`';
  21. $stmt = $db->prepare($sql);
  22. $stmt->execute();
  23. // 将总数量绑定到一个变量上
  24. $stmt->bindColumn('total', $total);
  25. $stmt->fetch();
  27. $sql = <<< SQL
  28.     SELECT *
  29.     FROM `staff`
  30.     LIMIT $offset, $num;
  31. SQL;
  33. $stmt = $db->prepare($sql);
  34. $stmt->execute();
  35. $staffs = $stmt->fetchAll(PDO::FETCH_ASSOC);
  37.     // 表示第5页, 一共有20页
  38.     $page = $_GET['page'] ?? 1;
  39.     $pagelist = createPages($page, 20);
  42. ?>
  44. <!DOCTYPE html>
  45. <html lang="zh-CN">
  47. <head>
  48.     <meta charset="UTF-8">
  49.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  50.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  51.     <title>分页展示数据</title>
  52.     <style>
  53.         table {
  54.             width: 500px;
  55.             border-collapse: collapse;
  56.             text-align: center;
  57.         }
  59.         table th,
  60.         table td {
  61.             border: 1px solid;
  62.             padding: 5px;
  63.         }
  65.         table thead {
  66.             background-color: lightcyan;
  67.         }
  69.         table caption {
  70.             font-size: larger;
  71.             margin-bottom: 8px;
  72.         }
  74.         body>p {
  75.             display: flex;
  76.         }
  78.         p>a {
  79.             text-decoration: none;
  80.             color: #555;
  81.             border: 1px solid;
  82.             padding: 5px 10px;
  83.             margin: 10px 2px;
  84.         }
  86.         .active {
  87.             background-color: seagreen;
  88.             color: white;
  89.             border: 1px solid seagreen;
  90.         }
  91.     </style>
  92. </head>
  94. <body>
  95.     <table>
  96.         <caption>员工信息表</caption>
  97.         <thead>
  98.             <tr>
  99.                 <th>ID</th>
  100.                 <th>姓名</th>
  101.                 <th>性别</th>
  102.                 <th>邮箱</th>
  103.             </tr>
  104.         </thead>
  105.         <tbody>
  106.                 <?php foreach ($staffs as $staff) :extract($staff) ?>
  107.             <tr>
  108.                 <td><?=$id?>
  109.                 </td>
  110.                 <td><?=$name?>
  111.                 </td>
  112.                 <td><?=$sex?>
  113.                 </td>
  114.                 <td><?=$email?>
  115.                 </td>
  116.             </tr>
  117.             <?php endforeach ?>
  118.         </tbody>
  119.     </table>
  120.     <p>
  121.         <?php $url = 'http://phpedu.io/0819/demo4.php?page=' ?>
  122.         <?php foreach ($pagelist as $staff) : ?>
  123.             <?php if(isset($staff)): ?>
  124.              <a href="<?php echo $url . $staff; ?>"<?php echo $page == $staff ? 'class="active"' : null ?>><?=$staff ?></a>
  125.             <?php else: ?>
  126.                 <a>......</a>
  127.             <?php endif ?>
  128.             <?php endforeach ?>
  129.         <!-- <?php for ($i=1; $i <= $pages; $i++): ?> -->
  131.         <?php
  133.             // 实现页码高亮
  134.             $page = $_GET['p'] ?? 1;
  135.             $active = ($i == $page) ? 'active' : null;
  137.             ?>
  139.         <!-- <a href="<?=$url?>"
  140.             class="<?=$active?>"><?=$i?></a> -->
  141.         <?php endfor ?>
  144.         <br>
  145.         </p>
  146. </body>
  148. </html>

Correction status：Uncorrected

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