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

PHP
PHP 执行系统外部命令 system() exec() passthru()
最新的php 文件上传模型,支持多文件上传
php 静态页面中显示动态内容
数据库查询记录php 多行多列显示
谈PHP生成静态页面分析 模板+缓存+写文件
PHP 各种排序算法实现代码
PHP nl2br函数 将换行字符转成 <br>
php 分页原理详解
Discuz 模板语句分析及知识技巧
php win下Socket方式发邮件类
怎样去阅读一份php源代码
建站常用13种PHP开源CMS比较
php xml留言板 xml存储数据的简单例子
PHP 开源AJAX框架14种
PHP 替换模板变量实现步骤
PHP has encountered an Access Violation at 7C94BD02解决方法
php 正则匹配函数体
php 文件夹删除、php清除缓存程序
php download.php实现代码 跳转到下载文件(response.redirect)
PHP类(Class)入门教程

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


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