<?php
include("conn.php");  //数据库配置文件

$pagesize=3; //设置每页条数
$url=$_SERVER[REQUEST_URI];
$url=parse_url($url);
$url=$url[path]; //截取到php路径，防止翻页出错

$num=mysql_num_rows(mysql_query("select * from `message`")); //计算总条数
$totalpage=ceil($num/$pagesize); //计算总页数
$pageval=1; //定义$pageval初始值，避免出现第一次点击下一页时还在本页
if($_GET[page])
{
    $pageval=$_GET[page];
    if($pageval<=1)$pageval=1;
    $page=($pageval-1)*$pagesize;
    $page.=",";
}
echo "<br>";
$sql="select * from `message` limit $page  $pagesize";
$query=mysql_query($sql,$conn);
while($row=mysql_fetch_array($query))
{
    echo $row[id]."\t".$row[user]."\t".$row[passw]."\t".$row[regdate]."<br>";
}

echo "页次：$pageval/$totalpage 页\t";
echo "<a href=".$url.">首页</a>\t";
if($num > $pagesize)
{
if($pageval==1)
{
    echo "<a>上一页</a>\t";
    echo "<a href='$url?page=".($pageval+1)."'>下一页</a>\t";
    echo "\t<a href=$url?page=".$totalpage.">尾页</a>\t";
}else if($pageval < $totalpage)
{
    echo "<a href='$url?page=".($pageval-1)."'>上一页</a>\t";
    echo "<a href='$url?page=".($pageval+1)."'>下一页</a>\t";
    echo "\t<a href=$url?page=".$totalpage.">尾页</a>\t";
}else if($pageval == $totalpage)
{
    echo "<a href='$url?page=".($pageval-1)."'>上一页</a>\t";
    echo "<a>[下一页]</a>\t";
    echo "\t<a href=$url?page=".$totalpage.">尾页</a>\t";
}
}else
{
    echo "<a>上一页</a>\t";
    echo "<a>下一页</a>\t";
    echo "\t<a>尾页</a>\t";
}
echo "共计".$totalpage."页";
?>