学院首页>网络编程>PHP>基于mysql的论坛（6）

基于mysql的论坛（6）

作者： 来源：不详 添加时间：2006-5-25 20:40:14
  # post.php
<?php
require("config.inc.php");
$sql="select * from boardinfo where name='$board'";
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
?>
<html>
<head>
<title>发新贴子</title>
<link rel="stylesheet" type="text/css" href="css/index.css">
</head>
<body bgcolor="#666666">
<?php include "ad.php";?><br>
<hr noshade width="80%" size="1">
<table width="80%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#686898" bordercolordark="#FFFFFF">
  <tr align="center" valign="top" bgcolor="#666699">  
 <td><font size="3" color="#336699"><b><font color="#CCFFFF">发 贴 子</font></b></font><br>
 </td>
  </tr>
  <tr bgcolor="#ffffef">  
 <td>（您<b>必须注册</b>以后才能发表新主题，不然您只能查看主题。<br>
如果您还未注册，请<a href="apply.php" target="_blank"><font color="#FF0000">点击这里</font></a>转到注册页）</td>
  </tr>
  <tr bgcolor="#e8eee0">  
 <td><br>
您的贴子将被发表在<b><?php echo $sql_row[chinesename];?></b>版块 </td>
  </tr>
</table>
<br>
<form method="post" action="read.php">
  <table width="98%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#336699" bordercolordark="#FFFFFF" bgcolor="#666699">
 <tr>  
<td width="89" bgcolor="#acc0fa" align="right">用户名：</td>
<td width="224">  
  <input type="text" name="name" style="font-size: 9pt; background-color: #FFFFFF; color: #3366FF; border: 1 solid #000000" value="<?php echo $jl_forum[name];?>" size="17" maxlength="16">
  <font color="#FF0000">* </font> </td>
<td width="63" bgcolor="#acc0fa" align="right">密码：</td>
<td width="160">  
  <input type="password" name="password" size="10" maxlength="16" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">
  <font color="#FF0000">*</font> <font color="#FF0000"> </font> </td>
 </tr>
 <tr>  
<td colspan="4"><font color="#FFFFFF">主题：</font>  
  <input type="text" name="title" size="50" maxlength="50" style="font-size: 9pt; background-color: #FFFFFF; color: ##3366FF; border: 1 solid #000000">
  <font color="#FF0000">* </font></td>
 </tr>
 <tr>  
<td colspan="4"> <font color="#FFFFFF">内容：</font><br>
 
  <textarea name="cont" cols="70" rows="12" wrap="VIRTUAL"></textarea>
  <br>
  <input type="button" name="Submit2" value="取消" onclick="window.close()">
  <input type="submit" name="add" value="提交">
  <input type="checkbox" name="qm" value="qm" checked>
  <font color="#FFFFFF">使用签名</font>  
  <input type="hidden" name="board" value="<?php echo $board;?>">
</td>
 </tr>
  </table>
  </form>
<?php include "footer.php";?><br>
</body>
</html>
# query.php
<?php
 require("func.php");
 $sql="select * from boardinfo";
 $sql_result=mysql_query($sql);
?>
<html>
<head>
<title>main</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/page.css">
</head>

<body bgcolor="#FFFFFF" background="image/bg.gif">
<table width="90%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#FFCC99" bordercolordark="#FFCC99">
  <tr bgcolor="#CCFF99">  
 <td>
<div align="center"><b>论坛贴子查询</b></div>
 </td>
  </tr>
  <tr align="center">  
 <td>
<form method="post" action="query_list.php">
  在  
  <select name="board">
 <option selected>请选择版面</option>
<?php
while($sql_row=mysql_fetch_array($sql_result)){
?>  
 <option value="<?php echo $sql_row[name];?>"><?php echo $sql_row[chinesename];?></option>
<?php
}
?>
  </select>
  中查询<br>
  <input type="text" name="query_str" size="40" maxlength="40">
  <br>
  <input type="submit" name="title" value="按主题查询">
  <input type="submit" name="cont" value="按内容查询">
  <input type="submit" name="writer" value="按作者查询">
</form>
 </td>
  </tr>
  <tr bgcolor="#CCFF99">  
 <td>
<div align="center"><b>论坛信息</b></div>
 </td>
  </tr>
  <tr>
 <td>
<?php include "info.php";?>
 </td>
  </tr>
</table>
</body>
</html>
# query_list.php
<?php
require("func.php");
if (!empty($query_str)) {

if(!is_board_exits($board)){
 $board="computer";
}
if ($title){
 $submit="title";
}
elseif ($cont) {
 $submit="cont";
}
elseif ($writer) {
 $submit="writer";
}
else {
 $submit="title";
}
$sql="select * from $board where ($submit like '%$query_str%')";
$temp=mysql_query($sql);
$sum=mysql_num_rows($temp);
if ($sum!=0) {
$sql="select * from boardinfo where name='$board'";
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$chinesename=$sql_row[chinesename];
setcookie ("jl_forum[chinesename]",$chinesename);
$sql="select name from user where slaveboard='$board'";
$sql_result=mysql_query($sql);
?>
<html>
<head>
<title>List</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/index.css">
<script language="javascript">
function openwin(board,id){ window.open("good_read.php?board="+board+"&id="+id,"","height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
function post(board){ window.open("post.php?board="+board,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
</script>
</head>

<body bgcolor="#FFFFFF" background="image/bg.gif">
<?php include "header.php";?> <br>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
  <tr>
 <td height="20" width="22%" bgcolor="#E8E8E8">版面：<?php
echo $chinesename;
?></td>
 <td height="20" width="29%" bgcolor="#E8E8E8">版主：<?php
while ($sql_row=mysql_fetch_array($sql_result))
{
echo "$sql_row[name]"."&nbsp;";
}
# 选择出留言纪录;

$totalpage=ceil($sum/$pagesize);
# 分页
if($page<1 or empty($page)){
 $page=1;
}
elseif ($page>$totalpage){
$page=$totalpage;
}
elseif ($totalpage==0) {
 $page=0;
}
$offset=($page-1)*$pagesize;
$sql="select * from $board where ($submit like '%$query_str%') order by id desc limit $offset,$pagesize";
$sql_result=mysql_query($sql);
?> </td>
 <td height="20" width="17%" bgcolor="#E8E8E8">查询到<?php echo $sum; ?>条纪录</td>
 <td height="20" colspan="2" width="32%"><a href='javascript:post("<?php echo $board;?>")'><img src="/edu/files/pic/2006-5/25/0652520401213330.jpg"" width="92" height="21" border="0" alt="发新贴子"></a></td>
  </tr>
</table>
<br>
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolorlight="#CCCCCC" bordercolordark="#eeeeee">
  <tr bgcolor="#995100" align="center">
 <td width="6%"><font color="#FFFFFF">回应</font></td>
 <td width="67%" bgcolor="#995100"><font color="#FFFFFF">主 题</font></td>
 <td width="20%"><font color="#FFFFFF">时 间</font></td>
 <td width="7%"><font color="#FFFFFF">人气</font></td>
  </tr>
  <tr bgcolor="#FFCC99">
 <td colspan="5" height="2">&nbsp;</td>
  </tr>
  <?php
while ($sql_row=mysql_fetch_array($sql_result))
{
echo"<tr>";
echo"<td width="6%" bgcolor="#E8E8E8" align="center">";
echo "[*]";
echo"</td>";
echo"<td bgcolor="#E8FDEE" width="56%"><font face="宋体"><a href='javascript:openwin("$board",$sql_row[id])' title="作者:$sql_row[writer]　大小:$sql_row[size]字节">$sql_row[title]</a></font></td>";
  echo"<td width="18%" bgcolor="#FFF5DD" align="center">$sql_row[writetime]</td>";
  echo"<td width="6%" bgcolor="#E8FDEE" align="center">$sql_row[hits]</td>";
  echo"</tr>";
}
?>
  <tr bgcolor="#FFCC99">
 <td colspan="5" align="center" height="2">&nbsp;</td>
  </tr>
</table>
<div align="right">
<form method="post" action="<?php echo $php_self;?>">
 <input type="hidden" name="<?php echo $submit;?>" value="y">
 <input type="hidden" name="query_str" value="<?php echo $query_str;?>">
 共<b><?php echo $totalpage;?></b>页 第<b><?php echo $page;?></b>页·<?php
if ($page!=1){
  $back=$page-1;
  echo"<a href="$php_self?board=$board&page=1&$submit=y&query_str=$query_str">首页</a>　<a href="$php_self?board=$board&page=$back&$submit=y&query_str=$query_str">上一页</a>";
}
if ($page==1){
 echo"首页　上一页";
}
if($page!=$totalpage){
 $next=$page+1;
  echo"　<a href="$php_self?board=$board&page=$next&$submit=y&query_str=$query_str">下一页</a>　<a href="$php_self?board=$board&page=$totalpage&$submit=y&query_str=$query_str">尾页</a>";
}
if($page==$totalpage){
  echo"　下一页　尾页";
}
?>·转到  
 <input type="submit" name="goto" value="转到">
 <input type="text" name="page" size="2">
 页  
  </form>
</div>
<?php include "footer.php";?>
</body>
</html>
<?php
}
else
 {
 show_error(10);
}
}
else {
 show_error(9);
}
# read.php
<?php
require ("func.php");
if ($re){
  $sql="select slaveid from $board where id=$id";
  $sql_result=mysql_query($sql);
  $sql_row=mysql_fetch_array($sql_result);
  if($sql_row[slaveid]!=0){
show_error(1);
$founderr=1;
  }
  if (!check_user_password($name,$password)){
 show_error(4);
 $founderr=1;
  }
  if (empty($title)){
show_error(2);
$founderr=1;
  }
  if ($qm){
 $qm=expl_qm($name);
  }
  if(!$founderr){
re_doc($board,$id);
setcookie ("jl_forum[name]",$name);
$sql="select * from $board where id=$id";
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$title=$sql_row[title];
$writer=$sql_row[writer];
$cont=$sql_row[cont];
$writetime=$sql_row[writetime];
$hits=$sql_row[$hits];
$fromip=$sql_row[fromip];
$sql="select * from $board where slaveid=$id";
$sql_result=mysql_query($sql);
  # $sql_row=mysql_fetch_array($sql_result);
  }

}
elseif ($add){
  if (!is_board_exits($board)){
 show_error(7);
 $founderr=1;
  }
  if (empty($title)){
show_error(2);
$founderr=1;
  }
  if (!check_user_password($name,$password)){
 show_error(4);
 $founderr=1;
  }
  if ($qm){
 $qm=expl_qm($name);
  }
  if (!$founderr){
  add_doc($board);
  $add=1;
  setcookie ("jl_forum[name]",$name);
  }
}
else {
  if (!is_board_exits){
 show_error(7);
  }
  add_one_hit($board,$id);
  $sql="select * from $board where id=$id";
  $sql_result=mysql_query($sql);
  $sql_row=mysql_fetch_array($sql_result);
  $title=$sql_row[title];
  $writer=$sql_row[writer];
  $cont=$sql_row[cont];
  $writetime=$sql_row[writetime];
  $hits=$sql_row[$hits];
  $fromip=$sql_row[fromip];
  $sql="select * from $board where slaveid=$id";
  $sql_result=mysql_query($sql);
  #$sql_row=mysql_fetch_array($sql_result);
}
?>
<html>
<head>
<title><?php echo $title;?></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/index.css">
<script language="javascript">
function sendmsg(name){ window.open("sendmsg.php?name="+name,"","height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
</script>

</head>

<body bgcolor="#666699">
<?php include "ad.php";?><br>
<hr noshade width="98%" size="1">
<table width="98%" border="1" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
  <tr bgcolor="#666666">
 <td><font color="#FFcc00"><b>标题：<?php echo $title;?></b></font></td>
  </tr>
  <tr>
 <td bgcolor="#eeeeee">作者：<?php echo "$writer";?>(<?php echo $writetime;?>)　<a href="javascript:sendmsg('<?php echo "$writer";?>')"><img src="/edu/files/pic/2006-5/25/0652520401289318.gif"" width="18" height="17" alt="给作者留言" border="0"></a>　<a href="userinfo.php?name=<?php echo $writer;?>"><img src="/edu/files/pic/2006-5/25/0652520401321287.gif"" width="16" height="15" alt="察看用户资料" border="0"></a></td>
  </tr>
  <tr bgcolor="#ffffef">  
 <td><?php echo $cont;?></td>
  </tr>
  <tr bgcolor="#e8eee0">
 <td>※ 来源：<?php echo $jl_forum[chinesename];?> [◆FROM：<?php echo $fromip;?>]</td>
  </tr>
</table>
<br>
<?php
if ($add!=1){
while($sql_row=mysql_fetch_array($sql_result)) {
?>
<table width="98%" border="1" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
  <tr bgcolor="#015C71">
 <td><font color="#ffffff">标题：<?php echo $sql_row[title];?></font></td>
  </tr>
  <tr bgcolor="#eeeeee">
 <td>作者：<?php echo "$sql_row[writer]";?>(<?php echo $sql_row[writetime];?>)　<a href="javascript:sendmsg('<?php echo "$sql_row[writer]";?>')"><img src="/edu/files/pic/2006-5/25/0652520401289318.gif"" width="18" height="17" alt="给作者留言" border="0"></a>　<a href="userinfo.php?name=<?php echo "$sql_row[writer]";?>"><img src="/edu/files/pic/2006-5/25/0652520401321287.gif"" width="17" height="15" alt="察看用户资料" border="0"></a></td>
  </tr>
  <tr bgcolor="#ffffef">  
 <td><?php echo $sql_row[cont];?></td>
  </tr>
  <tr bgcolor="#e8eee0">
 <td>※ 来源：<?php echo $jl_forum[chinesename];?> [◆FROM：<?php echo $sql_row[fromip];?>]</td>
  </tr>
</table>
<?php
}
?>
<form method="post" action="read.php">
  <table width="98%" border="0" cellspacing="0" cellpadding="0" align="center">
 <tr>
<td>
  <table width="40" border="1" cellspacing="0" cellpadding="0" height="20" bordercolorlight="#000099" bordercolordark="#FFFFFF">
 <tr valign="middle" align="center" bgcolor="#acc0fa">
<td height="17">回复</td>
 </tr>
  </table>
</td>
 </tr>
  </table>
  <table width="98%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#686898" bordercolordark="#CCCCCC">
 <tr>
<td width="8%" align="right" bgcolor="#acc0fa">用户名</td>
<td width="33%">
  <input type="text" name="name" size="17" maxlength="16" value="<?php echo "$jl_forum[name]";?>">
  <font color="#FFFFFF">* </font></td>
<td width="7%" bgcolor="#acc0fa" align="center">密码</td>
<td width="52%">
  <input type="password" name="password" size="17" maxlength="16">
  <font color="#FFFFFF">* </font></td>
 </tr>
 <tr>
<td width="8%" align="right" bgcolor="#acc0fa">标题：</td>
<td colspan="3">
  <input type="text" name="title" size="40" maxlength="50">
  <font color="#FFFFFF"> * </font></td>
 </tr>
 <tr>
<td width="8%" align="right" bgcolor="#acc0fa">内容：</td>
<td colspan="3">
  <textarea name="cont" cols="60" rows="3" wrap="VIRTUAL"></textarea>
</td>
 </tr>
 <tr>
<td width="8%" align="right" bgcolor="#acc0fa">&nbsp;</td>
<td colspan="3">
  <input type="button" name="clear" value="关闭窗口" onclick="window.close()">
  <input type="submit" name="re" value="提交">
  <input type="checkbox" name="qm" value="qm" checked>
  <font color="#FFFFFF">使用签名
  <input type="hidden" name="board" value="<?php echo $board;?>">
  <input type="hidden" name="id" value="<?php echo $id;?>">
  </font></td>
 </tr>
  </table>
  <?php
  }
  ?>
  <br>
</form>
<?php include"footer.php";?><br>
</body>
</html>  
上一篇：基于mysql的论坛（5）
下一篇：基于mysql的论坛（7）
站内搜索