search

博客列表 >PHP分页效果和扩展（0803）

PHP分页效果和扩展（0803）

丶久而旧之丶
丶久而旧之丶原创
2020年09月02日 16:50:30567浏览

分页

  1. <?php
  2. $pdo = new PDO("mysql:host=localhost;dbname=user;charset=utf8", "root", "root");
  3. // var_dump($pdo);
  5. // 获取每页显示数量
  6. $num = 5;
  7. // 获取页码
  8. $page = $_GET['p'] ?? 1;
  9. // 获取偏移量
  10. $offset = ($page - 1) * $num;
  12. $sql = "SELECT * FROM `apple` LIMIT {$num} OFFSET {$offset}";
  13. $users = $pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
  15. // 计算总页数
  16. $sql = "SELECT CEIL(COUNT(`id`)/{$num}) AS `total` FROM `apple`";
  17. $pages = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC)['total'];
  20. ?>
  21. <!DOCTYPE html>
  22. <html lang="en">
  24. <head>
  25.     <meta charset="UTF-8">
  26.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  27.     <title>分页</title>
  28.     <style>
  29.         p {
  30.             text-align: center;
  31.         }
  33.         table {
  34.             border-collapse: collapse;
  35.             width: 300px;
  36.             text-align: center;
  37.             margin: auto;
  38.             font-size: 18px;
  39.         }
  41.         tr:first-of-type {
  42.             background-color: lightskyblue;
  43.         }
  45.         p:last-of-type {
  46.             display: flex;
  47.             justify-content: center;
  48.         }
  50.         a {
  51.             text-decoration: none;
  52.             text-align: center;
  53.             /* border: 0.5px solid black; */
  54.             padding: 0 5px;
  55.             margin-left: 3px;
  56.             color: lightslategrey;
  57.             font-size: small;
  58.         }
  60.         .active {
  61.             background-color: lightsalmon;
  62.             border: lightsalmon;
  63.             color: white;
  64.         }
  65.     </style>
  66. </head>
  68. <body>
  69.     <p>用户信息</p>
  70.     <table border=1>
  71.         <tr>
  72.             <th>id</th>
  73.             <th>姓名</th>
  74.             <th>性别</th>
  75.             <th>操作</th>
  76.         </tr>
  77.         <?php foreach ($users as $user) : ?>
  78.             <tr>
  79.                 <td><?= $user['id'] ?></td>
  80.                 <td><?= $user['username'] ?></td>
  81.                 <td><?= $user['sex'] ?></td>
  82.                 <td><button onclick="location.href='hendle.php?action=action&id=<?= $user['id'] ?>&p=<?= $page ?>'">编辑</button>
  83.                     <button onclick="location.href='hendle.php?action=del&id=<?= $user['id'] ?>&p=<?= $page ?>'">删除</button>
  84.                 </td>
  85.             </tr>
  86.         <?php endforeach ?>
  87.     </table>
  88.     <p>
  89.         <!-- 上一页 -->
  90.         <?php
  91.         // 防止上一页会跳转越界
  92.         $prev = $page - 1;
  93.         if ($page == 1) $prev = 1;
  94.         ?>
  95.         <!-- 判断是否要显示上一页和首页 -->
  96.         <?php if ($page != 1) : ?>
  97.             <a href="<?= $_SERVER['PHP_SELF'] . '?P=1' ?>">首页</a>
  98.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=' . $prev ?>">上一页</a>
  99.         <?php endif ?>
  100.         <!-- 分页条主体内容 -->
  101.         <!-- 分页前面部分 -->
  102.         <?php if ($page <= 3) : ?>
  103.             <?php for ($i = 1; $i <= 5; $i++) : ?>
  104.                 <?php
  105.                 // 动态生成跳转地址
  106.                 $jump = $_SERVER['PHP_SELF'] . '?p=' . $i;
  107.                 // 页码高亮的动态生成
  108.                 $active = ($i == $page) ? 'active' : null;
  109.                 ?>
  110.                 <a href="<?= $jump ?>" class="<?= $active ?>"><?= $i ?></a>
  111.             <?php endfor ?>
  112.             <a href="">...</a>
  113.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=' . ($pages - 1) ?>" class="<?= $active ?>"><?= $pages - 1 ?></a>
  114.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=' . $pages ?>" class="<?= $active ?>"><?= $pages ?></a>
  115.             <!-- 分页中间部分 -->
  116.         <?php elseif ($page >= 4 && $page < $pages - 4) : ?>
  117.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=1'  ?>" class="<?= $active ?>">1</a>
  118.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=2'  ?>" class="<?= $active ?>">2</a>
  119.             <a href="">...</a>
  120.             <?php for ($i = $page - 1; $i <= $page + 1; $i++) : ?>
  121.                 <?php
  122.                 // 动态生成跳转地址
  123.                 $jump = $_SERVER['PHP_SELF'] . '?p=' . $i;
  124.                 // 页码高亮的动态生成
  125.                 $active = ($i == $page) ? 'active' : null;
  126.                 ?>
  127.                 <a href="<?= $jump ?>" class="<?= $active ?>"><?= $i ?></a>
  128.             <?php endfor ?>
  129.             <a href="">...</a>
  130.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=' . ($pages - 1) ?>" class="<?= $active ?>"><?= $pages - 1 ?></a>
  131.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=' . $pages ?>" class="<?= $active ?>"><?= $pages ?></a>
  132.             <!-- 分页后半部分 -->
  133.         <?php else : ?>
  134.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=1'  ?>" class="<?= $active ?>">1</a>
  135.             <a href="<?= $_SERVER['PHP_SELF'] . '?p=2'  ?>" class="<?= $active ?>">2</a>
  136.             <a href="">...</a>
  137.             <?php for ($i = $pages - 4; $i <= $pages; $i++) : ?>
  138.                 <?php
  139.                 // 动态生成跳转地址
  140.                 $jump = $_SERVER['PHP_SELF'] . '?p=' . $i;
  141.                 // 页码高亮的动态生成
  142.                 $active = ($i == $page) ? 'active' : null;
  143.                 ?>
  144.                 <a href="<?= $jump ?>" class="<?= $active ?>"><?= $i ?></a>
  145.             <?php endfor ?>
  146.         <?php endif ?>
  147.         <!-- 下一页 -->
  148.         <?php
  149.         // 防止下一页越界
  150.         $next = $page + 1;
  151.         if ($next > $pages) $next = $pages;
  152.         ?>
  153.         <!-- 判断是否要显示下一页和尾页 -->
  154.         <?php if ($page != $pages) : ?>
  155.             <a href="<?= $_SERVER['PHP_FILE'] . '?p=' . $next ?>">下一页</a>
  156.             <a href="<?= $_SERVER['PHP_FILE'] . '?p=' . $pages ?>">尾页</a>
  157.         <?php endif ?>
  160.     </p>
  161. </body>
  163. </html>

控制器

  1. <?php
  2. $pdo = new PDO("mysql:host=localhost;dbname=user;", "root", "root");
  3. $action = $_GET['action'];
  4. $id = $_GET['id'];
  5. $page = $_GET['p'];
  6. // echo $action, $id;
  8. // var_dump($pdo->query("SELECT * FROM apple where `id`=$id")->fetch(PDO::FETCH_ASSOC));
  9. // var_dump($a);
  10. switch ($action) {
  11.     case 'action':
  12.         include 'yonghu.php';
  13.         break;
  14.     case 'doedit':
  15.         if (!empty($_POST)) {
  16.             $name = $_POST['name'];
  17.             $sex = $_POST['sex'] ? '男' : '女';
  18.             $sql = "UPDATE `apple` SET `username`=?, `sex`=? WHERE `id`=?";
  19.             $stmt = $pdo->prepare($sql);
  20.             $stmt->execute([$name, $sex, $id]);
  21.             if ($stmt->rowCount() == 1) {
  22.                 echo "<script>alert('编辑程功');location.href='0803.php?p='+'$page'</script>";
  23.             }
  24.         }
  25.         break;
  26.     case 'del':
  27.         if ($pdo->query("DELETE FROM `apple` WHERE `id`=$id")->rowCount() == 1)
  28.             echo "<script>alert('删除成功');location.href='0803.php?p='+'$page'</script>";
  30.         break;
  31. }

用户编辑

  1. <?php
  2. $user = $pdo->query("select * from apple where id=$id")->fetch(PDO::FETCH_ASSOC);
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="en">
  7. <head>
  8.     <meta charset="UTF-8">
  9.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  10.     <title>用户编辑</title>
  11. </head>
  13. <body>
  14.     <form action="<?= $_SERVER['PHP_FILE'] . '?action=doedit&id=' . $id . '&p=' . $page ?>" method="POST">
  15.         <fieldset>
  16.             <legend>用户编辑</legend>
  17.             <label for='name'>用户名：</label>
  18.             <input type='text' name='name' id='name' placeholder='<?= $user['username'] ?>' required>
  19.             <label for='sex'>性别：</label>
  20.             <input type='radio' name='sex' id='sex' value='1'>男
  21.             <input type='radio' name='sex' id='sex1' value='0'>女
  22.             <button>保存</button>
  23.         </fieldset>
  24.     </form>
  27. </body>
  29. </html>

编辑和删除

总结

1.了解分页条效果的处理（但感觉冗余了不知怎么精简）
2.删除数据对于是否删除的弹框不知该如何插入

上一条：Google网站排名多久能到首页？下一条：ES6中let与const的用法以及解构
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多