当前位置: 首页 > 图文教程 > 网络编程 > PHP > 基于mysql的论坛（6）

PHP
php 远程图片保存到本地的函数类
php 破解防盗链图片函数
快速开发一个PHP扩展图文教程
PHP6 mysql连接方式说明
php 进度条实现代码
php discuz 主题表和回帖表的设计
php 无限级缓存的类的扩展
php adodb操作mysql数据库
php FPDF类库应用实现代码
sourcesafe管理phpproj文件的补充说明(downmoon)
AspNetAjaxPager,Asp.Net通用无刷新Ajax分页控件，支持多样式多数据绑定
php一句话cmdshell新型 (非一句话木马)
php 木马的分析(加密破解)
PHP 数组入门教程小结
php 方便水印和缩略图的图形类
PHP加速 eAccelerator配置和使用指南
PHP 组件化编程技巧
IIS6+PHP5+MySQL5+Zend Optimizer+phpMyAdmin安装配置图文教程 2009年
两个强悍的php 图像处理类1
PHP 数据库 常见问题小结

No. « 164 165 166 167 »

技术文章搜索

关键字

PHP 中的 基于mysql的论坛（6）

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 139 ::
收藏到网摘: n/a

# 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]"." ";
}
# 选择出留言纪录;
$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"> </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"> </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"> </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>