<meta http-equiv="content-type" content="text/html;charset=utf8">
<?php
include('conn.php');
$pagesize=3;
$sql1="select*from ly";
$sql2=mysql_query($sql1);
$num=mysql_num_rows($sql2);
$lastpg=ceil($num/$pagesize);
if($_GET[page]){
$pageval=$_GET[page];
$bpage=($pageval-1)*$pagesize;
$bpage.=',';
}
$url=$_SERVER['REQUEST_URI'];
$url=parse_url($url);
$url=$url[path];
$prepg=$pageval-1;
$nextpg=($pageval==$lastpg?0:$pageval+1);
if($pageval<1 or $pageval>$lastpg) {echo "<script>location.href='$url?page=1'</script>";}
if($pageval!=1) $e.="<a href=$url?page=1>首页</a>";
else $e.="首页";
if($pageval>1) $e.="<a href=$url?page=".$prepg.">上一页</a>";
else $e.="上一页";
if($pageval<$lastpg) $e.="<a href=$url?page=".$nextpg.">下一页</a>";
else $e.="下一页";
if($pageval!=$lastpg) $e.="<a href=$url?page=".$lastpg.">尾页</a>";
else $e.="尾页";
$sql3="select*from ly order by id desc limit $bpage $pagesize";
$sql4=mysql_query($sql3);
while ($rs=mysql_fetch_array($sql4)) {
?>
<h2>标题: <?php echo $rs['title'] ?></h2>
<li><?php echo $rs['dates'] ?></li>
<hr>
<p><?php echo $rs['contents'] ?></p>
<hr>
<?php
}
echo $e;
echo "当前在第".$pageval."页/共".$lastpg."页";
?>