基于mysql的论坛（7）
作者：bea
# 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" oncl
# 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>发送留言</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>
发送留言</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="发送">
<input type="button" name="Submit" value="取消" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
###############
# setup.php
# 此为初始化程序，只在上传后第一次执行，之后必须delete,以免出错
#################
<?php
require "func.php";
echo "<h1>初始化数据库</h1><br><br>";
echo "建立数据库连接...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>发送留言</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>
发送留言</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="发送">
<input type="button" name="Submit" value="取消" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
###############
# setup.php
# 此为初始化程序，只在上传后第一次执行，之后必须delete,以免出错
#################
<?php
require "func.php";
echo "<h1>初始化数据库</h1><br><br>";
echo "建立数据库连接...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类
- 搜索和替换文件或目录的一个好类--很实用
- 非常好的php目录导航文件代码
- PHP4.04简明安装
- 利用 window_onload 实现select默认选择
- 将RTF格式的文件转成HTML并在网页中显示的代码
- 简单的用PHP编写的导航条程序
- 信用卡效验程序
- 用文本文件实现的动态实时发布新闻的程序
- 如何删除多级目录
- 用PHP实现多级树型菜单
- PHP4在Windows2000下的安装
- 模仿OSO的论坛（五）
- 基于mysql的论坛（2）
- 基于mysql的论坛（1）
- 基于mysql的论坛（4）
- 基于mysql的论坛（5）
- 基于mysql的论坛（6）
- 生成sessionid和随机密码的例子