广

PHP编程

  • IOS开发
  • android开发
  • PHP编程
  • JavaScript
  • ASP.NET
  • ASP编程
  • JSP编程
  • Java编程
  • 易语言
  • Ruby编程
  • Perl编程
  • AJAX
  • 正则表达式
  • C语言
  • 编程开发

    用PHP和ACCESS写聊天室(九)

    2018-09-29 11:21:43 次阅读 稿源:互联网
    零七广告
    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");
    ?>



    【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】    

    零七网部分新闻及文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与零七网进行文章共享合作。

    零七广告
    零七广告
    零七广告
    零七广告