程序员的出路

alex.w的Blog

导航

简单的php分页

Posted on 2008-10-21 12:15  alex.w  阅读(192)  评论(0)    收藏  举报

<?
include_once 'Conn.php';
$url = $_SERVER['REQUEST_URI'];
$url = parse_url($url);
$url = $url[path];
$pagesize=5;
$Nsql = mysql_query("select * from guestbook ");
$totalsize=mysql_num_rows($Nsql);
$pageNum=ceil($totalsize/$pagesize);

if($_GET[page]){
$pageValue=$_GET[page];
$page=($pageValue-1)*$pagesize;
$page .= ",";
}

if($totalsize>$pagesize){

 if($pageValue>=1){
 echo "<a href=".$url."?page=".($pageValue-1).">上一页</a> | ";
 echo "<a href=".$url."?page=".($pageValue+1).">下一页</a>";
 if($pageNum>1){
 echo "跳转到:";
 for($i=1;$i<=$pageNum;$i++){
 echo "<a href=".$url."?page=".$i.">".$i."页</a>&nbsp;";
 }
 }
 
 }

}
$sql = "select * from guestbook limit ".$page.$pagesize;
$que = mysql_query($sql);
while($rs=mysql_fetch_array($que)){
?>
<table width="600" border="0" cellpadding="0" cellspacing="1" bgcolor="#999999">
  <tr>
    <td width="80" height="30" bgcolor="#FFFFFF"><div align="right">(<?=$rs[ID]?>)用户名:</div></td>
    <td bgcolor="#FFFFFF"><?=$rs[userName]?>&nbsp;&nbsp;<?=$rs[lastdate]?></td>
  </tr>
  <tr>
    <td height="30" bgcolor="#FFFFFF"><div align="right">标题:</div></td>
    <td bgcolor="#FFFFFF"><?=$rs[title]?></td>
  </tr>
  <tr>
    <td height="30" bgcolor="#FFFFFF"><div align="right">内容:</div></td>
    <td bgcolor="#FFFFFF"><?=$rs[content]?></td>
  </tr>
</table>

<?
}
?>