电脑技术学习

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

dn001
程序三：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">&nbsp;</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;;

【本文版权归作者zhangcg与奥索网共同拥有，如需转载，请注明作者及出处】;;;;


标签：

上一篇 一个简单的图形计数器

下一篇 一个模仿oso的论坛程序（之二）

相关文章