模仿OSO的论坛(二)
2018-09-07 11:55
read.php(用来显示相关主题内容)
<HTML><HEAD><TITLE>疑难问题</TITLE>
<LINK href="mypic/style.css" rel=STYLESHEET type=text/css></HEAD>
<BODY bgColor=#cccc99 bottomMargin=0 leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" class=body_br >
<TBODY>
<TR>
<TD vAlign=top><BR>
<TABLE align=center border=0 cellPadding=3 cellSpacing=0 width=100%>
<TBODY>
<TD>主 题:<FONT class=mid
color=#993333><B>
<?php
$query = "select * from guestbook where id=".$theme_id;
$res = mysql_query($query);
$row = mysql_fetch_array($res);
echo $row[theme];
?>
</B></FONT></TD></tr><tr>
<TD align=middle vAlign=top width=100%><A
href="post.php"><IMG
border=0 src="mypic/post.gif"></A>
<A href="reply.php?theme_id=<?php echo $row[id] ?>"><IMG
border=0
src="mypic/reply.gif"></A> <A
href="faq.php?page=1"><IMG
border=0
src="mypic/theme.gif"></A></TD></TR>
<?php
if ($row[answer_count]>5)
{echo "<TR> <TD>分 页:<FONT class=mid >";
for ($j=1;$j<=($row[answer_count]-1)/5+1;$j++) {
if ($j==$page) echo "<FONT color=#999999> [".$j."]</FONT></A>";
else echo "<A href=read.php?theme_id=".$row[id]."page=".$j."[".$j."]</FONT></A>";
}}
echo "共有帖子".$row[answer_count]."个</TD>";
$this_id=$row[id];
$query = "select id from guestbook where id<".$this_id." and type=1 order by id DESC";
$res = mysql_query($query);
$row = mysql_fetch_row($res);
$pre_id=$row[0];
$query = "select id from guestbook where id>".$this_id." and type=1 order by id";
$res = mysql_query($query);
$row = mysql_fetch_row($res);
$next_id=$row[0];
?>
</TR>
</TBODY></TABLE>
<TABLE align=center border=0 cellPadding=4 cellSpacing=2 width=100%>
<TBODY>
<TR>
<TD align=middle bgColor=#6f6f6f width="20%"><FONT color=#ffffff>作
者</FONT></TD>
<TD align=middle bgColor=#6f6f6f width="80%"><FONT color=#ffffff>内
容</FONT></TD></TR>
<?php
$query = "select * from guestbook where main_id=".$theme_id." or id=".$theme_id." order by time_open DESC limit ".strval(($page-1)*5).",5";
$res = mysql_query($query);
function TdBackColor() {
static $ColorStr;
if ($ColorStr=="#ededed") {
$ColorStr="#dedede";
} else {
$ColorStr="#ededed";
}
return($ColorStr);
}
for ($i=1;$i<=5;$i++)
{$row = @mysql_fetch_array($res);
if(!$row) break;
$ColorStr=TdBackColor();
echo "<TR>";
echo "<TD align=middle bgColor=".$ColorStr." vAlign=top width=20%><FONT";
echo "class=mid><B>";
echo $row[name]."</B></FONT></TD>";
echo "<TD bgColor=".$ColorStr." vAlign=top width=80%>";
echo "<TABLE border=0 cellPadding=0 cellSpacing=0 width=100%>";
echo "<TBODY>";
echo "<TR>";
echo "<TD align=middle width=30><IMG align=ABSCENTER border=0";
echo " src=mypic/icon".$row[icon].".gif></TD>";
echo "<TD><FONT color=#336699>发表于: ".$row[time_open]."</FONT></TD>";
echo "<TD align=right></TD></TR>";
echo "<TR>";
echo "<TD colSpan=3>";
echo "<HR SIZE=1>";
echo "</TD></TR></TBODY></TABLE>".$row[content]."</TD></TR>";
echo "<TR>";
}
?>
<TR align=right bgColor=#6f6f6f>
<TD></TD>
<TD><A
href="read.php?theme_id=<?php echo $pre_id?>page=1"><FONT
color=#ffffff>上一个主题</FONT></A><A
href="read.php?theme_id=<?php echo $next_id?>page=1"><FONT
color=#ffffff>下一个主题</FONT></A> </TD></TR></TBODY></TABLE>
<HR SIZE=1 width=100%>
<BR></TD></TR>
</TBODY></TABLE>
</FORM>
</html>