<form id="hz9zz"></form>
  • <form id="hz9zz"></form>

      <nobr id="hz9zz"></nobr>

      <form id="hz9zz"></form>

    1. 明輝手游網中心:是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺!

      用PHP與ACCESS寫聊天室(9)

      [摘要]enterrm.php3 代碼如下: <?php ConnID=@odbc_connect("jtfcht","admin",""); if (ConnID) resu...
      enterrm.php3
      代碼如下:
      <?php
              $ConnID=@odbc_connect("jtfcht","admin","");
              if ($ConnID){
                      $result=@odbc_exec($ConnID,"SELECT PassWord,LstTime,RoomID,RefRate FROM User WHERE UserID=".$id);
                      if (@odbc_fetch_into($result,0,&$rArr)){
                              $sRoomID=$rArr[2];
                              $sRefRate=(int)$rArr[3];
                              if ($sRefRate<2) $sRefRate=2;
                              if (($rArr[0]==$ps) && ($rArr[1]>=(time()-1800))){
                                      $sNewRoomID=substr($selRoom,2);
                                      if ($sNewRoomID!=$sRoomID){
                                              $result=@odbc_exec($ConnID,"SELECT Password FROM Room WHERE RoomID=".$sNewRoomID);
                                              if (@odbc_fetch_into($result,0,&$rArr)){
                                                      if ((strlen(trim($rArr[0]))==0) ($rArr[0]==$sPass)){
                                                              @odbc_exec($ConnID,"UPDATE User SET RoomID=".$sNewRoomID.",ToID=0,ToName='大家' WHERE UserID=".$id);
                                                              if ((int)$sRoomID!=1){
                                                                      $result=@odbc_exec($ConnID,"SELECT COUNT(UserID) FROM User WHERE RoomID=".$sRoomID);
                                                                      @odbc_fetch_into($result,0,&$rArr);
                                                                      if ($rArr[0]==0) @odbc_exec($ConnID,"DELETE * FROM Room Where RoomID=".$sRoomID);
                                                              }
                                                      }
                                                      else{
      ?>
      <html>
      <head>
      <title>輸入房間口令</title>
      <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
      <link rel="stylesheet" href="main.css" type="text/css">
      <script language="JavaScript">
      <!--

      function PassSetFocus( ) {
              document.frmEnterSm.sPass.focus();
      }

      //-->
      </script>
      <link rel="stylesheet" href="main.css" type="text/css">
      </head>
      <body onload="PassSetFocus();">
      <p>&nbsp;</p>
      <p align="center"><font color="#996666">輸入房間口令</font></p>
      <form name="frmEnterSm" action="enterrm.php3" method="post">
      <table width="100%" border="0" align="center">
              <tr>
                      <td colspan="2"><input type="hidden" name="selRoom" value="<?php echo $selRoom; ?>"><input type="hidden" name="id" value="<?php echo $id; ?>"><input type="hidden" name="ps" value="<?php echo $ps; ?>"></td>
              </tr>
              <tr>
                      <td width="40%" align="right">口令:</td>
                      <td width="60%"><input type="password" name="sPass" maxlength="10" size="8"></td>
              </tr>
              <tr>
                      <td colspan="2" align="center"><input type="submit" name="cmdYes" value="進入"></td>
              </tr>
      </table>
      </form>
      <p align="center">按<a href="room.php3?id=<?php echo $id; ?>&ps=<?php echo $ps; ?>&at=<?php echo time(); ?>">這里</a>放棄</p>
      </body>
      </html>
      <?php
                                                              exit();
                                                      }
                                              }
                                              else{
      ?>
      <html>
      <head>
      <title>加入房間出錯</title>
      <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
      <link rel="stylesheet" href="main.css" type="text/css">
      </head>
      <body>
      <p>&nbsp;</p>
      <p align="center">這個房間已經被拆了!</p>
      <p align="center">按<a href="room.php3?id=<?php echo $id; ?>&ps=<?php echo $ps; ?>&at=<?php echo time(); ?>">這里</a>返回</p>
      </body>
      </html>
      <?php
                                                      exit();
                                              }
                                      }
                              }
                              else echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>房間</title><link rel='stylesheet' href='main.css' type='text/css'></head><body></body></html>";
                      }
                      else echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>房間</title><link rel='stylesheet' href='main.css' type='text/css'></head><body></body></html>";
                      @odbc_close($ConnID);
              }
              else echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>房間</title><link rel='stylesheet' href='main.css' type='text/css'></head><body></body></html>";
              include("room.php3");
      ?>



      【本文版權歸作者與奧索網共同擁有,如需轉載,請注明作者及出處】    



      日韩精品一区二区三区高清