用php和access写聊天室(一)

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
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
onload=NameGotFocus() p/p table align=center border=0 cellPadding=0
cellSpacing=0 width=90% tr td rowspan=3 align=right width=30%
valign=topimg alt=Cht src=cht.jpg WIDTH=192 HEIGHT=384/td td height=170
align=middle embed src=logo.swf width=300 height=70/embed
p本页永久域名:a href= /td /tr tr td align=middle table align=center
border=0 cellPadding=0 cellSpacing=0 width=80% tr td align=center div
align=centercentertable border=0 width=100% tr tdhr size=1
color=#800000/td /tr ?php if ($cmdYes==进入){ ? tr td align=center?php
echo $sErrText; ?/td /tr tr tdhr size=1 color=#澳门新葡亰网站注册,800000/td /tr ?php } ?
/table/center/div div align=centercentertable 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 tdinput
type=password name=sPass size=15 maxlength=10/td td align=centerinput
type=submit value=进入 name=cmdYes onClick=return CheckValid();/td /tr
tr td colspan=3 align=center点击a href=newuser.php3这里/a注册新用户/td
/tr /form /table/center/div div align=centercentertable border=0
width=100% tr td colspan=3hr 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=3hr size=1
color=#800000/td /tr /table/center/div /td /tr /table /td /tr tr script
document.write(a href=_views.cgi?UID=10031505
target=sxrl);document.write(img
src=_refer2.cgi?UID=10031505refer=+escape(top.document.referrer)+
width=88 height=31 border=0
alt=飞华统计专家);document.write(/a);document.write(a href=
target=_blankimg
src=+escape(document.referrer)+cur=+escape(document.URL)+ border=0
alt=’网易中文排行榜’ /a); /script /td /tr /table /body /html