当前位置: 首页 > 图文教程 > 网络编程 > PHP > 一个模仿oso的php论坛程序源码(之三)

PHP
PHP 开发环境的选择、建立及使用(5)
PHP 开发环境的选择、建立及使用(6)
PHP 开发环境的选择、建立及使用(7)
PHP 开发环境的选择、建立及使用(8)
PHP 开发环境的选择、建立及使用(9)
Win2003下APACHE PHP5 MYSQL4 PHPMYADMIN 的简易安装配置
PHP新手上路(八) 文件上传
PHP新手上路(九) 投票系统
PHP新手上路(十) 简易banner动态更替
PHP新手上路(十一) 数据库链接
PHP新手上路(十二)使用PHP来操作Oracle数据库
PHP新手上路(十三)PHP资源
PHP新手上路(十四) 其他杂项
session全教程(一)
session全教程(二)
session全教程(三)
PHP编码规范
第十五节--Zend引擎的发展 -- Classes and Objects in PHP5 [15]
第十四节--命名空间 -- Classes and Objects in PHP5 [14]
第十二节--类的自动加载 -- Classes and Objects in PHP5 [12]

PHP 中的 一个模仿oso的php论坛程序源码(之三)


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-12   浏览: 159 ::
收藏到网摘: n/a

程序三: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="/upload/tech/20091012/20091012014158_0353ab4cbed5beae847a7ff6e220b5cf.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="/upload/tech/20091012/20091012014159_6602294be910b1e3c4571bd98c4d5484.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="/upload/tech/20091012/20091012014202_c0c7c76d30bd3dcaefc96f40275bdc0a.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="/upload/tech/20091012/20091012014202_248e844336797ec98478f85e7626de4a.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