Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 数据分页显示
Blogger Information
Blog 47
fans 0
comment 3
visits 44729
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
575 people have browsed it
  1. <?php require_once "header.php" ?>
  2. <!DOCTYPE html>
  3. <html lang="en">
  4.     <head>
  5.     <meta charset="UTF-8">
  6.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <title>显示用户信息</title>
  9.     <link rel="stylesheet" href="bootstrap.css">
  10.     <style>
  11.   /* 1. 添加表格线,添加给单元格 */
  12.   tbody td,
  13.   th {
  14.     border: 1px solid;
  15.   }
  16.   /* 2. 折叠表格线 */
  17.   table {
  18.     border-collapse: collapse;
  19.     width: 90%;
  20.     /* 对齐 */
  21.     text-align: center;
  22.     margin: 2em auto;
  24.   }
  25.   /* 标题 */
  27.   table thead {
  28.     background-color: lightskyblue;
  29.     line-height: 80px;
  30.   }
  31.   table tbody{
  32.     line-height: 80px;
  33.   }
  36.   tbody tr:nth-of-type(2n){
  37.       background-color: #ddd;
  38.   }
  39.   .show h2{
  40.       text-align: center;
  41.   }
  42. </style>
  43. </head>
  44. <body>
  45.     <?php 
  46.      require_once "auto.php";  
  47.      $p=$_GET['p']??1;
  48.      $count=5;  //每页显示的记录条数
  50.     $data=UserContr::GetAllUserPage($p,$count);
  51.     //总记录行数
  52.     $rowCount=UserContr::GetRowCount();
  53.     $pages=ceil($rowCount/$count);
  56.     ?>
  57.     <div class="show">
  58.         <h2>用户信息</h2>
  59.         <table>
  61.     <thead>
  62.         <tr>
  63.         <th><input type="checkbox" id="check_all"></th>
  64.         <th>ID</th>
  65.         <th>用户名</th>
  66.         <th>姓名</th>
  67.         <th>电话</th>
  68.         <th>邮箱</th>
  69.         <th>创建时间</th>   
  70.         <th>最后登录时间</th> 
  71.         <th>状态</th> 
  72.     </tr>
  73. </thead>
  74.     <tbody>
  75.     <?php foreach($data as $user):  ?>
  76.     <tr>
  77.         <td><input type="checkbox" class="chk_item"></td>
  78.         <td class="id"><?=$user->id?></td>
  79.         <td><a href="edituser.php?id=<?=$user->id?>" title="点击修改用户信息" ><?=$user->account?></a></td>
  80.         <td><?=$user->name?></td>
  81.         <td><?=$user->phone?></td>
  82.         <td><?=$user->email?></td>
  84.         <td><?=date('Y-m-d',$user->createtime)?></td>   
  85.         <td><?=date('Y-m-d',$user->updatetime)?></td> 
  86.         <td><?=$user->state==1?'开启':'关闭'?></td> 
  87.     </tr>        
  89.     <?php endforeach ?>
  90.     </tbody>
  91.     <tfoot>
  92.         <tr>
  93.             <td colspan="9">
  95.         <nav aria-label="...">
  96.   <ul class="pagination">
  97.     <li class="page-item <?=$p==1?'disabled':''?>">
  98.       <a class="page-link" href="showuser.php?p=<?=$p-1 ?>" tabindex="-1" aria-disabled="true">上一页</a>
  99.     </li>
  100.     <?php for($i=1;$i<=$pages;$i++): ?>
  101.     <li class="page-item <?=$p==$i?'active':''?>"><a class="page-link" href="showuser.php?p=<?=$i ?>"><?=$i ?></a></li>
  102.     <?php endfor ?>
  103.     <li class="page-item <?=$p==$pages?'disabled':''?>">
  104.       <a class="page-link  " href="showuser.php?p=<?=$p+1 ?>">下一页</a>
  105.     </li>
  106.   </ul>
  107. </nav>
  109.         </td></tr>
  110.         <tr><td colspan="3"><button onclick="del()">删除</button></td>
  111.         <td><a href="adduser.php">添加用户</a></td>
  112.     </tr>
  113.     </tfoot> 
  114.         </table>
  115.     </div>
  117.     <script>
  118.         const chkAll=document.querySelector("#check_all");
  119.         const chkItems=document.querySelectorAll(".chk_item");
  120.         chkAll.onchange=ev=>chkItems.forEach(item=>item.checked=ev.target.checked);
  121.         chkItems.forEach(item=>item.onchange=()=>chkAll.checked=[...chkItems].every(item=>item.checked));
  123.         function del(){
  124.             if(confirm('您确定要删除这些用户吗？')){
  125.                 const chkItems=document.querySelectorAll(".chk_item");
  126.                 chkItems.forEach(item=>{
  127.                     if(item.checked){
  128.                        const id=item.parentElement.nextElementSibling.textContent;
  129.                        let isDel=delOpt(id);  
  130.                        if(isDel){
  131.                         //    console.log( item.parentElement.parentElement);
  132.                            item.parentElement.parentElement.remove();
  134.                        }                     
  136.                     }
  137.                 })
  138.             }else{
  139.                 alert("NO");
  140.             }
  141.         }
  142.         async function delOpt(id){
  143.             const response = await fetch("del_user.php?id=" + id);
  144.             const comments = await response.json();
  145.             return comments;
  146.         }
  147.     </script>
  148.     <script src="./js/jquery-3.5.1.min.js"></script>
  149.     <script src="./js/bootstrap.bundle.js"></script>
  150. </body>
  151. </html>
  • UserContr.php 文件中分页和记录总数方法
  1. <?php
  2. require_once "auto.php";
  4. class UserContr{ 
  5. // 分页显示
  7.     public static function GetAllUserPage($p,$count){
  8.         $start=($p-1)*$count;
  9.         $sql="SELECT * FROM `php_user` LIMIT $start ,$count";
  10.         $pdo =CreatePDO::Create();
  11.         $pre=$pdo->prepare($sql);
  12.         $exec=$pre->execute();
  13.         $data = $pre -> fetchAll(PDO::FETCH_OBJ);
  15.         return $data;
  17.     }
  18.     //记录行数
  19.     public static function GetRowCount(){
  20.         $sql="SELECT count(*) as rowCount FROM `php_user`";
  21.         $pdo=CreatePDO::Create();
  22.         $pre=$pdo->prepare($sql);
  23.         $exec=$pre->execute();
  24.         $res=$pre->fetch(PDO::FETCH_ASSOC);
  25.         return $res['rowCount'];
  27.     }
  28. }
  • CreatePDO.php 文件
  2. <?php
  3. class CreatePDO{    
  5.     public static function Create(){
  6.         try{
  7.             $pdo = new PDO('mysql:host=127.0.0.1;dbname=prodb','root','123456');
  8.         }catch(PDOException $e){
  9.                 // 抛出错误，错误是你可以定义的
  10.             echo json_encode(['status'=>9,'msg'=>'数据库链接失败']);
  11.             exit;
  12.         } 
  13.         return  $pdo;
  14.     }
  16. }
Correcting teacher：PHPzPHPz

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