osoを模倣したフォーラムプログラム（その３）

程序三：readforum.php















include ("c:mydbheader.inc");
?>

//完成功能：

//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);
}
?>


  

当前位置：主页——论坛——论坛内容

  
$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;
?>


    
    
    
    
    
  
    
    
    
  

主题：        print $ls_theme_title; ?>		print ' print 'target="_top"> print 'alt="回复贴字" border="0"> ';     ?>
共有帖子      print $li_replycount; ?>      个，已阅读      print $li_readcount; ?>      次

//显示帖子的所有内容
$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 '';
  print '   ';

  print ' ';
   
  print '    ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print '

';   print '	';   print '       作者：'.$row["replyman"].' '; print '	'; print ' 発行表：'.$row["replytime"].'	'; print ' E_mail:'.$row["replyemail"].'	'; print ''.$row["replyhttp"].'
'; print ' '.$row["content"].' '; print '

';
}
else {
$li_tempr = 0;   
print '';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print '

'; print '	'; print ' 作成者：'.$row["replyman"].' ' ; print '	'; print ' 発行表：'.$row["replytime"].'	'; print 'E_mail:'.$row["replyemail"].'	'; print ''.$row["replyhttp"].'
'; print ' '.$row["content"].' '; print '

';
}
}
?>

include ("c:mydbfooter.inc");
?>


----------
http://zhangcg.yeah.net