基于mysql的论坛(7)
mysql 基于 论坛
2023-06-13 09:13:44 时间
#sendmsg.php
<?php
require"func.php";
if($b1){
if(is_user_exits($fromname)andcheck_user_password($fromname,$password)){
sendmsg();
echo"成功!<br><formmethod="POST"><inputtype="button"value="关闭窗口"name="B1"onclick="window.close()"></form>";
}
else{
$founderr=1;
echo"用户名/密码错误!";
}
}
else{
?>
<html>
<head>
<title>发送留言</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<linkrel="stylesheet"type="text/css"href="css/index.css">
</head>
<bodybgcolor="#eeeeee">
<formmethod="post"action="<?phpecho$php_self;?>">
<tablewidth="98%"border="1"cellspacing="0"cellpadding="0"bordercolorlight="#000000"bordercolordark="#FFFFFF">
<tralign="center">
<tdcolspan="2">给<ahref="userinfo.php?name=<?phpecho$name;?>"target="_blank"><?phpecho$name;?></a>
发送留言</td>
</tr>
<tr>
<tdalign="right"width="27%">您的用户名:</td>
<tdwidth="73%">
<inputtype="text"name="fromname"size="17"maxlength="16"value="<?phpecho$jl_forum[name];?>">
*</td>
</tr>
<tr>
<tdalign="right"width="27%">您的密码:</td>
<tdwidth="73%">
<inputtype="password"name="password"size="17"maxlength="16">
*</td>
</tr>
<tr>
<tdalign="right"width="27%"valign="top">内容:</td>
<tdwidth="73%">
<textareaname="cont"wrap="VIRTUAL"cols="40"rows="3"></textarea>
<inputtype="hidden"name="toname"value="<?phpecho$name;?>">
<br>
<inputtype="submit"name="b1"value="发送">
<inputtype="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="CREATETABLEboardinfo(namevarchar(50)NOTNULL,chinesenamevarchar(50)NOTNULL)";
mysql_query($sql)ordie("错误");
echo"ok!<br>";
echo"建立表user...";
$sql="CREATETABLEuser(idint(11)NOTNULLauto_increment,namevarchar(50)NOTNULL,sexvarchar(6),realnamevarchar(20),passwordvarchar(16)NOTNULL,addressvarchar(40),oicqvarchar(10),homepage varchar(50),scoreint(11),phonevarchar(20),emailvarchar(50),regtimevarchar(20),qmtext, slaveboardvarchar(50),PRIMARYKEY(id))";
mysql_query($sql)ordie("错误");
echo"ok!<br>";
echo"建立表message...";
$sql="createtablemessage(idint(11)NOTNULLauto_increment, namevarchar(50),fromnamevarchar(50),writetimevarchar(20),contlongtext,PRIMARYKEY(id))";
mysql_query($sql)ordie("错误");
echo"ok!<br>";
echo"初始化版面“个人电脑”...";
create_board_table("computer","个人电脑");
echo"ok!<br><br>";
echo"<h2>设置完毕!</h2>";
echo"<br><br>冷情疯子(电脑疯子)";
?>
##userinfo.php
<html>
<head>
<title>用户信息</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<linkrel="stylesheet"type="text/css"href="css/index.css">
</head>
<bodybgcolor="#FFFFFF"background="image/bg.gif">
<?phpinclude"header.php";
if(!isset($name)){
?>
<formmethod="post"action="<?phpecho$php_self;?>">
<tablewidth="90%"border="1"cellspacing="0"cellpadding="1"align="center"bordercolorlight="#CCCCCC"bordercolordark="#FFFFFF">
<tralign="center">
<td>请输入欲察看的用户名</td>
</tr>
<tralign="center">
<td>
<inputtype="text"name="name"size="18"maxlength="16">
</td>
</tr>
<tralign="center">
<td>
<inputtype="submit"name="b1"value="察看资料">
</td>
</tr>
</table>
</form>
<?php
}
else{
require"func.php";
if(is_user_exits($name)){
$sql="select*fromuserwherename="$name"";
$sql_result=mysql_query($sql);
$row=mysql_fetch_array($sql_result);
?>
<br>
<tablewidth="90%"border="1"cellspacing="0"cellpadding="1"align="center"bordercolorlight="#CCCCCC"bordercolordark="#FFFFFF">
<tr>
<td><b>详细资料</b></td>
</tr>
<tr>
<td>用户名:<?phpecho$row[name];?></td>
</tr>
<tr>
<td>真实姓名:<?phpecho$row[realname];?></td>
</tr>
<tr>
<td>性别:<?phpecho$row[sex];?></td>
</tr>
<tr>
<td>地址:<?phpecho$row[address];?></td>
</tr>
<tr>
<td>电话:<?phpecho$row[phone];?></td>
</tr>
<tr>
<td>OICQ:<?phpecho$row[oicq];?></td>
</tr>
<tr>
<td>Email:<ahref="mailto:<?phpecho$row[email];?>"><?phpecho$row[email];?></a></td>
</tr>
<tr>
<td>主页:<ahref="<?phpecho$row[homepage];?>"target="_blank"><?phpecho$row[homepage];?></a></td>
</tr>
<tr>
<td>注册时间:<?phpecho$row[regtime];?></td>
</tr>
<tr>
<td>目前积分:<?phpecho$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])andcheck_user_password($jl_forum[name],$jl_forum[password])){
if(isset($job)){
if(is_this_user($id)){
delmsg($id);
}
}
$name=$jl_forum[name];
$sql="select*frommessagewherename="$name"";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
?>
<html>
<head>
<title>察看留言</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<linkrel="stylesheet"type="text/css"href="css/index.css">
<scriptlanguage="javascript">
functionsendmsg(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>
<bodybgcolor="#FFFFFF"background="image/bg.gif">
<p>您目前共有<b><?phpecho$sum;?></b>条留言</p>
<tablewidth="98%"border="1"cellspacing="0"cellpadding="0"bordercolorlight="#CCCCCC"bordercolordark="#FFFFFF">
<?php
while($sql_row=mysql_fetch_array($sql_result)){
?>
<trbgcolor="#eeeeee">
<td><ahref="javascript:sendmsg("<?phpecho$sql_row[fromname];?>")"><?phpecho$sql_row[fromname];?></a>
于<?phpecho$sql_row[writetime];?><ahref="<?phpecho"$php_self?job=del&id=$sql_row[id]";?>">删除</a></td>
</tr>
<tr>
<td><?phpecho$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)andcheck_user_password($fromname,$password)){
sendmsg();
echo"成功!<br><formmethod="POST"><inputtype="button"value="关闭窗口"name="B1"onclick="window.close()"></form>";
}
else{
$founderr=1;
echo"用户名/密码错误!";
}
}
else{
?>
<html>
<head>
<title>发送留言</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<linkrel="stylesheet"type="text/css"href="css/index.css">
</head>
<bodybgcolor="#eeeeee">
<formmethod="post"action="<?phpecho$php_self;?>">
<tablewidth="98%"border="1"cellspacing="0"cellpadding="0"bordercolorlight="#000000"bordercolordark="#FFFFFF">
<tralign="center">
<tdcolspan="2">给<ahref="userinfo.php?name=<?phpecho$name;?>"target="_blank"><?phpecho$name;?></a>
发送留言</td>
</tr>
<tr>
<tdalign="right"width="27%">您的用户名:</td>
<tdwidth="73%">
<inputtype="text"name="fromname"size="17"maxlength="16"value="<?phpecho$jl_forum[name];?>">
*</td>
</tr>
<tr>
<tdalign="right"width="27%">您的密码:</td>
<tdwidth="73%">
<inputtype="password"name="password"size="17"maxlength="16">
*</td>
</tr>
<tr>
<tdalign="right"width="27%"valign="top">内容:</td>
<tdwidth="73%">
<textareaname="cont"wrap="VIRTUAL"cols="40"rows="3"></textarea>
<inputtype="hidden"name="toname"value="<?phpecho$name;?>">
<br>
<inputtype="submit"name="b1"value="发送">
<inputtype="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="CREATETABLEboardinfo(namevarchar(50)NOTNULL,chinesenamevarchar(50)NOTNULL)";
mysql_query($sql)ordie("错误");
echo"ok!<br>";
echo"建立表user...";
$sql="CREATETABLEuser(idint(11)NOTNULLauto_increment,namevarchar(50)NOTNULL,sexvarchar(6),realnamevarchar(20),passwordvarchar(16)NOTNULL,addressvarchar(40),oicqvarchar(10),homepage varchar(50),scoreint(11),phonevarchar(20),emailvarchar(50),regtimevarchar(20),qmtext, slaveboardvarchar(50),PRIMARYKEY(id))";
mysql_query($sql)ordie("错误");
echo"ok!<br>";
echo"建立表message...";
$sql="createtablemessage(idint(11)NOTNULLauto_increment, namevarchar(50),fromnamevarchar(50),writetimevarchar(20),contlongtext,PRIMARYKEY(id))";
mysql_query($sql)ordie("错误");
echo"ok!<br>";
echo"初始化版面“个人电脑”...";
create_board_table("computer","个人电脑");
echo"ok!<br><br>";
echo"<h2>设置完毕!</h2>";
echo"<br><br>冷情疯子(电脑疯子)";
?>
##userinfo.php
<html>
<head>
<title>用户信息</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<linkrel="stylesheet"type="text/css"href="css/index.css">
</head>
<bodybgcolor="#FFFFFF"background="image/bg.gif">
<?phpinclude"header.php";
if(!isset($name)){
?>
<formmethod="post"action="<?phpecho$php_self;?>">
<tablewidth="90%"border="1"cellspacing="0"cellpadding="1"align="center"bordercolorlight="#CCCCCC"bordercolordark="#FFFFFF">
<tralign="center">
<td>请输入欲察看的用户名</td>
</tr>
<tralign="center">
<td>
<inputtype="text"name="name"size="18"maxlength="16">
</td>
</tr>
<tralign="center">
<td>
<inputtype="submit"name="b1"value="察看资料">
</td>
</tr>
</table>
</form>
<?php
}
else{
require"func.php";
if(is_user_exits($name)){
$sql="select*fromuserwherename="$name"";
$sql_result=mysql_query($sql);
$row=mysql_fetch_array($sql_result);
?>
<br>
<tablewidth="90%"border="1"cellspacing="0"cellpadding="1"align="center"bordercolorlight="#CCCCCC"bordercolordark="#FFFFFF">
<tr>
<td><b>详细资料</b></td>
</tr>
<tr>
<td>用户名:<?phpecho$row[name];?></td>
</tr>
<tr>
<td>真实姓名:<?phpecho$row[realname];?></td>
</tr>
<tr>
<td>性别:<?phpecho$row[sex];?></td>
</tr>
<tr>
<td>地址:<?phpecho$row[address];?></td>
</tr>
<tr>
<td>电话:<?phpecho$row[phone];?></td>
</tr>
<tr>
<td>OICQ:<?phpecho$row[oicq];?></td>
</tr>
<tr>
<td>Email:<ahref="mailto:<?phpecho$row[email];?>"><?phpecho$row[email];?></a></td>
</tr>
<tr>
<td>主页:<ahref="<?phpecho$row[homepage];?>"target="_blank"><?phpecho$row[homepage];?></a></td>
</tr>
<tr>
<td>注册时间:<?phpecho$row[regtime];?></td>
</tr>
<tr>
<td>目前积分:<?phpecho$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])andcheck_user_password($jl_forum[name],$jl_forum[password])){
if(isset($job)){
if(is_this_user($id)){
delmsg($id);
}
}
$name=$jl_forum[name];
$sql="select*frommessagewherename="$name"";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
?>
<html>
<head>
<title>察看留言</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<linkrel="stylesheet"type="text/css"href="css/index.css">
<scriptlanguage="javascript">
functionsendmsg(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>
<bodybgcolor="#FFFFFF"background="image/bg.gif">
<p>您目前共有<b><?phpecho$sum;?></b>条留言</p>
<tablewidth="98%"border="1"cellspacing="0"cellpadding="0"bordercolorlight="#CCCCCC"bordercolordark="#FFFFFF">
<?php
while($sql_row=mysql_fetch_array($sql_result)){
?>
<trbgcolor="#eeeeee">
<td><ahref="javascript:sendmsg("<?phpecho$sql_row[fromname];?>")"><?phpecho$sql_row[fromname];?></a>
于<?phpecho$sql_row[writetime];?><ahref="<?phpecho"$php_self?job=del&id=$sql_row[id]";?>">删除</a></td>
</tr>
<tr>
<td><?phpecho$sql_row[cont];?></td>
</tr>
<tr>
<td> </td>
</tr>
<?php
}
?>
</table>
<p> </p>
</body>
</html>
<?php
}
else{
show_error(4);
}
?>
相关文章
- MySQL笔试题:突破难关,学习答案(mysql笔试题目及答案)
- MySQL论坛:一个让您收获知识的社区(mysql论坛)
- acle用户指南MySQL与Oracle用户指南(mysql之or)
- 服务MySQL命令行启动服务的步骤(mysql命令启动)
- 基于MySQL的存储过程开发技能(mysql存储过程开发)
- 机制MySQL数据库的加锁机制解读(mysql数据库加锁)
- MySQL查询优化:基于分区的数据检索(mysql查询分区)
- 基于MySQL的唯一索引创建实践(mysql创建唯一索引)
- 使用Qt实现MySQL数据库连接教程(qt连接mysql数据库)
- MySQL拒绝远程访问:如何解决?(mysql远程访问拒绝)
- 构建基于Redis与MySQL的实时数据同步(redis与mysql数据同步)
- MySQL中如何录入中文数据(mysql中中文数据录入)
- 服务器C语言连接MySQL本地服务器实践(c mysql连接到本地)
- MySQL实现两表统计项目,让数据更加清晰明了(mysql两表统计项目)
- 基于Chroot技术实现MySQL数据库安全防护(chroot mysql)
- 集群基于CDH和MySQL搭建高可用性分布式集群(cdh mysql搭建)
- 解决Windows CMD访问MySQL乱码问题(cmd访问mysql乱码)
- 如何在MySQL中创建表空间(mysql中创建表空间)
- MYSQL收费了 了解MySQL开源版的最新政策(mysql不再免费了吗)
- MySQL层级关系操作详解(mysql上下级层级关系)
- MySQL不仅仅是一个可视化界面(mysql不是可视化界面)
- MySQL无法实现递归操作(mysql不支持递归)
- 基于mysql的论坛(1)
- 基于mysql的论坛(2)