您现在的位置: 军旅同心 >> 读书赏析 >> 学习园地 >> 电脑网络 >> 技术文章 >> 文章正文
一个模仿oso的论坛程序(之三)
作者:采集员 文章来源:来源于网络 点击数: 更新时间:2005-9-10 14:36:15
程序三: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);
}
?>

<table width="100%" border="0">
<tr class="text">  
<td width="50%">  <div align="left">当前位置:主页??论坛??论坛内容</div> </td>
<td width="50%">  <div align="center">&nbsp</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="post.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="reply.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="theme.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">&nbsp;</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 '&nbs

[1] [2] 下一页


 
免责声明:作品版权归所属媒体与作者所有!!本站刊载此文不代表同意其说法或描述,仅为提供更多信息。如果您认为我们侵犯了您的版权,请告知!本站立即删除。有异议请联系我们。
文章录入:烟灰缸    责任编辑:烟灰缸 
网友评论:(只显示最新10条。评论内容只代表网友观点,与本站立场无关!)
| 设为首页 | 加入收藏 | 联系站长 | 友情链接 | 版权申明 | 网站公告 | 管理登录 |