繁體中文当前位置: 首页 > 图文教程 > 网络编程 > PHP > 一个模仿oso的论坛程序（之三）
- PHP
- PHP基础教程(11)：PHP函数
- PHP基础教程(12)：PHP表单和用户输入
- PHP基础教程(13)：PHP $_GET
- PHP基础教程(14)：PHP $_POST
- PHP高级教程(1):PHP日期Date()
- PHP高级教程(2):PHP引用文件
- PHP高级教程(3):PHP文件处理
- PHP高级教程(4):PHP文件上传
- PHP高级教程(5):PHP Cookies
- PHP高级教程(6):PHP Sessions
- PHP高级教程(7):PHP发送电子邮件
- PHP高级教程(8):PHP安全的电子邮件
- PHP高级教程(9):PHP错误处理
- PHP高级教程(10):PHP异常处理
- PHP高级教程(11):PHP过滤器（Filter）
- PHP+MySQL教程(1):MYSQL简介
- PHP+MySQL教程(2):连接MYSQL数据库
- PHP+MySQL教程(3):创建数据库和表
- PHP+MySQL教程(4):MySQL Insert Into
- PHP+MySQL教程(5):MySQL Select
PHP 中的 一个模仿oso的论坛程序（之三）
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 62 ::
收藏到网摘: n/a
<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="backcolor.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);
}
?&g
评论 (0) All
