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

PHP
php sprintf()函数让你的sql操作更安全
php SQLite学习笔记与常见问题分析
使用PHP socke 向指定页面提交数据
jq的get传参数在utf-8中乱码问题的解决php版
PHP 得到根目录的 __FILE__ 常量
PHP 表单提交给自己
PHP4中session登录页面的应用
简单示例AJAX结合PHP代码实现登录效果代码
php+mysql写的简单留言本实例代码
php在线打包程序源码
php intval的测试代码发现问题
php5编程中的异常处理详细方法介绍
php include的妙用,实现路径加密
PHP中$_SERVER的详细参数与说明
php 全文搜索和替换的实现代码
PHP一些常用的正则表达式字符的一些转换
php自动跳转中英文页面
MySql中正则表达式的使用方法描述
说明的比较细的php 正则学习实例
新安装的MySQL数据库需要注意的安全知识

No. « 109 110 111 112 »

技术文章搜索

关键字

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

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