首頁 > 開發者 > MySQL

基於mysql的論壇（5）

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

## manage_read.php
<?php
require ("func.php");
if (check_admin_password()) {
$board=$jl_forum[board];
switch ($job){
case "setgood":
set_good($jl_forum[board],$uid);
$work=1;
break;
case "setnogood":
set_no_good($jl_forum[board],$uid);
$work=1;
break;
case "delete":
del_doc($jl_forum[board],$uid);
$work=1;
break;
}
if (!$word) {
add_one_hit($board,$id);
}
$sql="select * from $board where id=$id";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
$sql_row=mysql_fetch_array($sql_result);
$title=$sql_row[title];
$writer=$sql_row[writer];
$cont=$sql_row[cont];
$writetime=$sql_row[writetime];
$hits=$sql_row[hits];
$good=$sql_row[good];
$rootid=$sql_row[id];
$fromip=$sql_row[fromip];
$sql="select * from $board where slaveid=$id";
$sql_result=mysql_query($sql);
if ($sum<>0) {
?>
<html>
<head>
<title><?php echo $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="#666699">
<?php include "ad.php";?><br>
<hr noshade width="98%" size="1">
<table width="98%" border="1" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr bgcolor="#666666">
<td><font color="#FFcc00"><b>標題：<?php echo $title;?>　<font color="#FFFFCC">◎操作：</font></b></font><b><?php echo "<a href="$php_self?job=setgood&uid=$id&id=$rootid">";?><font color="#FFFFFF">轉進精華區</font></a></b><font color="#FFcc00"><b>　</b></font><b><?php echo "<a href="$php_self?job=delete&uid=$id&id=$rootid">";?><font color="#FFFFFF">刪除</font></a></b><font color="#FFcc00"><b><?php
if ($good=="y"){
?> </b></font><b><?php echo "<a href="$php_self?job=setnogood&uid=$id&id=$rootid">";?><font color="#FFFFFF">轉出精華區</font></a></b><font color="#FFcc00"><b>
<?php
}
?> </b></font></td>
</tr>
<tr>
<td bgcolor="#eeeeee">作者：<?php echo "$writer";?>(<?php echo $writetime;?>,點擊:<?php echo $hits;?>)　<a href="javascript:sendmsg('<?php echo "$writer";?>')"><img src="image/icon1.gif" width="18" height="17" alt="給作者留言" border="0"></a>　<a href="userinfo.php?name=<?php echo $writer;?>"><img src="image/profile.gif" width="16" height="16" alt="察看使用者資料" border="0"></a></td>
</tr>
<tr>
<td bgcolor="#ffffef"><?php echo $cont;?></td>
</tr>
<tr bgcolor="#e8eee0">
<td>※ 來源：<?php echo $jl_forum[chinesename];?> [◆FROM：<?php echo $fromip;?>]</td>
</tr>
</table>
<br>
<?php
if (!$add){
while($sql_row=mysql_fetch_array($sql_result)) {
$good=$sql_row[good];
?>
<table width="98%" border="1" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr bgcolor="#015C71">
<td><font color="#ffffff">標題：<?php echo $sql_row[title];
$id=$sql_row[id];
?>　<font color="#FFFFCC">◎操作：</font></b></font><b><?php echo "<a href="$php_self?job=setgood&uid=$id&id=$rootid">";?><font color="#FFFFFF">轉進精華區</font></a></b><font color="#FFcc00"><b>　</b></font><b><?php echo "<a href="$php_self?job=delete&uid=$id&id=$rootid">";?><font color="#FFFFFF">刪除</font></a></b><font color="#FFcc00"><b><?php
if ($good=="y"){
?> </b></font><b><?php echo "<a href="$php_self?job=setnogood&uid=$id&id=$rootid">";?><font color="#FFFFFF">轉出精華區</font></a></b><font color="#FFcc00"><b>
<?php
}
?> </b></font></td>
</tr>
<tr bgcolor="#eeeeee">
<td>作者：<?php echo "$sql_row[writer]";?>(<?php echo $sql_row[writetime];?>)　<a href="javascript:sendmsg('<?php echo "$sql_row[writer]";?>')"><img src="image/icon1.gif" width="18" height="17" alt="給作者留言" border="0"></a>　<a href="userinfo.php?name=<?php echo "$sql_row[writer]";?>"><img src="image/profile.gif" width="17" height="16" alt="察看使用者資料" border="0"></a></td>
</tr>
<tr>
<td bgcolor="#ffffef"><?php echo $sql_row[cont];?></td>
</tr>
<tr bgcolor="#e8eee0">
<td>※ 來源：<?php echo $jl_forum[chinesename];?> [◆FROM：<?php echo $sql_row[fromip];?>]</td>
</tr>
</table>
<?php
}
}
?> <br>
<?php include"footer.php";?><br>
</body>
</html>
<?php
}
else {
echo "此條紀錄已經被刪除";
}
}
else {
show_error(1);
}
?>
## modify.php
<?php
require "func.php";
if (check_user_password($jl_forum[name],$jl_forum[password])) {
$name=$jl_forum[name];
$password=$jl_forum[password];
$sql="select * from user where name='$name'";
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($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">
</head>
<body bgcolor="#FFFFFF" background="image/bg.gif">
<?php include "header.php";?><br>
<hr noshade width="97%" size="1">
<div align="center">修改使用者設定檔<br>
<table width="90%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#336699" bordercolordark="#FFFFFF">
<tr valign="top">
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2">
<form method="post" action="change.php">
<table width="80%" border="0" cellspacing="0" cellpadding="3" align="center">
<tr>
<td align="right">使用者名稱</td>
<td><?php echo $name;?></td>
</tr>
<tr>
<td align="right">密碼</td>
<td>
<input type="password" name="pwd1" maxlength="8" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="9" value="<?php echo $password;?>">
* </td>
</tr>
<tr>
<td align="right">重複密碼</td>
<td>
<input type="password" name="pwd2" maxlength="8" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="9" value="<?php echo $password;?>">
* </td>
</tr>
<tr>
<td align="right">Email</td>
<td>
<input type="text" name="email" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" value="<?php echo $sql_row[email];?>">
* </td>
</tr>
<tr>
<td align="right">性別</td>
<td>
<select name="sex">
<option value="秘密" selected>秘密</option>
<option value="男">男</option>
<option value="女">女</option>
</select>
</td>
</tr>
<tr>
<td align="right">真實性名</td>
<td>
<input type="text" name="realname" size="17" maxlength="16" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" value="<?php echo $sql_row[realname];?>">
</td>
</tr>
<tr>
<td align="right">地址</td>
<td>
<input type="text" name="address" maxlength="40" size="30" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" value="<?php echo $sql_row[address];?>">
</td>
</tr>
<tr>
<td align="right">電話</td>
<td>
<input type="text" name="phone" size="22" maxlength="20" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" value="<?php echo $sql_row[phone];?>">
</td>
</tr>
<tr>
<td align="right">首頁</td>
<td>
<input type="text" name="homepage" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="50" value="<?php echo $sql_row[homepage];?>">
</td>
</tr>
<tr>
<td align="right">OICQ</td>
<td>
<input type="text" name="oicq" maxlength="11" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="12" value="<?php echo $sql_row[oicq];?>">
</td>
</tr>
<tr>
<td align="right">簽名</td>
<td><?php echo "$sql_row[qm]<br>";?>
<textarea name="qm" wrap="VIRTUAL" cols="50"></textarea>
</td>
</tr>
<tr>
<td align="right"> </td>
<td align="center">
<input type="submit" name="b2" value="修改">
<input type="reset" name="Submit2" value="清除" >
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<div align="center"><br>
</div>
</div>
<?php include "footer.php";?>
</body>
</html>
<?php
}
else {
show_error(4);
}
?>
## modify_l.php
<?php
require "func.php";
if ($b1) {
if (is_user_exits($name) and check_user_password($name,$password)) {
setcookie ("jl_forum[name]",$name);
setcookie ("jl_forum[password]",$password);
redirect2("modify.php");
}
else {
show_error(4);
}
}
else {
?>
<html>
<head>
<title>main</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/page.css">
</head>

<body bgcolor="#FFFFFF" background="image/bg.gif">
<table width="90%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#FFCC99" bordercolordark="#FFCC99">
<tr bgcolor="#CCFF99">
<td>
<div align="center"><b>修改資料登陸</b></div>
</td>
</tr>
<tr align="center">
<td>
<form method="post" action="modify_l.php">
<table width="70%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="38%" align="right">使用者名稱：</td>
<td width="62%" align="left">
<input type="text" name="name" size="17" maxlength="16">
</td>
</tr>
<tr>
<td width="38%" align="right">密碼：</td>
<td width="62%" align="left">
<input type="password" name="password" size="17" maxlength="16">
</td>
</tr>
</table>
<input type="submit" name="b1" value="進入">
</form>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td>
<div align="center"><b>論壇資訊</b></div>
</td>
</tr>
<tr valign="top">
<td>
<?php include "info.php";?>
</td>
</tr>
</table>
</body>
</html>
<?php
}
?>
## oper.php
<?php
require "func.php";
if (adminok()) {
if (isset($add_board)) {
if (isset($name) and isset($chinesename) and !is_board_exits($name)) {
create_board_table($name,$chinesename);
}
else {
echo "出現錯誤!(可能版面已經存在）";
$founderr=1;
}
}
elseif (isset($del_board)) {
if (isset($board)) {
drop_board_table($board);
}
else {
echo "出現錯誤!(請選擇要刪除的版面)";
$founderr=1;
}
}
elseif (isset($modify)) {
if (isset($name) and isset($chinesename)) {
update_board($name,$chinesename);
}
else {
echo "出現錯誤!(請填寫完整)";
$founderr=1;
}
}
elseif (isset($add_admin)) {
if (is_user_exits($name) and isset($board)) {
add_admin($board,$name);
}
else {
echo "出現錯誤!(極有可能是使用者不存在)";
$founderr=1;
}
}
elseif (isset($delete_admin)) {
if (is_user_exits($name)) {
del_admin($name);
}
else {
echo "出現錯誤!(極有可能是使用者不存在)";
$founderr=1;
}
}
else {
echo "你要幹什嗎？";
$founderr=1;
}
if (!$founderr) {
redirect2("admin.php");
}
}
else {
show_error(1);
}
?>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

相關關鍵詞：
mysql 5 5 php 5 5 mysql mysql 5 5 download mysql 5 5 syntax mysql 5 5 commands mysql 5 5 reference manual mysql community server 5 5
相關文章
MySql 執行計畫
MySQL 8.0 中統計資訊長條圖的嘗試
python爬蟲學習(2)__抓取糗百段子，與存入mysql資料庫
mysql匯入匯出資料中文亂碼解決方案小結

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

熱門內容

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More