基于mysql的论坛(1)

  ###############################################

  此篇文章属原创,如有引用,请标明作者信息。

  作者:冷情疯子

  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);

  }

  ?>