search

博客列表 >实现分页以及数据删改

实现分页以及数据删改

昔年
昔年原创
2020年05月15日 17:23:43815浏览

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. }



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

上一条：PHP - 命名空间与自动加载下一条：html学习：第8章 框模型与定位
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多