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

PHP
搜索和替换文件或目录的一个好类--很实用
树型结构列出指定目录里所有文件的PHP类
使用字符串函数输出整数化的PHP版本号
php录入页面中动态从数据库中提取数据的实现
定制404错误页面,并发信给管理员的程序
让你的PHP同时支持GIF、png、JPEG
一个颜色轮换的简单例子
二十行语句实现从Excel到mysql的转化
模仿OSO的论坛(四)
简体中文转换为繁体中文的PHP函数
繁体中文转换为简体中文的PHP函数
PHP安装攻略:常见问题解答(三)
基于数据库的在线人数,日访问量等统计
NO3第三帝国留言簿制作过程
一个没有MYSQL数据库支持的简易留言本的编写
PHP安装攻略:常见问题解答(二)
在windows iis5下安装php4.0+mysql之我见
PHP聊天室技术
利用PHP实现与ASP Banner组件相似的类
PHP安装攻略:常见问题解答(一)

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


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