search

博客列表 >php分页（页码跳转+页码省略）

php分页（页码跳转+页码省略）

王珂
王珂原创
2020年05月14日 08:27:041482浏览

分页（页码跳转+页码省略）

表格页面

  1. <?php
  2. namespace pdo_edu;
  3. use PDO;
  5. // 1. 连接数据库
  6. require 'conn.php';
  8. //获取第几页
  9. $page = $_GET['page'] ?? 1;
  10. //每页条数
  11. $num = 3;
  12. //总页数
  13. $sql = "SELECT CEIL(COUNT(`id`)/{$num}) AS `total` FROM `user`";
  14. $stmt = $pdo->prepare($sql);
  15. $stmt->execute();
  16. $pages = $stmt->fetch()['total'];
  17. $sql = "SELECT COUNT(`id`) AS `countid` FROM `user`";
  18. $stmt = $pdo->prepare($sql);
  19. $stmt->execute();
  20. $countid = $stmt->fetch()['countid'];
  21. //echo $pages;
  22. //偏移量
  23. $offset = $num * ($page - 1);
  24. //
  25. $sql = "SELECT * FROM `user` LIMIT {$num} OFFSET {$offset}";
  26. $stmt = $pdo->prepare($sql);
  27. $stmt->execute();
  28. $users = $stmt->fetchAll();
  29. //设置分页页码的样式
  30. $headpages = 2;//头和尾各显示几个
  31. $midpages = 3;//中间显示几个（单数）
  33. ?>
  34. <!DOCTYPE html>
  35. <html lang="en">
  36. <head>
  37.     <meta charset="UTF-8">
  38.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  39.     <title>分页数据展示</title>
  40.     <link rel="stylesheet" href="style.css">
  42. </head>
  43. <body>
  44. <table>
  45.     <caption>用户列表</caption>
  46.     <thead>
  47.     <tr>
  48.         <th>ID</th>
  49.         <th>姓名</th>
  50.         <th>邮箱</th>
  51.         <th>状态</th>
  52.         <th>创建时间</th>
  53.         <th>操作</th>
  54.     </tr>
  55.     </thead>
  56.     <tbody>
  57.     <?php foreach ($users as $user) : ?>
  58.         <tr>
  59.             <th><? echo $user['id'] ?></th>
  60.             <th><? echo $user['name'] ?></th>
  61.             <th><? echo $user['email'] ?></th>
  62.             <th><? echo $user['status'] ?></th>
  63.             <th><? echo date('Y年m月d日', $user['create_time']) ?></th>
  64.             <th><button>编辑</button><button>删除</button></th>
  65.         </tr>
  66.     <?php endforeach ?>
  67.     </tbody>
  68. </table>
  69. <!-- 添加跳转到首页, 前一页, 下一页, 尾页的功能 -->
  70. <p>
  71.     <!-- 首页 -->
  72.     <a href="<?php echo $_SERVER['PHP_SELF'] . '?page=1' ?>">首页</a>
  73.     <!-- 前一页 -->
  74.     <?php
  75.     $prev = $page - 1;
  76.     if ($page == 1) $prev = 1;
  77.     ?>
  78.     <a href="<?php echo $_SERVER['PHP_SELF'] . '?page=' . $prev ?>">前一页</a>
  79.     <?php
  81.     if($pages<=($headpages*2+$midpages)){
  82.         for ($i=1; $i<=$pages; $i++){
  83.             $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  84.             $active = ($i == $page) ? 'active' :null;
  85.             printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  86.         }
  87.     }else{
  88.         if($page<=($headpages+ceil($midpages/2))){
  89.             for ($i=1; $i<=($headpages+$midpages); $i++){
  90.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  91.                 $active = ($i == $page) ? 'active' :null;
  92.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  93.             }
  94.             printf('<a href="#" class="">...</a>');
  95.             for ($i=($pages-$headpages+1); $i<=$pages; $i++){
  96.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  97.                 $active = ($i == $page) ? 'active' :null;
  98.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  99.             }
  100.         }elseif($page>($pages-$headpages-ceil($midpages/2))){
  101.             for ($i=1; $i<=($headpages); $i++){
  102.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  103.                 $active = ($i == $page) ? 'active' :null;
  104.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  105.             }
  106.             printf('<a href="#" class="">...</a>');
  107.             for ($i=($pages-$headpages-$midpages+1); $i<=$pages; $i++){
  108.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  109.                 $active = ($i == $page) ? 'active' :null;
  110.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  111.             }
  112.         }else{
  113.             for ($i=1; $i<=($headpages); $i++){
  114.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  115.                 $active = ($i == $page) ? 'active' :null;
  116.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  117.             }
  118.             printf('<a href="#" class="">...</a>');
  119.             for ($i=($page-floor($midpages/2)); $i<=($page+floor($midpages/2)); $i++){
  120.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  121.                 $active = ($i == $page) ? 'active' :null;
  122.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  123.             }
  124.             printf('<a href="#" class="">...</a>');
  125.             for ($i=($pages-$headpages+1); $i<=$pages; $i++){
  126.                 $jump = sprintf('%s?page=%s', $_SERVER['PHP_SELF'],  $i );
  127.                 $active = ($i == $page) ? 'active' :null;
  128.                 printf('<a href="%s" class="%s">%s</a>',$jump,$active,$i);
  129.             }
  130.         }
  131.     }
  132.     ?>
  133.     <!-- 下一页 -->
  134.     <?php
  135.     $next = $page + 1;
  136.     if ($page == $pages) $next = $pages;
  137.     ?>
  138.     <a href="<?php echo $_SERVER['PHP_SELF'] . '?page=' . $next ?>">下一页</a>
  139.     <!-- 尾页 -->
  140.     <a href="<?php echo $_SERVER['PHP_SELF'] . '?page='. $pages ?>">尾页</a>
  141. <form name="form1" method="get" action="<?php echo $_SERVER['PHP_SELF']  ?>" onSubmit="return chk(this)">
  142.     <input name="page" type="number" size="3"  mix="1" max="<?php  echo $pages ?>">
  143.     <input type="submit" value="跳转">
  144. </form>
  145. </p>
  146. </body>
  147. </html>

conn.php

  1. <?php
  2. namespace pdo_edu;
  4. use Exception;
  5. use PDO;
  7. $config = [
  8.     'type' => $type ?? 'mysql',
  9.     'host' => $host ?? 'localhost',
  10.     'dbname' => $dbname ?? 'phpedu',
  11.     'username' => $username ?? 'root',
  12.     'password' => $password ?? 'root',
  13.     'charset' => $charset ?? 'utf8',
  14.     'port' => $port ?? '3306',
  15. ];
  17. $type = $config['type'];
  18. $host = $config['host'];
  19. $dbname = $config['dbname'];
  20. $username = $config['username'];
  21. $password = $config['password'];
  22. $charset = $config['charset'];
  23. $port = $config['port'];
  24. $dsn = sprintf('%s:host=%s;dbname=%s;charset=%s;port=%s',$type,$host,$dbname,$charset,$port);
  25. try{
  26.     $pdo = new PDO($dsn,$username,$password);
  27. }catch (Exception  $e){
  28.     die($e->getMessage());
  29. }

上一条：PHP的命名空间下一条：PHP的mysqli方式完成基本的增删改查操作
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议
韦2022-04-13 12:42:452楼
你确定你的内容是正确无误么。误人子弟。要写就写正确。不要装逼。
王珂2020-05-14 22:09:521楼
能。从网上搜的，实测通过。

相关文章

查看更多