php分页显示例子
数据结构参见:mysql 创建数据库、表结构
<html> <head> <meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"> </head> <style> body{ font-size: 12px; width: 100%; } div.page_bannar{ text-align: center; } div.page_bannar a { border: #aaaadd 1px solid;padding: 2px 5px 2px 5px ;text-decoration: none;margin: 2px; } div.title { padding: 2px 5px 2px 5px;color: #5d41ff;text-align: center; } div.page_bannar span.current{ border:#000099 1px solid;background-color: #000099;padding: 4px 6px 4px 6px; margin: 2px;color: white; } div.content { text-align: center;height: 300px; } div.page_bannar form{ display: inline; /*不换行*/ } </style> <body> <?php /** * Created by PhpStorm. * User: Administrator * Date: 2016/11/21 * Time: 21:51 * //传入页码 //根据页码取出数据:php->mysql处理 //显示数据(显示数据和显示分页条) */ //require 'mysql_pdo_connect.php'; /**===1传入页码=====**/ if(isset($_GET['p'])){ $page = $_GET['p']; //get参数存放到page参数 }else{ $page = 1; } // echo '参数p='.$page."<br>"; echo "<div class ='title'>插件日志查询 </div><br>"; /**====根据页码取出数据:php->mysql处理 =====**/ $host = "localhost:3306"; $username = "a2393827_zhigui"; $passwoed = "mysql2000"; $db = "wechatplugin"; $conn = mysql_connect($host,$username, $passwoed); // print_r($conn) ; if (!$conn) { echo "数据库连接失败"; die(mysql_error()); exit; } //选择所要操作的数据库 mysql_select_db("wechatplugin", $conn); ; /**=====设置编码方式为utf8 =======**/ mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET utf8"); mysql_query("SET CHARACTER_SET_RESULT=utf8"); $pagesize = 10; $showpage = 5 ;//要显示的页码 //编写sql获取分页数据SELECT * FROM plugin_userLog LIMIT 起始位置, 显示条数 //$sql ="SELECT * FROM plugin_userLog LIMIT 2, 10" $sql="select * from plugin_userLog LIMIT ".($page-1)*$pagesize.",".$pagesize; // echo $sql."<br>"; // $result = mysqli_query($sql); $result = mysql_query($sql); //处理我们的数据 //while ($row = mysql_fetch_assoc($result)){ // echo $row['pluginName'].$row['wechatVersion'].$row['alias'].$row['logType'] // .$row['tag'].$row['logInfo'].$row['logDatatime'] // ."<br>"; //} echo "<div class='content'>"; echo "<table border='1' cellspacing=0 width=80% align=center>"; echo "<tr>"; echo "<td align='center'>插件</td>"; echo "<td align='center'>微信版本</td>"; echo "<td align='center'>微信号</td>"; echo "<td align='center'>logType</td>"; echo "<td align='center'>TAG标签</td>"; echo "<td align='center'>日志</td>"; echo "<td align='center'>时间</td>"; echo "</tr>"; while ($row = mysql_fetch_assoc($result)){ echo "<tr>"; echo "<td >{$row['pluginName']}</td>"; echo "<td>{$row['wechatVersion']}</td>"; echo "<td>{$row['alias']}</td>"; echo "<td align='center'>{$row['logType']}</td>"; echo "<td>{$row['tag']}</td>"; echo "<td>{$row['logInfo']}</td>"; echo "<td align='center'>{$row['logDatetime']}</td>"; echo "</tr>"; } echo "</table>" ; echo "</div>"; //释放结果,关闭链接 mysql_free_result($result); //获取数据总记录数 $total_sql = "select count(*) from plugin_userLog"; $total_result = mysql_fetch_array(mysql_query($total_sql)); $total = $total_result[0]; //计算页数 $total_pages = ceil($total/$pagesize); //总共多少页 echo "总记录数:".$total."总页数:".$total_pages."<br>"; mysql_close($conn); $page_bannar = "<div class ='page_bannar''>"; if ($page>1){ $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=1'><首页</a>"; $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'><上一页</a>"; } $pageOffset = ($showpage-1)/2; //计算偏移量 $start =1; $end = $total_pages; if($total_pages>$showpage){ if ($page>$pageOffset+1){ $page_bannar .="..."; } if ($page>$pageOffset){ $start = $page - $pageOffset; $end = $total_pages >$page+$pageOffset ? $page+$pageOffset : $total_pages; }else{ $start =1; $end = $total_pages>$showpage ? $showpage:$total_pages; } if($page+$pageOffset>$total_pages){ $start = $start -($page + $pageOffset -$end); } } //页码跳转 for($i=$start;$i<=$end;$i++){ if ($page ==$i){ //当前页与页码相等是的 $page_bannar .= "<span class ='current'>{$i}</span>"; }else{ $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".$i."'>{$i}</a>"; } } //尾部省略号 if ($total_pages>$showpage && $total_pages>$page+$pageOffset){ $page_bannar .="..."; } if ($page<$total_pages){ $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一页></a>"; $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".$total_pages."'>尾页></a>"; } $page_bannar .= "共{$total_pages}页,"; $page_bannar .= "<form action='userLog.php' method='get'>"; $page_bannar .="到第<input type='text' size='2' name='p'>页"; $page_bannar .="<input type='submit' value='确定'>"; $page_bannar .="</form></div>"; /**=====显示数据(显示数据和显示分页条=====**/ echo $page_bannar; ?> </body> </html>