下面两个分页方式：
js分页：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head><title>分页代码</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><script src="http://upcdn.b0.upaiyun.com/libs/jquery/jquery-1.8.2.min.js"></script><?php // 使用示例 if (!$conn= mysql_connect("127.0.0.1", "aaa" ,"aaaa")) die('数据库选择失败！'); if (!mysql_select_db("aaaa", $conn)) die('数据库选择失败！'); mysql_query('set names utf-8'); // 用Page函数计算出 $select_from 从哪条记录开始检索、$pagenav 输出分页导航 $rows = mysql_num_rows(mysql_query("select * from aaa"));?>
<script type="text/javascript">$(function(){ var num=<?php echo isset($_GET["p"])?$_GET["p"]:1; ?>; var str=setpage(<?=$rows?>,20,num); $(".page").append(str); /* @maxpage 每页显示的页码数 @page 当前的页数 @count 总记录数 */ function setpage(count,maxpage,page){ var str=''; if(page<=0){page=1;} totalpage = Math.ceil(count/maxpage); if(page>totalpage){page=totalpage;}var step1=page%maxpage;
var start=page-step1; if(start<=0){start=1}; var step2=maxpage-page%maxpage-1; var end=page+step2; if(totalpage<end){ end=totalpage; } var prevpage=page-1; if(prevpage<=0){prevpage=1}; var nextpage=page+1; if(nextpage>totalpage){ nextpage=totalpage; } if(page!=1){ var str="<a href='?p=1'>首页</a>"; str+="<a href='?p="+prevpage+"'>上页</a>"; } // for(var i=start;i<=end;i++){ for(var i=start;i<=start+5;i++){if(i==page){
str+="<a href='?p="+i+"' class='cur'>"+i+"</a>"; }else{ str+="<a href='?p="+i+"'>"+i+"</a>"; } } if(page!=totalpage){ str+="<a href='?p="+nextpage+"'>下页</a>"; str+="<a href='?p="+totalpage+"'>尾页</a>"; } //$(".page").append(str); return str; }})
</script></head><style>*{padding: 0;margin:0;list-style: none}ul,li{list-style: none;}.page{width: 850px;height: 50px;margin: 20px auto;border: 0px solid #ccc;padding-top: 30px;}.page a{padding: 5px 8px;text-align: center;border: 1px solid #ccc;margin:10px;text-decoration: none;}.page a:hover{background: #ccc;color: #fff}.page .cur{background: #ccc;color: #fff}</style><body><?php
// 使用示例$p = $_GET["p"]?$_GET['p']:1;
$page_size = 20; //每页记录数$select_from = ($p - 1) * $page_size;$sql = "select id,title from aaa limit $select_from ,$page_size"; echo $sql.'<br>';$rst = mysql_query($sql); // var_dump(mysql_fetch_array($rst));while ($row = mysql_fetch_array($rst)){ echo "$row[id] - $row[title]<hr />"; } ?> <div class="page"> </div></body></html>php分页：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head><title>图片滚动</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><script type="text/javascript" src="js/jquery.js"></script></head><style>*{padding: 0;margin:0;list-style: none}ul,li{list-style: none;}.page{width: 850px;height: 50px;margin: 20px auto;border: 0px solid #ccc;padding-top: 30px;}.page a{padding: 5px 8px;text-align: center;border: 1px solid #ccc;margin:10px;text-decoration: none;}.page a:hover{background: #ccc;color: #fff}.page .cur{background: #ccc;color: #fff}</style><body> <div class="page"> <?php/**
* $rows 总页数 * $page 当前页号 * $page_size 当页显示的条数 **/ function Page($rows,$page,$page_size){ // global $page,$select_from,$select_limit,$pagenav; $page_count = ceil($rows/$page_size); if($page <= 1 || $page == '') $page = 1; if($page >= $page_count) $page = $page_count; // $select_limit = $page_size; // $select_from = ($page - 1) * $page_size.','; $pre_page = ($page == 1)? 1 : $page - 1; $next_page= ($page == $page_count)? $page_count : $page + 1 ; $pagenav .= "第 $page/$page_count 页 共 $rows 条记录 "; $pagenav .= "<a href='?page=1'>首页</a> "; $pagenav .= "<a href='?page=$pre_page'>前一页</a> "; $pagenav .= "<a href='?page=$next_page'>后一页</a> "; $pagenav .= "<a href='?page=$page_count'>末页</a>"; $pagenav.=" 跳到<select name='topage' size='1' οnchange='window.location=\"?page=\"+this.value'>\n"; for($i=1;$i<=$page_count;$i++){ if($i==$page) $pagenav.="<option value='$i' selected>$i</option>\n"; else $pagenav.="<option value='$i'>$i</option>\n"; } echo $pagenav;} // Page分页函数// 使用示例 if (!$conn= mysql_connect("127.0.0.1", "aaa" ,"aaa")) die('数据库选择失败！'); if (!mysql_select_db("aaa", $conn)) die('数据库选择失败！'); mysql_query('set names utf-8'); // 用Page函数计算出 $select_from 从哪条记录开始检索、$pagenav 输出分页导航 $rows = mysql_num_rows(mysql_query("select * from aaaa")); $page = $_GET["page"]?$_GET['page']:1;$page_size = 20; //每页记录数$select_from = ($page - 1) * $page_size;$sql = "select id,title from aaaa limit $select_from ,$page_size"; echo $sql.'<br>';$rst = mysql_query($sql); // var_dump(mysql_fetch_array($rst));while ($row = mysql_fetch_array($rst)){ echo "$row[id] - $row[title]<hr />"; } Page($rows,$page,$page_size);
?>
</div></body></html>