聊天室php&mysql(一)
更新時(shí)間:2006年10月09日 00:00:00 作者:
//第一個(gè)頁(yè)面 name="index1.php"
<?
include "../signup/mysql.php";
$time1=time();
//$userid=983530409;
echo $n;
if($n==1){
$userid=time();
$nick="g".$userid;
$last_time=$userid;
$sql="insert into chat_user (userid,id,last_time) values ('$userid','$nick','$last_time')";
mysql_query($sql)or die(mysql_error());
$sql="insert into chat_user_list (userid,id,last_time) values ('$userid','$nick','$last_time')";
mysql_query($sql)or die(mysql_error());
echo"<FONT SIZE=6 COLOR=#FF0066><B>LOADING ........</B></FONT>";
echo "<script language='JavaScript'> window.open('index1.php?userid=".$userid."','chat','toolbar=no,directories=no,menubar=no,width=800,height=570,left=0,top=0,status=0');";
echo" window.close() </script>";
}
if($n==983530409)
{
$sql="select userid,sex,passwd from user where id='$n'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$nick=$row["userid"];
$passwd=$row["passwd"];
$sex=$row["sex"];
$sql="insert into chat_user (userid,passwd,sex,last_time,id)values('$n','$passwd','$sex','$time1','$nick')";
mysql_query($sql)or die(mysql_error());
echo"<FONT SIZE=6 COLOR=#FF0066><B>LOADING ........</B></FONT>";
echo "<script language='JavaScript'> window.open('index1.php?userid=".$n."','chat','toolbar=no,directories=no,menubar=no,width=800,height=570,left=0,top=0,status=0');";
echo" window.close(); </script>";
}
?>
<html>
<head>
<title>::: FEIT聊天室 :::</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<frameset cols="*,132" frameborder="NO" border="0" framespacing="0" rows="*">
<frameset rows="*,111" frameborder="NO" border="0" framespacing="0" cols="*">
<frame name="top" src="index.php?userid=<? echo $userid?>" scrolling="AUTO">
<frame name="bottom" scrolling="NO" noresize src="frame3.php?userid=<? echo $userid ?>">
</frameset>
<frameset rows="*,110" frameborder="NO" border="0" framespacing="0">
<frame name="right" scrolling="AUTO" noresize src="frame2.php?userid=<? echo $userid?>">
<frame name="bottomFrame" scrolling="NO" noresize src="frame4.php">
</frameset>
</frameset>
<noframes>
<body bgcolor="#FFFFFF" text="#000000">
<p>很抱歉!這是一個(gè)分幀頁(yè)面,但由于你的瀏覽器不支持,所以不能瀏覽! </p>
<p>Sorry!This page uses frames,but your browser doesn't support them .</p>
</body>
</noframes>
</html>
<?
include "../signup/mysql.php";
$time1=time();
//$userid=983530409;
echo $n;
if($n==1){
$userid=time();
$nick="g".$userid;
$last_time=$userid;
$sql="insert into chat_user (userid,id,last_time) values ('$userid','$nick','$last_time')";
mysql_query($sql)or die(mysql_error());
$sql="insert into chat_user_list (userid,id,last_time) values ('$userid','$nick','$last_time')";
mysql_query($sql)or die(mysql_error());
echo"<FONT SIZE=6 COLOR=#FF0066><B>LOADING ........</B></FONT>";
echo "<script language='JavaScript'> window.open('index1.php?userid=".$userid."','chat','toolbar=no,directories=no,menubar=no,width=800,height=570,left=0,top=0,status=0');";
echo" window.close() </script>";
}
if($n==983530409)
{
$sql="select userid,sex,passwd from user where id='$n'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$nick=$row["userid"];
$passwd=$row["passwd"];
$sex=$row["sex"];
$sql="insert into chat_user (userid,passwd,sex,last_time,id)values('$n','$passwd','$sex','$time1','$nick')";
mysql_query($sql)or die(mysql_error());
echo"<FONT SIZE=6 COLOR=#FF0066><B>LOADING ........</B></FONT>";
echo "<script language='JavaScript'> window.open('index1.php?userid=".$n."','chat','toolbar=no,directories=no,menubar=no,width=800,height=570,left=0,top=0,status=0');";
echo" window.close(); </script>";
}
?>
<html>
<head>
<title>::: FEIT聊天室 :::</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<frameset cols="*,132" frameborder="NO" border="0" framespacing="0" rows="*">
<frameset rows="*,111" frameborder="NO" border="0" framespacing="0" cols="*">
<frame name="top" src="index.php?userid=<? echo $userid?>" scrolling="AUTO">
<frame name="bottom" scrolling="NO" noresize src="frame3.php?userid=<? echo $userid ?>">
</frameset>
<frameset rows="*,110" frameborder="NO" border="0" framespacing="0">
<frame name="right" scrolling="AUTO" noresize src="frame2.php?userid=<? echo $userid?>">
<frame name="bottomFrame" scrolling="NO" noresize src="frame4.php">
</frameset>
</frameset>
<noframes>
<body bgcolor="#FFFFFF" text="#000000">
<p>很抱歉!這是一個(gè)分幀頁(yè)面,但由于你的瀏覽器不支持,所以不能瀏覽! </p>
<p>Sorry!This page uses frames,but your browser doesn't support them .</p>
</body>
</noframes>
</html>
相關(guān)文章
php學(xué)習(xí)筆記之 函數(shù)聲明(二)
PHP可以在函數(shù)內(nèi)部再聲明函數(shù) 目的就是在函數(shù)內(nèi)部調(diào)用 用來(lái)幫助外部函數(shù)完成一些子功能2011-06-06php 中的str_replace 函數(shù)總結(jié)
php 中的str_replace 函數(shù)總結(jié),方便大家實(shí)現(xiàn)字符串的替換。2007-04-04整合了前面的PHP數(shù)據(jù)庫(kù)連接類(lèi)~~做成一個(gè)分頁(yè)類(lèi)!
整合了前面的PHP數(shù)據(jù)庫(kù)連接類(lèi)~~做成一個(gè)分頁(yè)類(lèi)!...2006-11-11php動(dòng)態(tài)實(shí)現(xiàn)表格跨行跨列實(shí)現(xiàn)代碼
由于按照條件提取多臺(tái)服務(wù)器生成的報(bào)表數(shù)據(jù)的需要,我們很可能用到php動(dòng)態(tài)生成可以跨行跨列的表格,table跨行跨列雜糅在一起經(jīng)常出現(xiàn)不好控制,而且行列合并屬性的邏輯耦合度很高,所以對(duì)于這次的需要就有了如下東西2012-11-11