php分頁原理分析與php分頁程式碼設計

<p><?php
//php分页代码
// bbs.it-home.org
include("conn.php");
$pagesize=5;//每页显示记录
$startrow=0;//当前页记录头
if(empty($_GET['pageno'])){
if($startrow==0){
$pageno=$startrow 1;
}
}else{
$pageno=$_GET['pageno'];
$startrow=($pageno-1)*$pagesize;
}
$sql="select * from test";
$result1=mysql_query($sql,$conn);
$resultcount=mysql_num_rows($result1);
if($resultcount%$pagesize==0){
$maxpage=$resultcount/$pagesize;
}else{
$maxpage=ceil($resultcount/$pagesize);
}</p>
<p>$result=mysql_query("select * from test LIMIT $startrow,$pagesize");
while($row=mysql_fetch_array($result)){
echo $row["name"].'<br/>';
}
?>
共<?php echo $maxpage ?>页<Br/>
<a href="?pageno=1">首页</a><Br/>
<a href="?pageno=1">上一页</a><Br/>
<a href="?pageno=1">下一页</a><Br/>
<a href="?pageno=<?php echo $maxpage ?>">末页</a><Br/></p>