聊天室php&mysql(五)

  第五个页面name="changenick.php"

  <?

  include "../signup/mysql.php";

  //echo $userid;

  if($action=="ok")

  {

  $sql="select * from chat_user_list where userid='$nick'";

  $result=mysql_query($sql) or die(mysql_error());

  if(!$result) echo "该呢称已被他人占用 请重新填写";

  else

  {

  $sql="update chat_user_list set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";

  $result=mysql_query($sql)or die(mysql_error());

  $sql="update chat_user set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";

  $result=mysql_query($sql)or die(mysql_error());

  }

  if($result){

  echo "<script language='JavaScript'> window.close() </script>";

  }

  }

  ?>

  <html>

  <head>

  <title>:::FEIT聊天室:::</title>

  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">

  <script language="JavaScript">

  <!--

  function MM_reloadPage(init) {  //reloads the window if Nav4 resized

  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

  document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

  }

  MM_reloadPage(true);

  // -->

  </script>

  </head>

  <body bgcolor="#ffffff" text="#000000">

  <div id="Layer1" style="position:absolute; left:40px; top:28px; width:293px; height:202px; z-index:1; background-color: #6699FF; layer-background-color: #6699FF; border: 1px none #000000"></div>

  <div id="Layer2" style="position:absolute; left:144px; top:54px; width:126px; height:70px; z-index:2">

  <form name="form1" method="post" action="<?echo $PHP_SELF?>?action=ok">

  <p>

  <input type="text" name="nick" size="12" maxlength="20">

  </p>

  <p>

  <input type="text" name="passwd" size="12" maxlength="20">

  <input type="hidden" name="userid" value="<?echo $userid ;?>">

  </p>

  <p>

  <select name="sex">

  <option value="帅哥">帅哥</option>

  <option value="妹妹">美眉</option>

  </select>

  </p>

  <p>

  <input type="submit" name="ok" value="更改" align="center">

  </p>

  </form>

  </div>

  <div id="Layer3" style="position:absolute; left:72px; top:58px; width:72px; height:20px; z-index:3">用户呢称</div>

  <div id="Layer4" style="position:absolute; left:72px; top:99px; width:71px; height:23px; z-index:4">用户密码</div>

  <div id="Layer5" style="position:absolute; left:82px; top:139px; width:58px; height:20px; z-index:5">性别</div>

  </body>

  </html>