您的位置:首页技术文章
文章详情页

基于mysql的论坛(6)

【字号: 日期:2023-10-26 15:09:58浏览:57作者:猪猪
# 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>;
标签: MySQL 数据库