<?
//联接数据库
mysql_connect('localhost','root','');
mysql_select_db("phptest");
//读出数据并存入guestbook数组中
$result=mysql_query("select *from guestbook order by ID ") or die;
$rows=mysql_num_rows($result) or die;
for ($i = 0; $i < $rows; $i++)
{
mysql_data_seek($result,$i);
$data = mysql_fetch_array($result);
$guestbook[$i][0]=$data[0];
$guestbook[$i][1]=$data[1];
$guestbook[$i][2]=$data[2];
$guestbook[$i][3]=$data[3];
$guestbook[$i][4]=$data[4];
$guestbook[$i][5]=$data[5];
$guestbook[$i][6]=$data[6];
$guestbook[$i][7]=$data[7];
}
mysql_close();
/////////////////////////////////////////////////
if ($QUERY_STRING!="") {//很有意思的一句代码,注意look.php3?$i
$page = $QUERY_STRING;
} else {
$page = 0;
}
//设定每页显示条数
$rows--;
$show_num = 10;
$start=$rows-$page*$show_num;
$end=$start-$show_num;
if ($end<0) $end=0;
$totalpage=$rows/$show_num;
//检查要显示的页
$pagestr="";
if ($page>0) $pagestr=$pagestr."<a href=look.php3?".($page-1)."><上页</a> - ";
$pagestr=$pagestr."[第 ";
for ($i=0; $i<$totalpage; $i++) {
if ($i!=$page) {
$pagestr = $pagestr."<a href=look.php3?$i>".($i+1)."</a> ";
} else {
$pagestr = $pagestr.($i+1)." ";
}
}
$pagestr=$pagestr." 页] ";
if ($page<($totalpage-1)) $pagestr=$pagestr."- <a href=look.php3?".($page+1).">下页></a> ";
$pagestr="<div align=center>$pagestr</div>";
echo "<p>".$pagestr."<a href=guestbook.htm>加新贴</a><hr></p>\n";
//显示$page页信息
for ($i=$start; $i>$end; $i--) {
$id = $guestbook[$i][0];
$name = $guestbook[$i][1];
$email = $guestbook[$i][2];
$homepage = $guestbook[$i][3];
$topic = $guestbook[$i][4];
$content = $guestbook[$i][5];
// $content = base64_decode($guestbook[$i][5]);
$content=nl2br($content); //将换行符换成<br>
$date = $guestbook[$i][6];
echo "<table border=0>";
echo " <tr><td><img src=rule.gif><b>$name </b><font color=green><b>电子邮件：</b></font>
<a href=mailto:$email>$email</a> <font color=green><b>主页地址：</b></font><a href=$homepage>$homepage</a>
<font color=green><b> 发贴日期：</b></font>$date</td></tr>
<tr><td><b>主题：</b>$topic</td></tr>
<tr><td><b>内容：</b></td></tr>
<tr><td>$content</td></tr>";
echo("</table>\n");
echo "<hr><br>";
}
echo $pagestr;
?>
|