聊天室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>