基于mysql的論壇（7）
更新時間：2006年10月09日 00:00:00 作者：
# sendmsg.php
<?php
require "func.php";
if ($b1) {
if (is_user_exits($fromname) and check_user_password($fromname,$password)) {
sendmsg();
echo "成功！<br><form method="POST"><input type="button" value=" 關閉窗口 " name="B1" onclick="window.close()"></form>";
}
else {
$founderr=1;
echo "用戶名/密碼錯誤！";
}
}
else {
?>
<html>
<head>
<title>發(fā)送留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/index.css">
</head>
<body bgcolor="#eeeeee">
<form method="post" action="<?php echo $php_self;?>">
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr align="center">
<td colspan="2">給 <a href="userinfo.php?name=<?php echo $name;?>" target="_blank"><?php echo $name;?></a>
發(fā)送留言</td>
</tr>
<tr>
<td align="right" width="27%">您的用戶名：</td>
<td width="73%">
<input type="text" name="fromname" size="17" maxlength="16" value="<?php echo $jl_forum[name];?>">
* </td>
</tr>
<tr>
<td align="right" width="27%">您的密碼：</td>
<td width="73%">
<input type="password" name="password" size="17" maxlength="16">
* </td>
</tr>
<tr>
<td align="right" width="27%" valign="top">內容：</td>
<td width="73%">
<textarea name="cont" wrap="VIRTUAL" cols="40" rows="3"></textarea>
<input type="hidden" name="toname" value="<?php echo $name;?>">
<br>
<input type="submit" name="b1" value="發(fā)送">
<input type="button" name="Submit" value="取消" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
###############
# setup.php
# 此為初始化程序，只在上傳后第一次執(zhí)行，之后必須delete,以免出錯
#################
<?php
require "func.php";
echo "<h1>初始化數(shù)據庫</h1><br><br>";
echo "建立數(shù)據庫連接...ok!<br>";
echo "建立表 boardinfo...";
$sql="CREATE TABLE boardinfo (name varchar(50) NOT NULL, chinesename varchar(50) NOT NULL)";
mysql_query($sql) or die("錯誤");
echo "ok!<br>";
echo "建立表 user...";
$sql="CREATE TABLE user (id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL, sex varchar(6), realname varchar(20), password varchar(16) NOT NULL, address varchar(40), oicq varchar(10), homepage varchar(50), score int(11), phone varchar(20), email varchar(50), regtime varchar(20), qm text, slaveboard varchar(50), PRIMARY KEY (id))";
mysql_query($sql) or die("錯誤");
echo "ok!<br>";
echo "建立表 message... ";
$sql="create table message (id int(11) NOT NULL auto_increment, name varchar(50), fromname varchar(50), writetime varchar(20), cont longtext, PRIMARY KEY(id))";
mysql_query($sql) or die("錯誤");
echo "ok!<br>";
echo "初始化版面 “個人電腦”...";
create_board_table('computer','個人電腦');
echo "ok!<br><br>";
echo "<h2>設置完畢！</h2>";
echo "<br><br>冷情瘋子（電腦瘋子）";
?>
## userinfo.php
<html>
<head>
<title>用戶信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/index.css">
</head>
<body bgcolor="#FFFFFF" background="image/bg.gif">
<?php include "header.php";
if (!isset($name)) {
?>
<form method="post" action="<?php echo $php_self;?>">
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr align="center">
<td>請輸入欲察看的用戶名</td>
</tr>
<tr align="center">
<td>
<input type="text" name="name" size="18" maxlength="16">
</td>
</tr>
<tr align="center">
<td>
<input type="submit" name="b1" value="察看資料">
</td>
</tr>
</table>
</form>
<?php
}
else {
require "func.php";
if (is_user_exits($name)) {
$sql="select * from user where name='$name'";
$sql_result=mysql_query($sql);
$row=mysql_fetch_array($sql_result);
?>
<br>
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td><b>詳細資料</b></td>
</tr>
<tr>
<td>用戶名：<?php echo $row[name];?></td>
</tr>
<tr>
<td>真實姓名：<?php echo $row[realname];?></td>
</tr>
<tr>
<td>性別：<?php echo $row[sex];?></td>
</tr>
<tr>
<td>地址：<?php echo $row[address];?></td>
</tr>
<tr>
<td>電話：<?php echo $row[phone];?></td>
</tr>
<tr>
<td>OICQ：<?php echo $row[oicq];?></td>
</tr>
<tr>
<td>Email：<a href="mailto:<?php echo $row[email];?>"><?php echo $row[email];?></a></td>
</tr>
<tr>
<td>主頁：<a href="<?php echo $row[homepage];?>" target="_blank"><?php echo $row[homepage];?></a></td>
</tr>
<tr>
<td>注冊時間：<?php echo $row[regtime];?></td>
</tr>
<tr>
<td>目前積分：<?php echo $row[score];?></td>
</tr>
</table>
<br>
<?php
}
else {
echo "請輸入正確合法存在的用戶名稱";
}
}
include "footer.php";?>
</body>
</html>
# viewmsg.php
<?php
require "func.php";
if (is_user_exits($jl_forum[name]) and check_user_password($jl_forum[name],$jl_forum[password])) {
if (isset($job)) {
if (is_this_user($id)) {
delmsg($id);
}
}
$name=$jl_forum[name];
$sql="select * from message where name='$name'";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
?>
<html>
<head>
<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="#FFFFFF" background="image/bg.gif">
<p>您目前共有 <b><?php echo $sum;?></b> 條留言</p>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<?php
while ($sql_row=mysql_fetch_array($sql_result)) {
?>
<tr bgcolor="#eeeeee">
<td><a href="javascript:sendmsg('<?php echo $sql_row[fromname];?>')"><?php echo $sql_row[fromname];?></a>
于 <?php echo $sql_row[writetime];?> <a href="<?php echo "$php_self?job=del&id=$sql_row[id]";?>">刪除</a></td>
</tr>
<tr>
<td><?php echo $sql_row[cont];?></td>
</tr>
<tr>
<td> </td>
</tr>
<?php
}
?>
</table>
<p> </p>
</body>
</html>
<?php
}
else {
show_error(4);
}
?>
<?php
require "func.php";
if ($b1) {
if (is_user_exits($fromname) and check_user_password($fromname,$password)) {
sendmsg();
echo "成功！<br><form method="POST"><input type="button" value=" 關閉窗口 " name="B1" onclick="window.close()"></form>";
}
else {
$founderr=1;
echo "用戶名/密碼錯誤！";
}
}
else {
?>
<html>
<head>
<title>發(fā)送留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/index.css">
</head>
<body bgcolor="#eeeeee">
<form method="post" action="<?php echo $php_self;?>">
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr align="center">
<td colspan="2">給 <a href="userinfo.php?name=<?php echo $name;?>" target="_blank"><?php echo $name;?></a>
發(fā)送留言</td>
</tr>
<tr>
<td align="right" width="27%">您的用戶名：</td>
<td width="73%">
<input type="text" name="fromname" size="17" maxlength="16" value="<?php echo $jl_forum[name];?>">
* </td>
</tr>
<tr>
<td align="right" width="27%">您的密碼：</td>
<td width="73%">
<input type="password" name="password" size="17" maxlength="16">
* </td>
</tr>
<tr>
<td align="right" width="27%" valign="top">內容：</td>
<td width="73%">
<textarea name="cont" wrap="VIRTUAL" cols="40" rows="3"></textarea>
<input type="hidden" name="toname" value="<?php echo $name;?>">
<br>
<input type="submit" name="b1" value="發(fā)送">
<input type="button" name="Submit" value="取消" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
###############
# setup.php
# 此為初始化程序，只在上傳后第一次執(zhí)行，之后必須delete,以免出錯
#################
<?php
require "func.php";
echo "<h1>初始化數(shù)據庫</h1><br><br>";
echo "建立數(shù)據庫連接...ok!<br>";
echo "建立表 boardinfo...";
$sql="CREATE TABLE boardinfo (name varchar(50) NOT NULL, chinesename varchar(50) NOT NULL)";
mysql_query($sql) or die("錯誤");
echo "ok!<br>";
echo "建立表 user...";
$sql="CREATE TABLE user (id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL, sex varchar(6), realname varchar(20), password varchar(16) NOT NULL, address varchar(40), oicq varchar(10), homepage varchar(50), score int(11), phone varchar(20), email varchar(50), regtime varchar(20), qm text, slaveboard varchar(50), PRIMARY KEY (id))";
mysql_query($sql) or die("錯誤");
echo "ok!<br>";
echo "建立表 message... ";
$sql="create table message (id int(11) NOT NULL auto_increment, name varchar(50), fromname varchar(50), writetime varchar(20), cont longtext, PRIMARY KEY(id))";
mysql_query($sql) or die("錯誤");
echo "ok!<br>";
echo "初始化版面 “個人電腦”...";
create_board_table('computer','個人電腦');
echo "ok!<br><br>";
echo "<h2>設置完畢！</h2>";
echo "<br><br>冷情瘋子（電腦瘋子）";
?>
## userinfo.php
<html>
<head>
<title>用戶信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/index.css">
</head>
<body bgcolor="#FFFFFF" background="image/bg.gif">
<?php include "header.php";
if (!isset($name)) {
?>
<form method="post" action="<?php echo $php_self;?>">
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr align="center">
<td>請輸入欲察看的用戶名</td>
</tr>
<tr align="center">
<td>
<input type="text" name="name" size="18" maxlength="16">
</td>
</tr>
<tr align="center">
<td>
<input type="submit" name="b1" value="察看資料">
</td>
</tr>
</table>
</form>
<?php
}
else {
require "func.php";
if (is_user_exits($name)) {
$sql="select * from user where name='$name'";
$sql_result=mysql_query($sql);
$row=mysql_fetch_array($sql_result);
?>
<br>
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td><b>詳細資料</b></td>
</tr>
<tr>
<td>用戶名：<?php echo $row[name];?></td>
</tr>
<tr>
<td>真實姓名：<?php echo $row[realname];?></td>
</tr>
<tr>
<td>性別：<?php echo $row[sex];?></td>
</tr>
<tr>
<td>地址：<?php echo $row[address];?></td>
</tr>
<tr>
<td>電話：<?php echo $row[phone];?></td>
</tr>
<tr>
<td>OICQ：<?php echo $row[oicq];?></td>
</tr>
<tr>
<td>Email：<a href="mailto:<?php echo $row[email];?>"><?php echo $row[email];?></a></td>
</tr>
<tr>
<td>主頁：<a href="<?php echo $row[homepage];?>" target="_blank"><?php echo $row[homepage];?></a></td>
</tr>
<tr>
<td>注冊時間：<?php echo $row[regtime];?></td>
</tr>
<tr>
<td>目前積分：<?php echo $row[score];?></td>
</tr>
</table>
<br>
<?php
}
else {
echo "請輸入正確合法存在的用戶名稱";
}
}
include "footer.php";?>
</body>
</html>
# viewmsg.php
<?php
require "func.php";
if (is_user_exits($jl_forum[name]) and check_user_password($jl_forum[name],$jl_forum[password])) {
if (isset($job)) {
if (is_this_user($id)) {
delmsg($id);
}
}
$name=$jl_forum[name];
$sql="select * from message where name='$name'";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
?>
<html>
<head>
<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="#FFFFFF" background="image/bg.gif">
<p>您目前共有 <b><?php echo $sum;?></b> 條留言</p>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<?php
while ($sql_row=mysql_fetch_array($sql_result)) {
?>
<tr bgcolor="#eeeeee">
<td><a href="javascript:sendmsg('<?php echo $sql_row[fromname];?>')"><?php echo $sql_row[fromname];?></a>
于 <?php echo $sql_row[writetime];?> <a href="<?php echo "$php_self?job=del&id=$sql_row[id]";?>">刪除</a></td>
</tr>
<tr>
<td><?php echo $sql_row[cont];?></td>
</tr>
<tr>
<td> </td>
</tr>
<?php
}
?>
</table>
<p> </p>
</body>
</html>
<?php
}
else {
show_error(4);
}
?>
相關文章
用PHP制作靜態(tài)網站的模板框架(一)...2006-10-10
注釋在寫代碼的過程中非常重要，好的注釋能讓你的代碼讀起來更輕松，在寫代碼的時候一定要注意注釋的規(guī)范,這里腳本之家小編就為大家整理一下，需要的朋友可以參考下2018-01-01
PHP中call_user_func_array()函數(shù)的用法演示
今天，看了一段代碼，里面用到了很多call_user_func_array()函數(shù)，一開始，也是非常的迷糊，后來經過查手冊發(fā)現(xiàn)，call_user_func_array()函數(shù)還是很好用的，所以把PHP中call_user_func_array()函數(shù)用法用簡單的代碼示例來說明一下2012-02-02
做個自己站內搜索引擎...2006-10-10
PHP系統(tǒng)流量分析的程序...2006-10-10
今天小編就為大家分享一篇關于PHP asXML()函數(shù)講解，小編覺得內容挺不錯的，現(xiàn)在分享給大家，具有很好的參考價值，需要的朋友一起跟隨小編來看看吧2019-02-02
關于文本留言本的分頁代碼...2006-10-10
PHP4在Windows2000下的安裝...2006-10-10
PHP新手上路（十一）...2006-10-10
php替換超長文本中的特殊字符的函數(shù)，主要就是通過str_replace實現(xiàn)字符的簡單體會2012-05-05