<?php
$PageSize=3;//每页显示记录数
$StartRow=0;//开始显示记录的编号
//获取需要显示的页数,由用户提交
if(empty($_GET['PageNo'])){//如果为空,则表示第1页
if($StartRow==0){
$PageNo=StartRow+1;//设定为1
}
}
else{
$PageNo=$_GET['PageNo'];//获得用户提交的页数
$StartRow=($PageNo-1)*$PageSize;//获得开始显示的记录编号
}
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>分页显示实例</title>
</head>
<?php
include 'dbConnection.php';
$TRecord=mysql_query("SELECT * FROM items");
$result=mysql_query("SELECT image_url,author,price,item_id FROM items ORDER BY item_id DESC LIMIT $StartRow,$PageSize");
//获取总记录数
$RecordCount=mysql_num_rows($TRecord);
//获取总页数
if($RecordCount%$PageSize==0){
$MaxPage=$RecordCount/$PageSize;
}
else{
$MaxPage=ceil($RecordCount/$PageSize);
}
?>
<body text="#0066CC">
分页显示记录
<?php
print "总共 $RecordCount 条记录 - 当前页: $PageNo of $MaxPage";
?>
<table bgcolor="#FFFF99">
<tr>
<td>记录序号</td>
<td>图像路径</td>
<td>作者</td>
<td>价格</td>
<td>图书编号</td>
</tr>
<?php
$i = 1;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$bil = $i + ($PageNo-1)*$PageSize;//记录序号
?>
<tr bgcolor="#00FFFF" align="center">
<td><?php echo $bil ?></td>
<td><?php echo $row[0] ?></td>
<td><?php echo $row[1] ?></td>
<td><?php echo $row[2] ?></td>
<td><?php echo $row[3] ?></td>
</tr>
<?php
$i++;}
?>
</table><br>
<div align=center>
<?php
echo "<a href=page.php?PageNo=1>first</a> ";
if($PageNo!=1){
$PrevStart=$PageNo-1;
print "<a href=page.php?PageNo=$PrevStart>Previous </a>";
}
else{
echo "";
}
print "[";
for($c=0;$c<=5;$c++){
$b=$c+$PageNo;
if($b<=$MaxPage){
echo "<a href=page.php?PageNo=$b>-$b-</a>";
}
}
print "]";
if($PageNo<$MaxPage){
$NextPage = $PageNo + 1;
echo "<a href=page.php?PageNo=$NextPage>Next</a>";
echo "";
}
else{
echo "";
}
echo " <a href=page.php?PageNo=$MaxPage>last</a>";
?>
</body>
</html>