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

PHP
php ignore_user_abort与register_shutdown_function 使用方法
PHP写MySQL数据 实现代码
phpmyadmin 访问被拒绝的真实原因
PHP 程序员也要学会使用“异常”
php MYSQL 数据备份类
PHP 类型转换函数intval
php 图像函数大举例(非原创)
PHP 输出缓存详解
PHP COOKIE设置为浏览器进程
ie6 动态缩略图不显示的原因
php 将bmp图片转为jpg等其他任意格式的图片
discuz7 phpMysql操作类
一个php Mysql类 可以参考学习熟悉下
php 分页函数multi() discuz
学习discuz php 引入文件的方法DISCUZ_ROOT
php fckeditor 调用的函数
mysql 性能的检查和优化方法
PHP 高级课程笔记 面向对象
PHP 多进程 解决难题
php 404错误页面实现代码

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


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