程序三：readforum.php
<HTML>
<HEAD>
<TITLE>论坛信息</TITLE>
<linkrel="STYLESHEET"type="text/css"href="fp_zhangcg.css">
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<metaname="MicrosoftTheme"content="none">
<metaname="MicrosoftBorder"content="none">
<METANAME="Generator"CONTENT="EditPlus">
<METANAME="Author"CONTENT="">
<METANAME="Keywords"CONTENT="">
<METANAME="Description"CONTENT="">
</HEAD>
<bodybgcolor="#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"].'isok';
$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("SELECTmax(id)+1ASridFROMfr_t_forumtitle",$dbh);
$row=mysql_fetch_array($res);
if(empty($row["rid"])){
$theme_id=1;
}else{
$theme_id=$row["rid"]+1;
}
$tempstr="insertintofr_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="insertintofr_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="updatefr_t_forumtitlesetreadcount=readcount+1,replycount=replycount+1,";
$tempstr=$tempstr."replytime=now(),replyman='".$username."'whereid=".$theme_id;
$res=mysql_query($tempstr,$dbh);
}else{
$tempstr="updatefr_t_forumtitlesetreadcount=readcount+1whereid=".$theme_id;
$res=mysql_query($tempstr,$dbh);
}
?>
<tablewidth="100%"border="0">
<trclass="text">
<tdwidth="50%"><divalign="left">当前位置：主页——论坛——论坛内容</div></td>
<tdwidth="50%"><divalign="center"> </div></td>
</table>
<?
$tempstr="selecttitle,readcount,replycountfromfr_t_forumtitlewhereid=".$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;
?>
<tablewidth="100%"border="0">
<tr>
<tdwidth="61%"class="text">主题：<spanclass="text"><fontcolor="#ff0000">
<?
print$ls_theme_title;
?>
</font></span></td>
<tdwidth="13%">
<divalign="center"><ahref="addforum.php?theme_id=0"target="_top"><imgsrc="post.gif"width="80"height="20"alt="加新贴字"border="0"></a></div>
</td>
<tdwidth="13%">
<?
print'<divalign="center"><ahref="addforum.php?theme_id='.$theme_id.'"';
print'target="_top"><imgsrc="reply.gif"width="80"height="20"';
print'alt="回复贴字"border="0"></a></div>';
?>
</td>
<tdwidth="13%">
<divalign="center"><ahref="mainforum.php"target="_top"><imgsrc="theme.gif"width="80"height="20"alt="主题列表"border="0"></a></div>
当前1/2页12下一页阅读全文