PHP通用分页
php通用分页,先看下样式
代码如下:
<style> body { font-size:12px;font-family:verdana;width:100%; } div.page{ text-align:center; } div.content{ height:300px; } div.page a{ border:#aaaadd 1px solid;text-decoration:none;padding:2px 5px 2px 5px;margin:2px; } div.page span.current{ border:#000099 1px solid;background-color:#000099;padding:4px 6px 4px 6px;margin:2px;color:#fff;font-weight:bold; } div.page span.disable{ border:#eee 1px solid;padding:2px 5px 2px 5px;margin:2px;color:#ddd; } div.page form{ display:inline; } </style> <?php header("Content-type:text/html;charset=utf-8"); //传入页码 $page = isset($_GET['p']) ? $_GET['p'] : 1; $page = $page > 0 ? intval($page) : 1; $conn = mysql_connect("127.0.0.1","root","") or die('连接数据库失败'); mysql_select_db("demo",$conn); mysql_query("SET NAMES UTF8"); $pageSize = 10;//每页显示的数据 $showPage = 5;//显示页码 $sql = "select * from demo limit ".($page-1)*$pageSize.",".$pageSize; $result = mysql_query($sql,$conn); echo '<div class="content"><table border=1 cellspacing=0 width=40% align="center">'; echo '<tr><td>ID</td><td>NAME</td></tr>'; while($row = mysql_fetch_assoc($result)){ echo '<tr>'; echo '<td>'.$row['id'].'</td>'; echo '<td>'.$row['name'].'</td>'; echo '</tr>'; } echo '</table></div>'; mysql_free_result($result); $total_sql = "select count(*) from demo"; $total_result = mysql_fetch_array(mysql_query($total_sql)); $total = $total_result[0]; //计算总页数 $total_page = ceil($total/$pageSize); mysql_close($conn); /*分页条*/ $page_banner = '<div class="page">'; //偏移量 $pageOffset = ($showPage-1)/2; if ($page > 1) { $page_banner .= '<a href="'.$_SERVER['PHP_SELF'].'?p=1">首页</a> '; $page_banner .= '<a href="'.$_SERVER['PHP_SELF'].'?p='.($page-1).'"><<上一页</a> '; } else { $page_banner .= '<span class="disable">首页</span>'; $page_banner .= '<span class="disable"><<上一页</span>'; } //page start //初始化数据 $start = 1; $end = $total_page; if ($total_page > $showPage){ if ($page > $pageOffset+1) { $page_banner.= '...'; } if ($page > $pageOffset) { //开始位置总是当前页-偏移量 $start = $page - $pageOffset; //右边的显示码加偏移量小于总页数就显示当前页+偏移量否则就显示最后页 $end = $total_page > ($page + $pageOffset) ? ($page + $pageOffset) : $total_page; } else { $start = 1; $end = $total_page > $showPage ? $showPage : $total_page; } if ($page+$pageOffset > $total_page) { //实际的开始位置-(当前位置+偏移量-最后一页) $start = $start - ($page + $pageOffset - $end); } } for($i = $start; $i <= $end; $i++ ){ if ($page == $i) { $page_banner .= '<span class="current">'.$i.'</span>'; } else { $page_banner .= '<a href="'.$_SERVER['PHP_SELF'].'?p='.($i).'">'.$i.'</a>'; } } if ($total_page > $showPage && $total_page > $page + $pageOffset) { $page_banner.= '...'; } //page end if ($page < $total_page) { $page_banner .= '<a href="'.$_SERVER['PHP_SELF'].'?p='.($page+1).'">下一页>></a>'; $page_banner .= '<a href="'.$_SERVER['PHP_SELF'].'?p='.($total_page).'">尾页</a>'; } else { $page_banner .= '<span class="disable">下一页>></span>'; $page_banner .= '<span class="disable">尾页</span>'; } $page_banner .= '共'.$total_page.'页'; $page_banner .= '到第<form action="mypage.php" method="get">'; $page_banner .= '<input type="text" size="2" name="p"/>页'; $page_banner .= '<input type="submit" value="确定"/>'; $page_banner .= '</form></div>'; echo $page_banner;