php+mysql分页

最新推荐文章于 2024-11-09 10:36:36 发布
diyao5994
最新推荐文章于 2024-11-09 10:36:36 发布
阅读量92
点赞数
文章标签： php 数据库
原文链接：http://www.cnblogs.com/qulinke/articles/5467633.html
版权
  1 <html>
  2 <head>
  3     <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
  4     <style>
  5       body{font-size:14px;font-family:verdana;  }
  6       table{text-align: center;margin: 50px auto auto }
  7       table tr td{padding: 4px 15px}
  8       table thead tr th{padding: 6px 15px}
  9       table tbody tr:nth-child(2n){ background:#D8F2FF;}
 10       div.pageBox{text-align: center; }
 11        div.pageBox a{border:1px solid #444;text-decoration: none;padding: 2px 5px 2px 5px;margin:0 5px ;color: #444; }
 12        div.pageBox span.current{border: 1px solid #3D7ABB; background:#3D7ABB;padding: 4px 6px 4px 6px;margin: 2px; color: white;font-weight: 700}
 13        div.pageBox span.disable{border: 1px solid #E6E6E6; border-radius: 3px; padding: 2px 5px 2px 5px; margin: 2px;  color: #A9A9A9; background: #E6E6E6;}
 14         div.pageBox form{display: inline;}
 15     </style>
 16 </head>
 17 
 18 <body>
 19 <?php
 20 // +----------------------------------------------------------------------
 21 // | EBACERA [ WE CAN DO IT JUST THINK IT ]
 22 // +----------------------------------------------------------------------
 23 // | Copyright (c) 2016 http://www.ebacera.com All rights reserved.
 24 // +----------------------------------------------------------------------
 25 // | Author: 重设人生 <573914456@qq.com>
 26 // +----------------------------------------------------------------------
 27 // 分页原理
 28 // 1、传入页码
 29 // 2、根据页码取出数据
 30 // 3、显示数据和页码条
 31 
 32 header("Content-type:text/html;charset=utf-8");
 33 
 34 //连接数据库
 35 $con = @mysql_connect("localhost", 'root', '123456');
 36 if (!$con) {
 37     die("数据库连接失败!");
 38 }
 39 //传入页码
 40 $page = isset($_GET['p']) ? $_GET['p'] : 0;
 41 //显示几页
 42 $pageSize = 10;
 43 //总页数
 44 $pageCount = 0;
 45 //总记录数
 46 $totalNum = 0;
 47 //显示几个页码左右就用...省略
 48 $showPage = 5;
 49 //
 50 if ($page <= 0) {
 51     $page = 1;
 52 }
 53 
 54 //选择数据库
 55 mysql_select_db("studymysql", $con);
 56 //设置编码格式
 57 mysql_query("set names utf8");
 58 $count = mysql_fetch_row(mysql_query("select count(*) from admin"));
 59 //获取总页数
 60 $pageCount = $count[0];
 61 //共有多少页【ceil() 函数向上舍入为最接近的整数。】
 62 $totalNum = ceil($pageCount / $pageSize);
 63  if($page > $totalNum){
 64     $page =$totalNum;
 65 }
 66 //sql
 67 $sql = "select * from admin order by user_id asc  limit  " . ($page - 1) * $pageSize . ",{$pageSize} ";
 68 //获取资源
 69 $res = mysql_query($sql);
 70 echo "<table border='1'   style='border-collapse: collapse' align='center' width='40%'> <thead style='background: #C3C3C3;'><tr><th>编号</th><th>名字</th></tr></thead> <tbody>";
 71 //遍历数据
 72 while ($row = mysql_fetch_assoc($res)) {
 73     echo "<tr><td>{$row['user_id']}</td><td>{$row['user_name']}</td></tr>";
 74 }
 75 echo "</tbody></table>";
 76 //关闭资源
 77 mysql_free_result($res);
 78 //存放分页条
 79 $page_banner = '<div class="pageBox">';
 80 //显示数据+分页条
 81 //计算偏移量
 82 $pageOffset = ($showPage - 1) / 2;
 83 
 84 
 85 //如果当前页大于1
 86 if ($page > 1) {
 87     //首页
 88     $page_banner .= "<a href='" . $_SERVER['PHP_SELF'] . "?p=1'>首页</a>";
 89     //上一页
 90     $page_banner .= "<a href='" . $_SERVER['PHP_SELF'] . "?p=" . ($page - 1) . "'><上一页</a> &nbsp;";
 91 }else{
 92     $page_banner .= "<span class='disable'>首页</span>";
 93     $page_banner .= "<span class='disable'>上一页</span>";
 94 
 95 }
 96 
 97 //初始化数据
 98 $star = 1;
 99 $end = $totalNum;
100 //
101 echo $showPage;
102 if ($totalNum > $showPage) {
103 
104     if ($page > $pageOffset + 1) {
105         $page_banner .= "...";
106     }
107 
108     if ($page > $pageOffset) {
109         echo "-----------";
110         $star = $page - $pageOffset;
111         echo $star;
112         $end = $totalNum > $page + $pageOffset ? $page + $pageOffset : $totalNum;
113     } else {
114 
115         $star = 1;
116         $end = $totalNum > $showPage ? $showPage : $totalNum;
117 
118     }
119 
120     if ($page + $pageOffset > $totalNum) {
121         $star = $star - ($page + $pageOffset - $end);
122     }
123 
124 }
125 
126 
127 //----------------------------
128 for ($i = $star; $i <= $end; $i++) {
129     if($page == $i){
130     $page_banner .= "<span class='current'>{$i}</span>";
131     }else{
132     $page_banner .= "<a href='" . $_SERVER['PHP_SELF'] . "?p={$i}'>{$i}</a>";
133     }
134 }
135 //----------------------------
136 
137 
138 if ($totalNum > $showPage && $totalNum > $page + $pageOffset) {
139     $page_banner .= "...";
140 }
141 
142 
143 //如果当前页小于最后一页
144 if ($page < $totalNum) {
145     //下一页
146     $page_banner .= "<a href='" . $_SERVER['PHP_SELF'] . "?p=" . ($page + 1) . "'>下一页></a>";
147     //尾页
148     $page_banner .= "<a href='" . $_SERVER['PHP_SELF'] . "?p=" . ($totalNum) . "'>尾页</a>";
149 }else{
150     $page_banner .= "<span class='disable'>下一页</span>";
151     $page_banner .= "<span class='disable'>尾页</span>";
152 }
153 
154 //总页数
155 $page_banner .= "&nbsp;【共{$totalNum}页】";
156 $page_banner .= "<form action='" . $_SERVER['PHP_SELF'] . "' method='get' >";
157 $page_banner .= "&nbsp;到第&nbsp;<input type='text' name='p' value='' size='2'/> <input type='submit' /></form>";
158 $page_banner .= "</form>";
159 $page_banner .= "</div>";
160 
161 echo "<br/><br/>";
162 echo $page_banner;
163 
164 //关闭资源
165 mysql_close($con);
166 
167 
168 //格式化输出
169 function show_dump($arr)
170 {
171     echo "<pre>";
172     print_r($arr);
173     echo "</pre>";
174 }
175 
176 ?>
177 
178 </body>
179 </html>