欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识！

模仿OSO的论坛（四）_PHP教程

程序员文章站 2022-04-07 09:09:41

...

reply.php(用来回复主题)
疑难问题

if (!$cook_user)
{echo "";}
else {include ("connect.inc.php");
$query = "select * from my_user where user='".$cook_user."' and password='".$cook_password."'";
$res = mysql_query($query);
if (!$res)
{echo "";}
include "connect.inc.php";
if ($content) {$content= str_replace ( "'","mysinglequotes",$content);
$content=htmlspecialchars($content);
$content=nl2br($content);
$query = "INSERT INTO guestbook (name,type,content,icon,time_open,time_close,answer_count,answer_name,main_id) VALUES ('".$cook_user."',0,'".$content."',".$icon.",now(),now(),1,'".$cook_user."',".$theme_id.")";
$res = mysql_query($query);
if ($res)
{$query = "update guestbook set time_close=now(),answer_count=answer_count+1,answer_name='".$cook_user."' where id=".$theme_id;
$res = mysql_query($query);
if ($res)
{echo "";}}}}
?>

回复主题	href="read.php?theme_id="> $query = "select theme from guestbook where id=".$theme_id; $res = mysql_query($query); $row = mysql_fetch_row($res); echo $row[0]; ?>
表情图标	align=ABSCENTER height=18 src="mypic/icon1.gif" width=18> align=ABSCENTER height=18 src="mypic/icon2.gif" width=18> align=ABSCENTER height=18 src="mypic/icon3.gif" width=18> align=ABSCENTER height=18 src="mypic/icon4.gif" width=18> align=ABSCENTER height=18 src="mypic/icon5.gif" width=18> align=ABSCENTER height=18 src="mypic/icon6.gif" width=18> align=ABSCENTER height=18 src="mypic/icon7.gif" width=18> align=ABSCENTER height=18 src="mypic/icon8.gif" width=18> align=ABSCENTER height=18 src="mypic/icon9.gif" width=18> align=ABSCENTER height=18 src="mypic/icon10.gif" width=18> align=ABSCENTER height=18 src="mypic/icon11.gif" width=18> align=ABSCENTER height=18 src="mypic/icon12.gif" width=18> align=ABSCENTER height=18 src="mypic/icon13.gif" width=18> align=ABSCENTER height=18 src="mypic/icon14.gif" width=18>
加贴内容

本主题最后 5 个帖子（按发帖时间倒序排列）

width=100%>

$query = "select * from guestbook where main_id=".$theme_id." or id=".$theme_id." order by time_open DESC limit 5 ";
$res = mysql_query($query);
function TdBackColor() {
static $ColorStr;
if ($ColorStr=="#ededed") {
$ColorStr="#dedede";
} else {
$ColorStr="#ededed";
}
return($ColorStr);
}
for ($i=1;$i{$row = @mysql_fetch_array($res);
if (!$row) break;
$ColorStr=TdBackColor();
echo "";
echo "";
$content= str_replace ( "mysinglequotes","'",$row['content']);
echo "";
}
?>