Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 分页基本操作
Blogger Information
Blog 47
fans 0
comment 0
visits 21078
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
分页基本操作
P粉036614676
Original
347 people have browsed it

1.分页文件

  1. <?php
  2. /**
  3.  *  $total :总信息条数
  4.  *
  5.  */
  6. $db = new PDO('mysql:host=localhost;dbname=test','root','901026yk');
  7. $sql = <<<SQL
  8. select count(*) as total from student;
  9. SQL;
  10. $stmt1 = $db->prepare($sql);
  11. $stmt1->execute();
  12. $stmt1->bindColumn(1,$total);
  13. $stmt1->fetch(PDO::FETCH_ASSOC);
  14. //获取总条数
  16. $page = $_GET['p'] ?? 1;
  17. $num = 2;   //每页显示的数据条数
  18. $pages = ceil($total/$num);
  20. $offset = ($page - 1) * $num;
  21. $sql = <<<SQL
  22. select * from student limit $offset,$num;
  23. SQL;
  24. $stmt = $db->prepare($sql);
  25. $stmt->execute();
  26. $staff = $stmt->fetchAll(PDO::FETCH_ASSOC);

2.显示文件

  1. <?php include './demo01.php' ?>
  3. <!DOCTYPE html>
  4. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  8.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  9.     <title>Document</title>
  10. <style>
  11.     table {
  12.         width: 400px;
  13.         border-collapse: collapse;
  14.         text-align: center;
  15.     }
  17.     table th,
  18.     table td {
  19.         border: 1px solid;
  20.         padding: 5px;
  21.     }
  23.     table thead {
  24.         background-color: lightcyan;
  25.     }
  27.     table caption {
  28.         font-size: larger;
  29.         margin-bottom: 8px;
  30.     }
  32.     body>p {
  33.         display: flex;
  34.     }
  36.     p>a {
  37.         text-decoration: none;
  38.         color: #555;
  39.         border: 1px solid;
  40.         padding: 5px 10px;
  41.         margin: 10px 2px;
  42.     }
  44.     .active {
  45.         background-color: seagreen;
  46.         color: white;
  47.         border: 1px solid seagreen;
  48.     }
  49. </style>
  50. </head>
  51. <body>
  52. <table>
  53.     <caption>员工信息表</caption>
  54.     <thead>
  55.     <tr>
  56.         <th>学号</th>
  57.         <th>姓名</th>
  58.         <th>性别</th>
  59.         <th>年龄</th>
  60.         <th>学科</th>
  61.     </tr>
  62.     </thead>
  63.     <tbody>
  64.     <?php foreach ($staff as $arr):extract($arr) ?>
  65.     <tr>
  66.         <td><?=$Sno?></td>
  67.         <td><?=$Sname?></td>
  68.         <td><?=$Sex?></td>
  69.         <td><?=$Sage?></td>
  70.         <td><?=$Sdept?></td>
  71.     </tr>
  72.     <?php endforeach ?>
  73.     </tbody>
  74.     <?php for($i=1;$i<=$pages;$i++):?>
  75.     <?php $url = $_SERVER['PHP_SELF'] . '?p=' . $i;
  76.         $page = $_GET['p'] ?? 1;
  77.         $active = ($i == $page) ? 'active' : null;
  78.         ?>
  79.     <p>
  80.         <a href="<?=$url?>" class="<?=$active?>"><?=$i?></a>
  81.     </p>
  82.     <?php endfor?>
  83. </body>
  84. </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