一个模仿oso的论坛程序（之三）

【字号：大中小】日期：2023-08-12 16:08:20浏览：4作者：馨心

程序三：readforum.php <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">&nbsp</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 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;;【本文版权归作者zhangcg与奥索网共同拥有，如需转载，请注明作者及出处】;;;;

PHP

上一条：一个模仿oso的论坛程序（之二）下一条：一个简单的图形计数器