程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 網頁編程 >> PHP編程 >> PHP綜合 >> 基於mysql的論壇(1)

基於mysql的論壇(1)

編輯:PHP綜合
###############################################
此篇文章屬原創,如有引用,請標明作者信息。
作者:冷情瘋子
Email: [email protected]
http://safebase.yeah.net
###############################################
## adduser.php ################################
###############################################
<?php
require("func.php");
if(empty($name) or empty($pwd1)){
   show_error(2);
   $founderr=1;
}
if (is_user_exits($name)){
    show_error(3);
    $founderr=1;
    }
if ($pwd1<>$pwd2){
     show_error(5);
     $founderr=1;
     }
if (strlen($name)>16 or strlen($pwd1)>16 or strlen($qm)>255){
    show_error(6);
    $founderr=1;
}
$password=$pwd1;
if (!$founderr){
      adduser();
      echo "成功!";
}

?>
######################
### admin.php ########
######################
<?php
require "func.php";
if (adminok()) {
?>
<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">
請選擇版面進行操作<br>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="52%" valign="top">  
      <table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
        <tr align="center" bgcolor="#eeeeee">  
          <td width="42%" height="18">Chinesename</td>
          <td width="33%" height="18">Name</td>
        </tr>
<?php
$sql="select * from boardinfo";
$sql_result=mysql_query($sql);
while ($sql_row=mysql_fetch_array($sql_result)) {
?>
        <tr align="center">  
          <td width="42%"><a href="admin.php?board=<?php echo $sql_row[name];?>"><?php echo $sql_row[chinesename];?></a></td>
          <td width="33%"><?php echo $sql_row[name];?></td>
        </tr>
<?php
}
?>       
      </table>
      <br>
      <form name="form5" action="oper.php" >
        英文名稱:  
        <input type="text" name="name" size="20" maxlength="30">
        <br>
        中文名稱:
        <input type="text" name="chinesename" size="20" maxlength="30">
        <input type="hidden" name="add_board" value="y">
        <br>
        <input type="submit" name="add_board" value="增加版面">
      </form>
    </td>
    <td width="48%" valign="top">
<?php
if (isset($board)){
    $sql="select * from boardinfo where name='$board'";
    $sql_result=mysql_query($sql);
    $sql_row=mysql_fetch_array($sql_result);
    $name=$sql_row[name];
    $chinesename=$sql_row[chinesename];
?>       
      <table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#CCCCCC">
        <tr>
          <td>  
            <form name="form1" action="oper.php" >
              增加版主:  
              <input type="text" name="name" size="17" maxlength="16">
              <input type="submit" name="add_admin" value="增加">
              <input type="hidden" name="add_admin" value="y">
              <input type="hidden" name="board" value="<?php echo "$board"?>">
            </form>
          </td>
        </tr>
        <tr>
          <td>  
            <form name="form2" action="oper.php" >
              刪除版主:  
              <select name="name">
              <?php
              $sql="select name from user where slaveboard='$board'";
              $sql_result=mysql_query($sql);
              while ($sql_row=mysql_fetch_array($sql_result)) {
                   echo "<option value=\"$sql_row[name]\">$sql_row[name]</option>";
              }
              ?>
              </select>
              <input type="submit" name="delete_admin" value="刪除">
              <input type="hidden" name="delete_admin" value="y">
            </form>
          </td>
        </tr>
        <tr>
          <td>  
            <form name="form3" action="oper.php" >
              中文名稱  
              <input type="text" name="chinesename" size="17" maxlength="16" value="<?php echo "$chinesename"?>">
              <br>
              英文名稱
              <input type="text" name="name" size="16" maxlength="40" value="<?php echo "$name"?>">
              <input type="hidden" name="modify" value="y">
              <input type="submit" name="modify" value="更改">
            </form>
          </td>
        </tr>
        <tr>
          <td>
            <form name="form4" action="oper.php" >
              <input type="submit" name="del_board" value="刪除板塊">
              <input type="hidden" name="board" value="<?php echo "$board"?>">
              <input type="hidden" name="del_board" value="y">
            </form>
          </td>
        </tr>
        <tr>
          <td> </td>
        </tr>
        <tr>
          <td> </td>
        </tr>
      </table>
      <?php
      }
      ?>
    </td>
  </tr>
</table>
</body>
</html>
<?php
}
else {
    show_error(1);
}
?>
  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved