Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 仿php.cn分页，并实现数据编辑及删除
Blogger Information
Blog 32
fans 2
comment 0
visits 27905
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
仿php.cn分页，并实现数据编辑及删除
简行
Original
699 people have browsed it

仿php.cn分页，并实现数据编辑及删除

1.代码文档：

ID 文件名 注释
1 connect.php 连接数据库
2 control.php 跳转编辑页面，保存数据编辑及删除数据操作
3 edit.php 编辑页面
4 list.php 查询数据操作
5 user_list.php 用户列表页面

2.文件代码部分：

  • connect.php
  1. <?php
  3. //数据库参数
  5. $param =[
  6.     'DB_HOST'=>'localhost',
  7.     'DB_TYPE'=>'mysql',
  8.     'DB_NAME'=>'my_user',
  9.     'DB_PASSWORD'=>'root123',
  10.     'DB_USER'=>'root',
  11.     'DB_CHARSET'=>'utf8',
  12.     'DB_PORT'=>'3306'
  13. ];
  15. $dsn = "mysql:host=".$param['DB_HOST'].";dbname=".$param['DB_NAME'].";charset=".$param['DB_CHARSET'];
  17. //连接数据
  19. try{
  20.     //连接数据款
  21.     $pdo = new PDO($dsn,$param['DB_USER'],$param['DB_PASSWORD']);
  23. } catch(PDOException $e){
  24.      //捕捉特定于数据库信息的PDOEXCEPTION 异常
  25.     echo  $e->getMessage();
  27. } catch(Throwable $e){
  28.     //捕捉拥有Throwable接口的错误或者其他异常
  29.     echo $e->getMessage();
  31. }
  • control.php
  1. <?php
  2. require "connect.php";
  4. $act = $_GET['act'];
  5. $id = $_GET['id'];
  6. switch($act){
  7.     case 'edit':
  8.         include "edit.php";
  9.         break;
  10.     case 'saveedit':
  12.         $username =$_POST['username'];
  13.         $phone =$_POST['phone'];
  14.         if(!empty($username) && !empty($phone)){
  16.             $sql = " UPDATE `mu_user` SET `username`=?,`phone`=? WHERE `id`=?";
  17.             $stm = $pdo->prepare($sql);
  19.             // $sql = 'UPDATE `mu_user` SET `username`=?, `phone`=? WHERE `id`=?';
  20.             // $stm = $pdo->prepare($sql);
  23.             $stm->bindParam(1,$username);
  24.             $stm->bindParam(2,$phone);
  25.             $stm->bindParam(3,$id);
  26.             $stm->execute();
  27.             // var_dump($stm->rowCount());
  29.             if($stm->rowCount()==1){
  30.                 exit("
  31.                     <script>
  32.                     alert('保存成功');
  33.                     location.href='./user_list.php';
  34.                     </script>
  35.                 ");
  36.             }else{
  37.                 exit("
  38.                     <script>
  39.                     alert('保存失败');
  40.                     location.href='control.php?act=edit&id=".$id."';
  41.                     </script>
  42.                 ");
  43.             }
  44.         }else{    
  45.             exit( "<script>alert('参数不能为空');location.href='control.php?act=edit&id=".$id."';</script>");
  46.         }
  47.         break;
  48.     case 'del':
  50.         $sql = "DELETE FROM `mu_user` WHERE `id`=?";
  51.         $stm = $pdo->prepare($sql);
  53.         $stm->bindParam(1,$id);
  55.         $stm->execute();
  57.         if($stm->rowCount()==1){
  59.             exit("
  60.                     <script>
  61.                     alert('删除成功');
  62.                     location.href='./user_list.php';
  63.                     </script>
  64.                 ");
  65.         }
  67.         break;
  68. }
  • edit.php
  1. <?php
  2.     require "connect.php";
  3.     $id = $_GET['id'];
  5.     $sql = "SELECT * FROM `mu_user` WHERE id=?";
  6.     $stm = $pdo->prepare($sql);
  8.     $stm->bindParam(1,$id);
  9.     $stm->execute();
  10.     $user =  $stm->fetch(PDO::FETCH_ASSOC);
  11. ?>
  12. <!DOCTYPE html>
  13. <html lang="en">
  14. <head>
  15.     <meta charset="UTF-8">
  16.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  17.     <title>编辑页面</title>
  18. </head>
  19. <style>
  20.     h1{
  21.         text-align: center;
  22.     }
  23.     form{
  24.         border: 1px solid rosybrown;
  25.         background-color: sandybrown;
  26.         width: 300px;
  27.         margin: 0 auto;
  28.     }
  29.     form div{
  30.         margin-top: 15px;
  31.         margin-left: 10%;
  32.         margin-bottom: 10px;
  33.     }
  34.     /* form>input{
  35.         margin-top: 15px;
  36.         margin-left: 20%;
  37.     } */
  40. </style>
  41. <body>
  42.     <h1>用户编辑</h1>
  43.     <form action="./control.php?act=saveedit&id=<?=$id?>" method="POST">
  44.         <div>
  45.             <label for="username">姓名</label>
  46.             <input type="text" name="username" id="username" value="<?php echo $user['username']?>">
  47.         </div>
  48.         <div>
  49.             <label for="phone">电话</label>
  50.             <input type="text" name="phone" id="phone" value="<?php echo $user['phone']?>">
  51.         </div>
  52.         <div>
  53.         <div><input type="submit" value="保存"></div>      
  55.     </form>
  57. </body>
  58. </html>
  • list.php
  1. <?php
  3. require "connect.php";
  5. //每页几条
  6. $limit =5;
  7. //当前也是\
  8. $page = $_GET['p'];
  9. if(empty($page))$page = 1;
  13. //每页起始位置
  14. $start = ($page-1)*$limit;
  17. $sql = "SELECT * FROM `mu_user` LIMIT ?,?";
  18. $stm = $pdo->prepare($sql);
  19. //绑定LIMIT占位符必须传入第三个参数PDO::PARAM_INT
  20. $stm->bindParam(1,$start,PDO::PARAM_INT);
  21. $stm->bindParam(2,$limit,PDO::PARAM_INT);
  22. // $stm->bindParam(1,$limit);
  23. $stm->execute();
  24. // fetchAll — 返回一个包含结果集中所有行的数组
  25. $result =  $stm->fetchAll(PDO::FETCH_ASSOC);
  27. $sql2 = "SELECT COUNT('id') as num FROM `mu_user` ";
  28. //总条数
  29. $num  = $pdo->query($sql2)->fetch()['num'];
  31. //总页数
  32. $pages = ceil($num/$limit);
  • user_list.php
  1. <?php
  2.  require "list.php";
  3.  //当前获取网页地址 
  4.  $url = $_SERVER['PHP_SELF'];
  6. ?>
  8. <!DOCTYPE html>
  9. <html lang="en">
  10. <head>
  11.     <meta charset="UTF-8">
  12.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  13.     <title>用户列表</title>
  14. </head>
  15. <style>
  16.     table{
  17.         text-align: center;
  18.         border:2px solid #222;
  19.         border-collapse: collapse;
  20.         margin: 0 auto;
  21.     }
  22.     tr:first-of-type{
  23.         background-color:thistle;
  24.     }
  26.     td{
  27.         padding: 10px;
  28.         border:1px solid #000;
  29.     }
  30.     p{
  31.         text-align: center;
  32.     }
  33.     a{
  34.         text-align: center;
  35.         border:1px solid #000;
  36.         text-decoration: none;
  37.         padding: 5px 10px;
  38.         margin: 10px 2px;
  39.         border-radius: 10%;
  40.     }
  42.     p>span{
  43.         font-size: 1.5rem;
  44.         margin: auto;
  45.         padding: 10px;
  46.     }
  48.     .cla{
  49.         background-color: lightskyblue;
  50.         color: lightgoldenrodyellow;
  51.         border: 1px solid lightskyblue;
  53.     }
  55. </style>
  56. <body>
  57.     <table>
  58.     <caption>用户列表</caption>
  59.         <tr>
  60.             <td>ID</td>
  61.             <td>名称</td>
  62.             <td>电话</td>
  63.             <td>操作</td>
  64.         </tr>
  65.         <?php 
  66.           foreach( $result as $list){
  67.         ?>
  68.         <tr>
  69.             <td><?=$list['id']?></td>
  70.             <td><?php echo $list['username'];?></td>
  71.             <td><?php echo $list['phone'];?></td>
  72.             <td>
  73.                 <button onclick="location.href='control.php?act=edit&id=<?=$list['id']?>'" >编辑</button>
  74.                 <button onclick="del(<?=$list['id']?>)">删除</button>
  76.             </td>
  77.         </tr>
  78.           <?php } ?>
  80.     </table>
  81.     <!-- 分页 -->
  82.     <p>
  83.         <?php
  84.             // 下一页
  85.             $next = ($page+1)>=$pages ? $pages : $page+1;           
  86.             // 上一页
  87.             $preve = ($page-1)==0 ? 0 : $page-1;
  89.         ?>
  91.         <a href="<?php echo $url."?p=1" ?>">首页</a>
  92.         <a href="<?php echo $url."?p=".$preve; ?>">上一页</a>
  93.         <?php 
  94.             $html = ''; 
  95.             if($pages>10 && $page>5 && $page<$pages-5){
  96.                 // 显示2边省略号
  97.                $html .= "<a href='".$url."?p=1'  class='".$clas."' >1</a>";
  98.                $html .= "<a href='".$url."?p=2'  class='".$clas."' >2</a>";
  99.                $html .="<span>......</span>";
  100.                 for($i=$page-2;$i<=$page+2;$i++){
  101.                     $clas = ($page==$i) ? "cla" : null;
  102.                     $html.="<a href='".$url."?p=".$i."'  class='".$clas."' >".$i."</a>";
  104.                 }
  105.                 $html .="<span>......</span>";
  106.                 $html .= "<a href='".$url."?p=".($pages-1)."'  class='".$clas."' >".($pages-1)."</a>";
  107.                 $html .= "<a href='".$url."?p=".$pages."'  class='".$clas."' >".$pages."</a>";
  109.             }elseif($pages>10 && $page<=5){
  110.                 // 显示后面省略号
  111.                 for($i=1;$i<=10;$i++){
  112.                     $clas = ($page==$i) ? "cla" : null;
  113.                     $html.="<a href='".$url."?p=".$i."'  class='".$clas."' >".$i."</a>";
  115.                 }
  116.                 $html .="<span>......</span>";
  117.                 $html .= "<a href='".$url."?p=".($pages-1)."'  class='".$clas."' >".($pages-1)."</a>";
  118.                 $html .= "<a href='".$url."?p=".$pages."'  class='".$clas."' >".$pages."</a>";
  120.             }elseif($pages>10 && $page>=$pages-5){
  121.                 // 显示前面省略号
  122.                 $html .= "<a href='".$url."?p=1'  class='".$clas."' >1</a>";
  123.                 $html .= "<a href='".$url."?p=2'  class='".$clas."' >2</a>";
  124.                 $html .="<span>......</span>";
  125.                 for($i=$pages-5;$i<=$pages;$i++){
  126.                     $clas = ($page==$i) ? "cla" : null;
  127.                     $html.="<a href='".$url."?p=".$i."'  class='".$clas."' >".$i."</a>";
  128.                 }
  129.             }else{
  130.                 // 显示全部分页
  131.                 for($i=1;$i<=$pages;$i++){
  132.                     $html.="<a href='".$url."?p='".$i."'  class='".$clas."' >".$i."</a>";
  134.                 }
  135.             }
  136.             echo  $html;
  138.         ?>
  139.         <a href="<?php echo $url."?p=".$next; ?>">下一页</a>
  140.         <a href="<?php echo $url."?p=".$pages; ?>">尾页</a>
  142.     </p>
  144. </body>
  146. <script>
  147.     function del(id){        
  148.        var y= confirm("是否删除");
  149.        if(y==true){
  150.         location.href="control.php?act=del&id="+id;
  151.        }
  152.     }
  154. </script>
  155. </html>

3.演示图：

  • 分页

  • 编辑

  • 删除

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