简单留言版里面的分页代码

<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."页";
 ?>

 

posted @ 2014-04-07 03:10  选择了就坚持  阅读(148)  评论(0)    收藏  举报