<?php
//改变数据库名之后即可使用的分页
include 'conn.php'; //这里添加一个数据库连接即可,变换成自己设定的链接
$page=$_GET['page']; //翻页选项 首页,下一页,上一页,尾页
$current= $_GET['current']; //当前页数
mysql_select_db("leaveword");//使用的数据名
$result=mysql_query("select * from msgs",$connection);//改变数据
$total=mysql_num_rows($result);
$pagesize=3;
if (($total%$pagesize)!=0)
$totalpage=intval($total/$pagesize)+1;
else
$totalpage=intval($total/$pagesize);
if ($page=="")
$current=1;
else{
switch($page){
case "首页":
$current=1;
break;
case "上一页":
$current=intval($current)-1;
break;
case "下一页":
$current=intval($current)+1;
break;
case "尾页":
$current=$totalpage;
break;}
}
if($total<>0){
mysql_data_seek($result,(($current-1)*$pagesize));
}
$i=1;
?>
<?php
echo "<div align='center'>留言薄</div><br>";
while($row=mysql_fetch_array($result))
{
?>
这里是数据库读取的数据,可替换相应数据
<table width="70%" align="center">
<tr>
<td>Author:<?php echo $row["author"] ?></td>
</tr>
<tr>
<td><?php echo $row["message"]?></td>
</tr>
<tr align="right">
<td align="right"><?php echo $row["postTime"]?></td>
</tr>
</table>
<hr></hr>
<?php
$i++;
if ($i>$pagesize)
break;
else
continue;
}
?>
<?php
echo "共".$totalpage."页 当前第".$current."页 " ;
echo "<a href=".$_SERVER['PHP_SELF']."?page=首页>首页</a> ";
if ($current>1){
echo "<a href=".$_SERVER['PHP_SELF']."?page=上一页¤t=".$current.">上一页</a> "; }
if ($current!=$totalpage){
echo "<a href=".$_SERVER['PHP_SELF']."?page=下一页¤t=".$current.">下一页</a> "; }
echo "<a href=".$_SERVER['PHP_SELF']."?page=尾页>尾页</a> ";
?>