电脑技术学习

基于mysql的论坛(6)

dn001
# 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="image/newtopic.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="image/icon1.gif" width="18" height="17" alt="给作者留言" border="0"></a> <a href="userinfo.php?name=<?php echo $writer;?>"><img src="image/profile.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="image/icon1.gif" width="18" height="17" alt="给作者留言" border="0"></a> <a href="userinfo.php?name=<?php echo "$sql_row[writer]";?>"><img src="image/profile.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>;

标签: