<?
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> ";
}
}
}
}
$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]?> <?=$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>
<?
}
?>
浙公网安备 33010602011771号