文章詳情頁
用PHP和ACCESS寫聊天室(九)
瀏覽：3日期：2024-01-02 10:53:18
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> </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="進(jìn)入"></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>加入房間出錯(cuò)</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link rel="stylesheet" href="main.css" type="text/css"> </head> <body> <p> </p> <p align="center">這個(gè)房間已經(jīng)被拆了！</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='http://m.cgvv.com.cn/bcjs/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='http://m.cgvv.com.cn/bcjs/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='http://m.cgvv.com.cn/bcjs/main.css' type='text/css'></head><body></body></html>"include("room.php3"); ?> 【本文版權(quán)歸作者與奧索網(wǎng)共同擁有，如需轉(zhuǎn)載，請(qǐng)注明作者及出處】;;;;
標(biāo)簽：
PHP
排行榜
網(wǎng)公網(wǎng)安備