简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > List of blog posts > 实现分页以及数据删改
Blogger Information
Blog 24
fans 0
comment 0
visits 18692
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
811 people have browsed it

PHP实现数据分页

1.数据库连接文件

  1. <?php
  2. $dsn = "mysql:host=localhost;dbname=phpedu;charset=utf8;port=3306";
  3. $username = 'root';
  4. $password = 'root';
  5. try {
  6.     $pdo = new PDO($dsn, $username, $password);
  7. } catch (Exception $e) {
  8.     die($e->getMessage());
  9. }

2.显示页面

  1. <?php
  2. require 'connect.php';
  4. //1.获取当前页码
  5. $page = $_GET['p'] ?? 1;
  7. //2.每页显示的记录数量
  8. $num = 5;
  10. //3.获取记录总数
  11. $sql = "select count(`id`) as `total` from `staffs`";
  12. $total = $pdo->query($sql)->fetch()['total'];
  14. //4.计算总页数
  15. $pages = ceil($total / $num);
  17. //5.偏移量
  18. $offset = $num * ($page - 1);
  20. //6.获取显示的数据
  21. $sql = "select * from `staffs` limit {$num} offset {$offset}";
  22. $staffs = $pdo->query($sql)->fetchAll();
  23. // var_dump($staffs);
  24. // die;
  25. ?>
  26. <!DOCTYPE html>
  27. <html lang="en">
  29. <head>
  30.     <meta charset="UTF-8">
  31.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  32.     <title>分页数据显示</title>
  33.     <link rel="stylesheet" href="style.css">
  34. </head>
  36. <body>
  37.     <table>
  38.         <caption>员工管理系统</caption>
  39.         <thead>
  40.             <tr>
  41.                 <th>ID</th>
  42.                 <th>姓名</th>
  43.                 <th>年龄</th>
  44.                 <th>性别</th>
  45.                 <th>职位</th>
  46.                 <th>手机</th>
  47.                 <th>入职时间</th>
  48.                 <th>操作</th>
  49.             </tr>
  50.         </thead>
  52.         <tbody>
  53.             <?php foreach ($staffs as $staff) : ?>
  54.                 <tr>
  55.                     <td><?php echo $staff['id'] ?></td>
  56.                     <td><?php echo $staff['name'] ?></td>
  57.                     <td><?php echo $staff['age'] ?></td>
  58.                     <td><?php echo $staff['sex'] ? '男' : '女' ?></td>
  59.                     <td><?php echo $staff['position'] ?></td>
  60.                     <td><?php echo $staff['mobile'] ?></td>
  61.                     <td><?php echo $staff['hiredate']  ?></td>
  62.                     <td>
  63.                         <button onclick="location.href='handle.php?action=edit&id=<?php echo $staff['id'] ?>'">编辑</button>
  64.                         <button onclick="del(<?php echo $staff['id'] ?>)">删除</button>
  65.                     </td>
  66.                 </tr>
  67.             <? endforeach; ?>
  68.         </tbody>
  69.     </table>
  70.     <hr>
  71.     <hr>
  72.     <hr>
  73.     <hr>
  74.     <!-- 添加跳转到首页, 前一页, 下一页, 尾页的功能 -->
  76.     <p>
  77.         <?php
  78.         //1.设置分页条显示的页码个数
  79.         $showPage = 5;
  80.         //2.设置分页条的起始页
  81.         $startPage = 1;
  82.         //3.设置分页条的终止页
  83.         $endPage = $pages;
  84.         //4.计算偏移量
  85.         $offsetPage = ($showPage - 1) / 2;
  87.         if ($showPage < $pages) {
  88.             if ($page > $offsetPage + 1) {
  89.                 $startOmit = '...';
  90.                 $startPage = $page - $offsetPage;
  91.             }
  92.             if ($page + $offsetPage < $pages) {
  93.                 $endOmit = '...';
  94.                 $endPage = $page + $offsetPage;
  95.             }
  96.             //其他情况下要将起始终止页码进行重置
  97.             if ($page < $offsetPage + 1) {
  98.                 $endPage = $showPage;
  99.             }
  100.             if ($page + $offsetPage > $pages) {
  101.                 $startPage = $pages - $showPage + 1;
  102.             }
  103.         }
  104.         ?>
  108.         <!-- 首页 -->
  109.         <a href="<?php echo $_SERVER['PHP_SELF'] . '?p=1'  ?>">首页</a>
  110.         <!-- 上一页 -->
  111.         <?php if ($page - 1 >= 1) $pre = $page - 1;
  112.         else $pre = 1  ?>
  113.         <a href="<?php echo $_SERVER['PHP_SELF'] . '?p=' . $pre  ?>">上一页</a>
  114.         <!-- 显示左边的省略号 -->
  115.         <?php if (isset($startOmit)) :  ?>
  116.             <a href="#"><?php echo $startOmit ?></a>
  117.         <?php endif; ?>
  118.         <?php for ($i = $startPage; $i <= $endPage; $i++) : ?>
  119.             <?php
  120.             $jump = sprintf("%s?p=%s", $_SERVER['PHP_SELF'], $i);
  121.             $active = ($page == $i) ? 'active' : null;
  122.             ?>
  123.             <a href="<?php echo $jump ?>" class="<?php echo $active ?>"><?php echo $i ?></a>
  124.         <?php endfor; ?>
  126.         <!-- 显示左边的省略号 -->
  127.         <?php if (isset($endOmit)) : ?>
  128.             <a href="#"><?php echo $endOmit; ?></a>
  129.         <?php endif; ?>
  130.         <!-- 下一页 -->
  131.         <?php if ($page + 1 <=  $pages) $next = $page + 1;
  132.         else $next = $pages  ?>
  133.         <a href="<?php echo $_SERVER['PHP_SELF'] . '?p=' . $next ?>">下一页</a>
  134.         <!-- 尾页 -->
  135.         <a href="<?php echo $_SERVER['PHP_SELF'] . '?p=' . $pages ?>">尾页</a>
  136.     </p>
  138.     <script>
  139.         function del(id) {
  140.             return confirm('是否删除?') ? location.href = "handle.php?action=del&id=" + id : false;
  141.         }
  142.     </script>
  143. </body>
  145. </html>

3.处理脚本

  1. <?php
  2. require 'connect.php';
  3. $action = $_GET['action'];
  4. $id = $_GET['id'];
  5. switch ($action) {
  6.     case 'edit':
  7.         require 'edit.php';
  8.         break;
  9.     case 'doedit':
  10.         $data = $_POST;
  11.         $sql = 'UPDATE `staffs` SET `name`=:name, `age`=:age,`sex`=:sex,`position`=:position ,`mobile`=:mobile,`hiredate`=:hiredate WHERE `id`=:id';
  12.         $stmt = $pdo->prepare($sql);
  13.         $stmt->execute($data);
  14.         if ($stmt->rowCount() === 1) echo '<script>alert("更新成功");location.href="demo1.php";</script>';
  15.         else print_r($pdo->errorInfo());
  16.         break;
  17.     case 'del':
  18.         var_dump($id);
  19.         $sql = "delete from `staffs` where id={$id}";
  21.         $stmt = $pdo->prepare($sql);
  22.         $stmt->execute();
  23.         if ($stmt->rowCount() === 1) {
  24.             echo '<script>alert("删除成功");location.href="demo1.php";</script>';
  25.         } else {
  26.             echo '<script>alert("删除删除");location.href="demo1.php";</script>';
  27.         }
  28. }

4.处理编辑信息显示

  1. <?php
  2. $staff = $pdo->query("SELECT * FROM `staffs` where `id` = {$id}")->fetch();
  4. ?>
  5. <!DOCTYPE html>
  6. <html lang="en">
  8. <head>
  9.     <meta charset="UTF-8">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11.     <title>Document</title>
  12. </head>
  14. <body>
  15.     <h3>编辑员工信息</h3>
  16.     <form action="<?php echo $_SERVER['PHP_SELF'] . '?action=doedit&id=' . $id ?>" method="post">
  17.         <p>
  18.             <label for="name">姓名</label>
  19.             <input type="text" id="name" name="name" value="<?php echo $staff['name'] ?>">
  20.         </p>
  21.         <p>
  22.             <label for="age">年龄:</label>
  23.             <input type="number" id="age" name="age" value="<?php echo $staff['age'] ?>">
  24.         </p>
  26.         <p>
  27.             <label for="sex">性别:</label>
  28.             <input type="radio" id="sex" name="sex" value="1" <?php if ($staff['sex'] == 1) echo 'checked' ?>><label for="">男</label>
  29.             <input type="radio" id="sex" name="sex" value="0" <?php if ($staff['sex'] == 0) echo 'checked' ?>><label for="">女</label>
  30.         </p>
  31.         <p>
  32.             <label for="position">职位:</label>
  33.             <input type="text" id="position" name="position" value="<?php echo $staff['position'] ?>">
  34.         </p>
  35.         <p>
  36.             <label for="mobile">手机号:</label>
  37.             <input type="text" id="tel" name="mobile" value="<?php echo $staff['mobile'] ?>">
  38.         </p>
  40.         <p>
  41.             <label for="hiredate">入职时间:</label>
  42.             <input type="text" id="hiredate" name="hiredate" value="<?php echo $staff['hiredate'] ?>">
  43.         </p>
  44.         <input type="hidden" name="id" value="<?php echo $staff['id'] ?>">
  45.         <p>
  46.             <button>保存</button>
  47.         </p>
  48.     </form>
  49. </body>
  51. </html>

5.css文件

  1. * {
  2.   margin: 0;
  3.   padding: 0;
  4.   box-sizing: border-box;
  5.   color: #555;
  6. }
  8. body {
  9.   display: flex;
  10.   flex-direction: column;
  11.   align-items: center;
  12. }
  14. /* 表格样式 */
  15. table {
  16.   width: 80%;
  17.   border: 1px solid;
  18.   border-collapse: collapse;
  19.   text-align: center;
  20. }
  22. table caption {
  23.   font-size: 1.2rem;
  24.   margin: 10px;
  25. }
  26. table td,
  27. table th {
  28.   border: 1px solid;
  29.   padding: 5px;
  30. }
  31. table tr:hover {
  32.   background-color: #eee;
  33. }
  34. table thead tr:only-of-type {
  35.   background-color: lightblue;
  36. }
  37. table button {
  38.   width: 56px;
  39.   height: 26px;
  40. }
  41. table button:last-of-type {
  42.   color: red;
  43. }
  44. table button {
  45.   cursor: pointer;
  46.   margin: 0 3px;
  47. }
  48. /* 分页样式 */
  49. p > a {
  50.   text-decoration: none;
  51.   color: #555;
  52.   border: 1px solid;
  53.   padding: 5px 10px;
  54.   margin: 10px 2px;
  55. }
  56. .active {
  57.   background-color: red;
  58.   color: white;
  59.   border: 1px solid red;
  60. }



总结：分页难点在于那个省略号的实现，针对不同的情况要考虑将起始页码和终止页码进行重置。

Correcting teacher：天蓬老师天蓬老师

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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！