一个模仿oso的论坛程序（之三）
点击次数：22 次 发布日期：2008-11-26 02:21:20 作者：源代码网
|
<HTML> <HEAD> <TITLE> 论坛信息 </TITLE> <link rel="STYLESHEET" type="text/css" href="fp_zhangcg.css"> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta name="Microsoft Theme" content="none"> <meta name="Microsoft Border" content="none"> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> </HEAD> <body bgcolor="#C0C0C0" background="backcolor.GIF"> <? include ("c:mydbheader.inc"); ?> <?php //完成功能： //echo $username; //echo $useremail; //echo $userhttp; //echo $forumtitle; //echo $fouumface; //echo $forumcontent; //echo $theme_id; echo "g_username:".$GLOBALS["g_username"]." is ok"; $dbh = mysql_connect("localhost:3306","root",""); mysql_select_db("test"); if (empty($readflag)) { $readflag = 0; } if ($readflag > 0) { $theme_id = $readflag; } if (empty($theme_id)) { $theme_id = 0; } //echo $username; //echo $useremail; //echo $userhttp; //echo $forumtitle; //echo $fouumface; //echo $forumcontent; if (($readflag == 0) and ($theme_id == 0)) { //增加数据 if (empty($username)) { print "错误，请核对数据"; } $res=mysql_query("SELECT max(id) + 1 AS rid FROM fr_t_forumtitle",$dbh); $row=mysql_fetch_array($res); if (empty($row["rid"])) { $theme_id = 1; } else { $theme_id = $row["rid"] + 1; } $tempstr = " insert into fr_t_forumtitle(id,state,readcount,replycount,title,"; $tempstr = $tempstr."createman,replytime) "; $tempstr = $tempstr." values(".$theme_id.","0",0,-1,"".$forumtitle."","".$username."",now());"; $res=mysql_query($tempstr,$dbh); } if ($readflag == 0 ) { $forumcontent = nl2br($forumcontent); $tempstr = " insert into fr_t_forumcontent(id,content,replyman,replyemail,"; $tempstr = $tempstr."replyhttp,replytime,replyface)"; $tempstr = $tempstr." values(".$theme_id.","".$forumcontent."","".$username."","". $useremail."","".$userhttp."",now(),".$forumface.");"; $res=mysql_query($tempstr,$dbh); $tempstr = " update fr_t_forumtitle set readcount = readcount +1,replycount = replycount + 1,"; $tempstr = $tempstr."replytime = now(),replyman ="".$username."" where id=".$theme_id; $res=mysql_query($tempstr,$dbh); } else { $tempstr = " update fr_t_forumtitle set readcount = readcount +1 where id =".$theme_id; $res=mysql_query($tempstr,$dbh); } ?> <table width="100%" border="0"> <tr class="text"> <td width="50%"> <div align="left">当前位置：主页——论坛——论坛内容</div> </td> <td width="50%"> <div align="center"> </div> </td> </table> <? $tempstr = " select title,readcount,replycount from fr_t_forumtitle where id = ".$theme_id; $res=mysql_query($tempstr,$dbh); $row=mysql_fetch_array($res); $ls_theme_title = $row["title"]; $li_readcount = $row["readcount"]; $li_replycount = $row["replycount"] + 1; ?> <table width="100%" border="0"> <tr> <td width="61%" class="text">主题：<span class="text"><font color="#ff0000"> <? print $ls_theme_title; ?> </font></span></td> <td width="13%"> <div align="center"><a href="addforum.php?theme_id=0" target="_top"><img src="post.gif" width="80" height="20" alt="加新贴字" border="0"></a></div> </td> <td width="13%"> <? print "<div align="center"><a href="addforum.php?theme_id=".$theme_id."""; print "target="_top"><img src="reply.gif" width="80" height="20""; print "alt="回复贴字" border="0"></a></div>"; ?> </td> <td width="13%"> <div align="center"><a href="mainforum.php" target="_top"><img src="theme.gif" width="80" height="20" alt="主题列表" border="0"></a></div> </td> </tr> <tr> <td width="390" class="text">共有帖子 <font color="#ff0000"> <? print $li_replycount; ?> </font> 个，已阅读 <font color="#ff0000"> <? print $li_readcount; ?> </font> 次</td> <td colspan="3"> </td> </tr> </table> <? //显示帖子的所有内容 $ls_query = "select content,replyman,replytime,replyemail,replyhttp,replyface from fr_t_forumcontent "; $ls_query = $ls_query. " where id = ".$theme_id." order by replytime"; $res = mysql_query($ls_query, $dbh); $li_tempr = 0; while ($row = mysql_fetch_array($res)) { if ($li_tempr == 0) { $li_tempr = 1; print "<table width="100%" border="0" bgcolor="#CCCCCC">"; print " <tr bgcolor="#dedede" bordercolor="#CCCCFF"> "; print " <td class="text" height="19" valign="top" width="5%"> <div align="left">"; print " <img src="icon".$row["replyface"].".gif" width="18" height="18" ></div> </td>"; print " <td class="text" height="19" valign="top" width="20%"> "; print " <div align="left"><font color="#3333FF">作者：".$row["replyman"]."</font></div>"; print " </td>"; print " <td class="text" height="19" valign="top" width="25%">"; print " <font color="#3333FF">发表于：".$row["replytime"]."</font></td>"; print " <td class="text" height="19" valign="top" width="25%">"; print " <font color="#3333FF">E_mail:".$row["replyemail"]."</font></td>"; print " <td class="text" height="19" valign="top" width="25%">"; print "<font color="#3333FF">".$row["replyhttp"]." </font></td>"; print " </tr>"; print " <tr bgcolor="#dedede" bordercolor="#CCCCFF"> "; print " <td class="text" height="22" valign="top" colspan="5"> "; print " <p><font color="#3333FF">".$row["content"]."</font></p>"; print " </td>"; print " </tr>"; print "</table>"; } else { $li_tempr = 0; print "<table width="100%" border="0" bgcolor="#CCCCCC">"; print " <tr bgcolor="#ededed"> "; print " <td class="text" height="19" valign="top" width="5%"> <div align="left">"; print " <img src="icon".$row["replyface"].".gif" width="18" height="18" ></div> </td>"; print " <td class="text" height="19" valign="top" width="20%" bgcolor="#ededed"> "; print " <div align="left"><font color="#000099">作者：".$row["replyman"]."</font></div>"; print " </td>"; print " <td class="text" height="19" valign="top" width="25%">"; print " <font color="#000099">发表于：".$row["replytime"]." </font></td>"; print " <td class="text" height="19" valign="top" width="25%">"; print "<font color="#000099">E_mail:".$row["replyemail"]."</font></td>"; print " <td class="text" height="19" valign="top" width="25%">"; print "<font color="#000099">".$row["replyhttp"]." </font></td>"; print " </tr>"; print " <tr bgcolor="#ededed"> "; print " <td class="text" height="22" valign="top" colspan="5"> "; print " <p><font color="#000099">".$row["content"]."</font></p>"; print " </td>"; print " </tr>"; print "</table>"; } } ?> <? include ("c:mydbfooter.inc"); ?> </HTML> ---------- http://zhangcg.yeah.net 源代码网供稿. |
