文章詳情頁
基于mysql的論壇（7）
瀏覽：142日期：2023-10-26 15:21:51
# 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); } ?>;
上一條：基于mysql的論壇（6）下一條：一個簡單的MySQL數據瀏覽器
排行榜
網公網安備