用PHP和ACCESS写聊天室(九)
author：一佰互联 2019-05-01 click：170
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="进入"></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> </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"); ?> 【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】
