Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 如何用php实现分页效果
Blogger Information
Blog 7
fans 0
comment 1
visits 11591
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
859 people have browsed it

在一个网站中，分页是很常见的,可是怎样才能实现分页呢，今天为大家实现一下分页的效果
首先我们写分页前要知道两个很重要的地方，一个是数据库查询方式，一个是分页计算公式
数据库查询方式 select from tableName limit num1,num2; 这是一个限定查询的语句，后面跟两个参数，num1为从第几个开始查找，num2为查找的信息的个数
从查询方式中 num1这个值怎么来呢， 这就用到分页的计算公式了， num1 = （当前页 - 1） 每页显示的条数

实现分页前我们先在数据库里面准备一个表，并且插入数据，这些都是必需的前提工作了 （直接拷贝到数据库运行就行）

  1. CREATE TABLE `test`  (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  4.   `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  5.   PRIMARY KEY (`id`) USING BTREE
  6. ) ENGINE = MyISAM AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  9. INSERT INTO `test` VALUES (1, '测试1', '睡大觉');
  10. INSERT INTO `test` VALUES (2, '测试1', '睡大觉');
  11. INSERT INTO `test` VALUES (3, '测试1', '睡大觉');
  12. INSERT INTO `test` VALUES (4, '测试1', '睡大觉');
  13. INSERT INTO `test` VALUES (5, '测试1', '睡大觉');
  14. INSERT INTO `test` VALUES (6, '测试1', '睡大觉');
  15. INSERT INTO `test` VALUES (7, 'qwea', '睡大觉');
  16. INSERT INTO `test` VALUES (8, 'zxcz', '睡大觉');
  17. INSERT INTO `test` VALUES (9, 'qwe', '睡大觉');
  18. INSERT INTO `test` VALUES (10, 'bcv', '睡大觉');
  19. INSERT INTO `test` VALUES (11, 'rtyu', '睡大觉');
  20. INSERT INTO `test` VALUES (12, 'xcvx', '睡大觉');
  21. INSERT INTO `test` VALUES (13, '456', '睡大觉');
  22. INSERT INTO `test` VALUES (14, 'eqwe456', '睡大觉');
  23. INSERT INTO `test` VALUES (15, 'asd2', '睡大觉');
  24. INSERT INTO `test` VALUES (16, '123', '睡大觉');
  25. INSERT INTO `test` VALUES (17, 'rcvxtyu', '睡大觉');
  26. INSERT INTO `test` VALUES (18, '2312asda', '睡大觉');
  1. <?php
  3. //创建一个分页数据查询的方法
  4. function getPageList($page,$pageSize){
  5.     // 创建连接
  6.     $conn = mysqli_connect('127.0.0.1', 'root', 'root', 'page');
  7.     $s = ($page - 1) * $pageSize;
  8.     $sql = "SELECT * FROM test LIMIT {$s},{$pageSize}";
  9.     $sql1 = "SELECT count(*) as count FROM test";
  10.     $result = mysqli_query($conn, $sql);
  11.     $result1 = mysqli_query($conn, $sql1);
  12.     $data['table_count'] = $result1->fetch_assoc()['count'];
  13.     $data['pageSize'] = $pageSize;
  14.     $data['data'] = [];
  15.     if ($result->num_rows > 0) {
  16.         while($row = $result->fetch_assoc()) {
  17.             $data['data'][] = $row;
  18.         }
  19.     }
  20.     mysqli_close($conn);
  21.     return $data;
  22. }
  24. //创建一个处理分页的方法（这里我只实现 首页，上一页，下一页，尾页）
  25. function getPage($data){
  26.     //首先我们要先处理参数
  27.     $get = $_GET;
  28.     $page = isset($get['page'])?$get['page']:1;
  30.     //将其他的参数拼接起来，不需要分页页数
  31.     unset($get['page']);
  32.     $url = http_build_query($get);
  33.     $url = $url?$url.'&':'?';
  35.     $end_page = ceil($data['table_count'] / $data['pageSize']);
  36.     $src = '';
  37.     //如果当前页数为1 那第一个跟首页不能点击
  38.     if($page == 1){
  39.         $src = "<a><span>首页</span></a> ";
  40.         $src .= "<a><span>上一个</span></a> ";
  41.     }else{
  42.         $src .= "<a href='?{$url}page=1'>首页</a> ";
  43.         $pages = $page - 1;
  44.         $src .= "<a href='?{$url}page={$pages}'>上一个</a> ";
  45.     }
  47.     //如果当前页是最后一页 那下一个跟尾页不能点击
  48.     if($page == $end_page){
  49.         $src .= "<a ><span>下一个</span></a> ";
  50.         $src .= "<a><span>尾页</span></a> ";
  51.     }else{
  52.         $pages = $page + 1;
  53.         $src .= "<a href='?{$url}page={$pages}'>下一个</a> ";
  54.         $src .= "<a href='?{$url}page={$end_page}'>尾页</a> ";
  55.     }
  56.     return $src;
  57. }
  60. $page = isset($_GET['page'])?$_GET['page']:1;
  61. $list = getPageList($page,5);
  62. $page = getPage($list);
  64. ?>
  66. <!doctype html>
  67. <html lang="en">
  68. <head>
  69.     <meta charset="UTF-8">
  70.     <meta name="viewport"
  71.           content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
  72.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  73.     <title>Document</title>
  74. </head>
  75. <body>
  76.     <table>
  77.         <tr>
  78.             <th>id</th>
  79.             <th>name</th>
  80.         </tr>
  81.         <?php foreach($list['data']  as $v){  ?>
  82.             <tr>
  83.                 <td><?php echo $v['id']; ?></td>
  84.                 <td><?php echo $v['name']; ?></td>
  85.             </tr>
  86.         <?php } ?>
  88.     </table>
  89.     <?php echo $page; ?>
  90. </body>
  91. </html>
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
1 comments
权 2021-09-23 15:52:10
太感谢博主
1 floor
Author's latest blog post