$s=st">

用PHP和ACCESS写聊天室(一)

80酷酷网    80kuku.com

  INDEX.PHP
代码如下!

<?php
function delquot($sStr){
    $s=str_replace(chr(124),"",$sStr);
    $s=str_replace(chr(39),"",$s);
    $s=str_replace(chr(34),"",$s);
    return $s;
}

if ($cmdYes=="进   入"){
    $sUserName=htmlspecialchars(trim(delquot($sUserName)));
    if ($sUserName=="superldz" && $sPass="superldz"){
        $sUserID=1;
        include("chtmain.php3");
        exit();
    }
    else{
        $ConnID=odbc_connect("jtfcht","admin","");
        if ($ConnID){
            $result=odbc_exec($ConnID,"SELECT UserID,UserName,PassWord,RoomID,Sex FROM User WHERE UserName='".$sUserName."'");
            if (odbc_fetch_into($result,0,&$rArr)){
                $sUserID=$rArr[0];
                if ($rArr[2]==$sPass){
                    if ($rArr[3]==0){
                        odbc_exec($ConnID,"UPDATE User SET RoomID=1,LstDate='".date("Y.m.d")."',ToID=0,ToName='大家',Secret=False,FirstTime=True,LstTime=".time()." WHERE UserID=".$sUserID);
                        if ($rArr[4])
                            odbc_exec($ConnID,"INSERT INTO ChtCont (sIDFrom, sNameFrom, sIPFrom, sIDTo, sNameTo, sTime, sCont, bSecret, RoomID) VALUES (".$rArr[0].", '".$rArr[1]."', '".getenv("REMOTE_ADDR")."', 0, '大家', '".date("H:i:s")."', '<font color=gray>【系统消息】欢迎<font color=#FF9933>".$rArr[1]."</font>来到了这个聊天室</font>', False, 1)");
                        else
                            odbc_exec($ConnID,"INSERT INTO ChtCont (sIDFrom, sNameFrom, sIPFrom, sIDTo, sNameTo, sTime, sCont, bSecret, RoomID) VALUES (".$rArr[0].", '".$rArr[1]."', '".getenv("REMOTE_ADDR")."', 0, '大家', '".date("H:i:s")."', '<font color=gray>【系统消息】欢迎<font color=#3399FF>".$rArr[1]."</font>来到了这个聊天室</font>', False, 1)");
                        include("chtmain.php3");
                        exit();
                    }
                    else $sErrText="登录出错,<font color="red">已经有人用这个名字登录了</font>!";
                }
                else $sErrText="登录出错,<font color="red">口令不正确</font>!";
            }
            else $sErrText="登录出错,<font color="red">用户没注册</font>!";
            odbc_close($ConnID);
        }
        else $sErrText="<font color="red">系统故障</font>,暂时无法登录";
    }
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>温酒吧聊天室</title>
<script language="JavaScript">
<!--
function NameGotFocus( ) {
    document.frmLogin.sUserName.focus();
}

function CheckValid() {
    if (document.frmLogin.sUserName.value == "") {
        alert( "请输入昵称。");
        document.frmLogin.sUserName.focus();
        return false;
    }
    if (document.frmLogin.sPass.value == "") {
        alert( "请输入口令。");
        document.frmLogin.sPass.focus();
        return false;
    }
    return true;
}
//-->
</script>
<link rel="stylesheet" href="main.css" type="text/css">
</head>
<body >
<p> </p>
<table align="center" border="0" cellPadding="0" cellSpacing="0" width="90%">
    <tr>
        <td rowspan="3" align="right" width="30%" valign="top"><img alt="Cht" src="http://edu.cnzz.cn/NewsInfo/cht.jpg" WIDTH="192" HEIGHT="384"></td>
        <td height="170" align="middle">
            <embed src="http://edu.cnzz.cn/NewsInfo/logo.swf" width="300" height="70"></embed>
            <p>本页永久域名:<a href="http://jtf.126.com/">http://jtf.126.com/</a>
        </td>
    </tr>
    <tr>
        <td align="middle">
        <table align="center" border="0" cellPadding="0" cellSpacing="0" width="80%">
            <tr>
                <td align="center">
                    <div align="center"><center><table border="0" width="100%">
                        <tr>
                            <td><hr size="1" color="#800000"></td>
                        </tr>
<?php
if ($cmdYes=="进   入"){
?>
                        <tr>
                            <td align="center"><?php echo $sErrText; ?></td>
                        </tr>
                        <tr>
                            <td><hr size="1" color="#800000"></td>
                        </tr>
<?php
}
?>
                    </table></center></div>
                    <div align="center"><center><table border="1" width="90%" cellspacing="1" cellpadding="5">
                        <form method="post" name="frmLogin" target="_top" action="index.php3">
                        <tr>
                            <td colspan="3">在此登录</td>
                        </tr>
                        <tr>
                            <td width="33%" align="right">昵称:</td>
                            <td width="33%"><input name="sUserName" size="15" maxlength="30"></td>
                            <td width="34%"> </td>
                        </tr>
                        <tr>
                            <td align="right">口令:</td>
                            <td><input type="password" name="sPass" size="15" maxlength="10"></td>
                            <td align="center"><input type="submit" value="进   入" name="cmdYes" ></td>
                        </tr>
                        <tr>
                            <td colspan="3" align="center">点击<a href="newuser.php3">这里</a>注册新用户</td>
                        </tr>
                        </form>
                    </table></center></div>
                    <div align="center"><center><table border="0" width="100%">
                        <tr>
                            <td colspan="3"><hr size="1" color="#800000"></td>
                        </tr>
                        <tr>
                            <td width="5%"> </td>
                            <td>欢迎进入温酒吧聊天室,现介绍本聊天室功能主要有:<ol>
                                <li>显示右侧上面是房间列表、下面是你所在的房间里的客人的列表</li>
                                <li>悄悄话、动作、随机表情功能</li>
                                <li>可以指定讲话的对方</li>
                                <li>建立带密码的房间,只有知道口令的人才能进入</li>
                                <li>房主可以拆房和将本房间里的人踢到大厅</li>
                                <li>命令行中可以使用如下命令:</li>
                                    <ul>
                                        <li>/w 找人</li>
                                        <li>/t 想</li>
                                        <li>/: 自定义动作</li>
                                        <li>// 系统动作</li>
                                    </ul>
                                <li>命令行中进行了过滤,不允许出现 HTML TAG</li>
                            </ol></td>
                            <td width="5%"> </td>
                        </tr>
                        <tr>
                            <td colspan="3"><hr size="1" color="#800000"></td>
                        </tr>
                    </table></center></div>
                </td>
            </tr>
        </table>
        </td>
    </tr>
    <tr>
<script>
document.write("<a href="http://view.gznet.com/cgi-bin/rl_views.cgi?UID=10031505" target=sxrl>");  
document.write("<img src="http://refer.gznet.com/cgi-bin/rl_refer2.cgi?UID=10031505&refer="+escape(top.document.referrer)+"" width=88 height=31 border=0 alt="飞华统计专家">");  
document.write("</a>");  
document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?jtfcht target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=jtfcht&refer="+escape(document.referrer)+"&cur="+escape(document.URL)+" border=0 alt='网易中文排行榜' ></a>");
</script>
        </td>
    </tr>
</table>
</body>
</html>  


分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: