Community Learn Tools Library Leisure
search
English
Home > List of blog posts > PHP实战：数据分页显示案例
Blogger Information
Blog 145
fans 7
comment 7
visits 164506
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实战：数据分页显示案例
李东亚¹⁸⁰³⁹⁵⁴⁰¹²⁰
Original
789 people have browsed it

分页显示案例

1、代码（数据连接查询略）

  1. <?php
  3. $staffs=require 'contect.php';
  4. // echo $pages; 
  5. // print_r($staffs);
  6. ?>
  7. <!DOCTYPE html>
  8. <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.     <style>
  15.     body>div {
  16.         width: 700px;
  17.         margin: 0 auto;
  18.         outline: 1px solid red;
  19.         display: flex;
  20.         flex-flow: column nowrap;
  21.         align-items: center;
  23.     }
  25.     p {
  26.         height: 25px;
  27.         display: flex;
  28.         justify-content: flex-start;
  29.         align-items: center;
  30.     }
  32.     p a {
  33.         text-decoration: none;
  34.         width: 38px;
  35.         text-align: center;
  36.         margin: 0 3px;
  37.     }
  39.     .active {
  40.         background-color: tomato;
  41.         color: white;
  42.     }
  43.     </style>
  44. </head>
  46. <body>
  47.     <div>
  48.         <table border=1 cellspacing=0 cellpadding=10>
  49.             <caption style="font-size:28px">员工信息表</caption>
  50.             <tr>
  51.                 <th>ID</th>
  52.                 <th>姓名</th>
  53.                 <th>年龄</th>
  54.                 <th>性别</th>
  55.                 <th>职位</th>
  56.                 <th>电话</th>
  57.                 <th>操作</th>
  58.             </tr>
  59.             <?php foreach($staffs as $staff):?>
  60.             <tr>
  61.                 <td><?php echo $staff['id'];?></td>
  62.                 <td><?php echo $staff['name'];?></td>
  63.                 <td><?php echo $staff['age'];?></td>
  64.                 <td><?php echo $staff['sex'] ? '男' : '女';?></td>
  65.                 <td><?php echo $staff['position'];?></td>
  66.                 <td><?php echo $staff['mobile'];?></td>
  67.                 <td><button>编辑</button><button>删除</button></td>
  69.             </tr>
  70.             <?php endforeach; ?>
  71.         </table>
  72.         <p>
  73.             <a href="demo.php?p=1">首页</a>
  74.             <?php 
  75.                 $current=filter_input(INPUT_GET,'p',FILTER_VALIDATE_INT);
  76.                 // echo $current;
  77.                 if($current<=1){
  78.                     $prev=1;
  79.                 }elseif($current>$pages){
  80.                     $prev=$pages;
  81.                 }
  82.                 else{
  83.                    $prev=$current-1;    
  84.                 }
  86.                 if($current>=$pages){
  87.                     $next=$pages;
  88.                 }elseif($current<1){
  89.                     $next=1;
  90.                 }
  91.                 else{
  92.                     $next=$current+1;
  93.                 }
  95.             ?>
  96.             <a href="demo.php?p=<?php echo $prev ?>">前一页</a>
  97.             <?php for($i=1;$i<=$pages;$i++): ?>
  98.             <a href="demo.php?p=<?php echo $i;?>"
  99.                 class='page <?php echo ($i===$current) ? 'active':null ?>'><?php echo $i;?></a>
  100.             <?php endfor; ?>
  101.             <a href="demo.php?p=<?php echo $next?>">下一页</a>
  102.             <a href="demo.php?p=<?php echo $pages?>">尾页</a>
  103.         </p>
  104.         <form action="demo.php" method='GET'>
  105.             <input type="number" name="p" min='1' max='<?php echo $pages ?>'>
  106.             <button>跳转</button>
  107.         </form>
  108.         <p>
  109.             <a href="demo.php?p=1">首页</a>
  110.             <?php 
  111.                 $current=filter_input(INPUT_GET,'p',FILTER_VALIDATE_INT);
  112.                 // echo $current;
  113.                 if($current<=1){
  114.                     $prev=1;
  115.                 }elseif($current>$pages){
  116.                     $prev=$pages;
  117.                 }
  118.                 else{
  119.                    $prev=$current-1;    
  120.                 }
  122.                 if($current>=$pages){
  123.                     $next=$pages;
  124.                 }elseif($current<1){
  125.                     $next=1;
  126.                 }
  127.                 else{
  128.                     $next=$current+1;
  129.                 }
  131.             ?>
  132.             <a href="demo.php?p=<?php echo $prev ?>">前一页</a>
  133.             <?php $showpages=5; $offset=($showpages-1)/2;
  134.             if($current>$offset+1){
  135.                 echo "<a href=''>……</a>";
  136.                 $showstart=$current-$offset;
  137.                 $showend=$current+$offset;
  138.                 }
  139.             else{
  140.                 $showstart=1;
  141.                 $showend=$current+($offset+($offset-$current)+$showstart);
  142.             }
  144.             if($showend>$pages){
  145.                 $showstart=$current-($offset+($showend-$pages));
  146.                 $showend=$pages;
  147.             }
  149.             ?>
  150.             <?php for($i=$showstart;$i<=$showend;$i++): ?>
  152.             <a href="demo.php?p=<?php echo $i;?>"
  153.                 class='page <?php echo ($i===$current) ? 'active':null ?>'><?php echo $i;?></a>
  154.             <?php endfor; ?>
  155.             <?php if($showend<$pages){ echo "<a href=''>……</a>" ; } ?>
  156.             <a href="demo.php?p=<?php echo $next?>">下一页</a>
  157.             <a href="demo.php?p=<?php echo $pages?>">尾页</a>
  158.         </p>
  160.     </div>
  161. </body>
  163. </html>

2、演示结果：

总结：

1、数据库分页查询：SELECT * FROMstaffsLIMIT 5 OFFSET 0;
（LIMIT 每页显示的记录数，OFFSET 偏移量=每页显示的数量 * (当前页数 - 1)）
2、数据统计总数：SELECT COUNT('id') AS sum FROM `staffs;
3、跳转页码：利用form中method=”GET”;设置input的name=”p”;即可实现跳转至输入页码；利用input中（min|max）来限制页码超出范围
4、利用showpages页码、开始页码、结束页码、和页码偏移量来结算显示省率号；
5、获取当前脚本地址：$_SERVER['PHP_SELF']

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：现在体会到了$_SERVER变量的强大作用吧, 里面的每一个键都值得反复研究, 许多功能 都要靠它来实现
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