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

PHP
php 清除网页病毒的方法
php 远程关机操作的代码
Zend Studio for Eclipse的java.lang.NullPointerException错误的解决方法
PHP 出现乱码和Sessions验证问题的解决方法!
php2html php生成静态页函数
中英文字符串翻转函数
php escape URL编码
PHP Google的translate API代码
php 文件状态缓存带来的问题
linux下 C语言对 php 扩展
php mssql 数据库分页SQL语句
php IP及IP段进行访问限制的代码
PHP 采集程序 常用函数
php 设计模式之 单例模式
php 设计模式之 工厂模式
php xml-rpc远程调用
php 获取完整url地址
PHP MSSQL 存储过程的方法
PDP Document 代码注释规范
PHP HTML代码串截取代码

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


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-12   浏览: 260 ::
收藏到网摘: 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