search

博客列表 >PHP分页功能扩展及数据的修改删除

PHP分页功能扩展及数据的修改删除

零龙
零龙原创
2020年08月10日 20:49:08614浏览

PHP分页功能扩展及数据的修改删除

  • connect.php 连接数据库
  • page-list.php显示分页效果
  • page-data.php分页处理
  • handle.php 处理修改和删除
  • edit.php 修改的信息提交
  • style.css 分页显示样式

1.connect.php 连接数据库

  1. <?php
  2. // 连接数据库
  3. // PDO连接对象
  4. $pdo = new PDO('mysql:host=localhost;dbname=mysqli', 'root', '142536');
  5. // 设置结果默认获取方式: 关联数组
  6. $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

2.page-list.php

  1. <?php
  2. require 'page-data.php';?>
  3. <!DOCTYPE html>
  4. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <title>数据展示</title>
  9.     <link rel="stylesheet" href="style.css">
  11. </head>
  12. <body>
  13.     <table>
  14.         <caption>用户信息表</caption>
  15.         <thead>
  16.             <tr>
  17.                 <td>id</td>
  18.                 <td>姓名</td>
  19.                 <td>性别</td>
  20.                 <td>年龄</td>
  21.                 <td>邮件</td>
  22.                 <td>手机</td>
  23.                 <td>操11作</td>
  24.             </tr>
  25.         </thead>
  26.         <tbody>
  27.             <?php foreach ($show as $users):?>
  28.                 <tr>
  29.                      <!-- 短标签来简化变量的显示 -->
  30.                     <td><?=$users['id']?></td>
  31.                     <td><?=$users['username'] ?></td>
  32.                     <td><?=$users['sex'] ?></td>
  33.                     <td><?=$users['age'] ?></td>
  34.                     <td><?=$users['email']?></td>
  35.                     <td><?=$users['mobile'] ?></td>
  36.                     <td><button onclick="location.href='handle.php?action=edit&id=<?=$users['id']?>'" >编辑</button>
  37.                      <button onclick="location.href='handle.php?action=del&id=<?=$users['id']?>'" >删除</button></td>
  38.                 </tr>
  40.             <?php endforeach ?>
  41.         </tbody>
  42.     </table>
  43.      <p>
  44.       <?php show($pages,$page)?>
  45.     </p>
  46. </body>
  47. </html>

3.page-data.php分页处理

  1. <?php
  2. // 连接数据库
  3. require 'connect.php';
  4. //获取分页数据,一定要知道的二个数据
  5. //1.每页显示的数量
  6. $zpage = $_GET['zpage'];
  8. if($zpage == "")
  9. {
  10.     $num = 5;
  11. }
  12. else
  13. {
  14.     $num = $zpage;
  15. }
  18. //2.当前页码，默认为1
  19. $page = $_GET['p'] ?? 1;
  20. //3.计算每一页的第一条记录的显示偏移量
  21. $offset =($page - 1) * $num;
  23. //4.获取分页数据
  25. $sql = "SELECT * FROM `user` LIMIT {$num} OFFSET {$offset}";
  27. $show = $pdo->query($sql)->fetchAll();
  28. //计算总页数   SELECT COUNT(`ID`) AS `total` FROM `user`
  29. //计算表中共有多少条记录
  30. //每一页显示几条
  31. //总页数 = ceil(记录总数/每页的记录数) 向上取整 相当于9.1等于10
  33. $sql = "SELECT CEIL(COUNT(`id`)/{$num}) AS `total` FROM `user`";
  35. $pages=$pdo->query($sql)->fetch()['total'];
  37. function show($pages,$page)
  38. {
  39.           $w = $pages-1;
  40.           $c = $pages-10;   
  41.           $w1 =$pages-13; 
  42.           $w2 =$page-7;
  43.           $w3 =$page+7;     
  44.          $show = "<a href=".$_SERVER['PHP_SELF'].">首页</a>";
  45.          $prev =$page-1;
  46.          if($prev == 0) $prev = 1;     
  47.          $show .= "<a href='{$_SERVER['PHP_SELF']}?p={$prev}'>上一页</a>";  
  48.         if($pages<10)
  49.         {
  50.             for($i = 1 ;$i<=$pages;$i++) 
  51.             {    
  52.                 $href=sprintf('%s?p=%s',$_SERVER['PHP_SELF'],$i);
  53.                 $active = ($i == $page) ? 'active':NULL; 
  54.                 $show.=  "<a href='{$_SERVER['PHP_SELF']}?p={$i}' class='{$active}'>{$i}</a>";
  55.             }               
  56.         }
  57.         if($pages>=10 && $prev<10)
  58.         {
  59.               for($i = 1 ;$i<=10;$i++) 
  60.               {
  61.                 $href=sprintf('%s?p=%s',$_SERVER['PHP_SELF'],$i);
  62.                 $active = ($i == $page) ? 'active':NULL; 
  63.                 $show.=  "<a href='{$_SERVER['PHP_SELF']}?p={$i}' class='{$active}'>{$i}</a>";
  64.               }
  65.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p=14'>...</a>"; 
  66.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$w}'>{$w}</a>";
  67.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$pages}'>{$pages}</a>";
  68.         }
  70.         if($prev >= 10 && $prev < $c)
  71.         {
  73.              $show.=  "<a href='{$_SERVER['PHP_SELF']}?p=1'>1</a>";
  74.              $show.=  "<a href='{$_SERVER['PHP_SELF']}?p=2'>2</a>";
  75.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$w2}'>...</a>";
  76.              for($i = $prev-2 ;$i<=$prev+4;$i++) 
  77.              {
  78.                  $href=sprintf('%s?p=%s',$_SERVER['PHP_SELF'],$i);
  79.                 $active = ($i == $page) ? 'active':NULL; 
  80.                 $show.=  "<a href='{$_SERVER['PHP_SELF']}?p={$i}' class='{$active}'>{$i}</a>";
  81.              }
  83.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$w3}'>...</a>"; 
  84.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$w}'>{$w}</a>";
  85.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$pages}'>{$pages}</a>";
  86.         }      
  87.         if($prev >=$c)
  88.         {
  91.              $show.=  "<a href='{$_SERVER['PHP_SELF']}?p=1'>1</a>";
  92.              $show.=  "<a href='{$_SERVER['PHP_SELF']}?p=2'>2</a>";
  93.              $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$w1}'>...</a>";
  94.              for($i = $pages-9 ;$i<=$pages;$i++) 
  95.              {
  96.                  $href=sprintf('%s?p=%s',$_SERVER['PHP_SELF'],$i);
  97.                 $active = ($i == $page) ? 'active':NULL; 
  98.                 $show.=  "<a href='{$_SERVER['PHP_SELF']}?p={$i}' class='{$active}'>{$i}</a>";
  99.              }
  100.         }
  101.          $next = $page + 1;
  102.          if($next >=$pages) $next = $pages; 
  103.          $show.= "<a href='{$_SERVER['PHP_SELF']}?p={$next}'>下一页</a>";
  104.          $show.=  "<a href='{$_SERVER['PHP_SELF']}?p={$pages}'>尾页</a>";
  105.          echo $show;
  107. }

4.handle.php 处理修改和删除

  1. <?php
  2. require 'connect.php';
  3. //获取操作
  5. $action = $_GET['action'];
  6. $id = $_GET['id'];
  8. switch($action)
  9. {
  10.     case 'edit':
  11.        include 'edit.php'; 
  12.     break;
  13.     case 'doedit':
  15.        $sql = 'UPDATE `user` SET `username`=?,`password`=? WHERE `id`=?;';
  16.        $stmt = $pdo->prepare($sql);
  18.         if (!empty($_POST)) {            
  19.             $stmt->execute([$_POST['username'],sha1($_POST['password']), $id]);
  20.             if ($stmt->rowCount() == 1) echo '<script>alert("更新成功");location.href="page-list.php"</script>';
  21.         }
  22.     break;
  23.     case 'del':
  24.         $sql ='DELETE FROM `user`  WHERE `id`=?';
  25.         $stmt = $pdo->prepare($sql);
  26.         $stmt->execute([$id]);
  27.          if ($stmt->rowCount() == 1) echo '<script>alert("删除成功");location.href="page-list.php"</script>';
  29. }

5.edit.php 修改的信息提交

  1. <?php
  2. // 获取要被编辑的数据
  3. $user = $pdo->query("SELECT * FROM `user` WHERE `id`={$id}")->fetch();
  4. //print_r($user);
  5. ?>
  6. <!DOCTYPE html>
  7. <html lang="en">
  8. <head>
  9.     <meta charset="UTF-8">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11.     <title>用户编辑</title>
  12. </head>
  13. <body>
  14.     <h3>用户编辑</h3>
  15.     <form action="<? echo $_SERVER['PHP_SELF']. '?action=doedit&id='.$id?>" method="POST">
  16.         <p>
  17.             <label for="name">用户名:</label>
  18.             <input type="text" name="username" id="username" value="<?=$user['username']?>">
  19.         </p>
  20.         <p>
  21.             <label for="email">密码:</label>
  22.             <input type="password" name="password" id="password" value="******">
  23.         </p>
  25.         <p>
  26.             <button>保存</button>
  27.         </p>
  28.     </form>
  29. </body>
  30. </html>

示例图：

总结：在给分页添加功能，主要是对pages和prev进行处理。

上一条：使用grid布局实现类似bootstrap栅格布局和响应式企业产品展示页面下一条：实际测试！这些因素是如何影响Google排名的
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多