当前位置：首页 -> 技术开发 -> PHP专区 -> 基于mysql的论坛（7）

基于mysql的论坛（7）

时间： 2021-07-31 作者：daque

# 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=utf8"> <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=utf8"> <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=utf8"> <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); } ?>

基于mysql的论坛（7）

相关推荐

推荐下载

热门阅览

最新排行