聊天室php&mysql(三)
2008-02-15 17:57:55 来源:WEB开发网 闂傚倸鍊搁崐鎼佸磹閹间礁纾归柟闂寸绾惧綊鏌熼梻瀵割槮缁炬儳缍婇弻鐔兼⒒鐎靛壊妲紒鐐劤缂嶅﹪寮婚悢鍏尖拻閻庨潧澹婂Σ顔剧磼閻愵剙鍔ょ紓宥咃躬瀵鎮㈤崗灏栨嫽闁诲酣娼ф竟濠偽i鍓х<闁诡垎鍐f寖闂佺娅曢幑鍥灳閺冨牆绀冩い蹇庣娴滈箖鏌ㄥ┑鍡欏嚬缂併劎绮妵鍕箳鐎n亞浠鹃梺闈涙搐鐎氫即鐛崶顒夋晬婵絾瀵ч幑鍥蓟閻斿摜鐟归柛顭戝枛椤牆顪冮妶搴′簼缂侇喗鎸搁悾鐑藉础閻愬秵妫冮崺鈧い鎺戝瀹撲礁鈹戦悩鎻掝伀缁惧彞绮欓弻娑氫沪閹规劕顥濋梺閫炲苯澧伴柟铏崌閿濈偛鈹戠€n€晠鏌嶆潪鎷屽厡闁汇倕鎳愮槐鎾存媴閸撴彃鍓卞銈嗗灦閻熲晛鐣烽妷褉鍋撻敐搴℃灍闁绘挻娲橀妵鍕箛闂堟稐绨肩紓浣藉煐濮樸劎妲愰幘璇茬闁冲搫鍊婚ˇ鏉库攽椤旂》宸ユい顓炲槻閻g兘骞掗幋鏃€鐎婚梺瑙勬儗閸樺€熲叺婵犵數濮烽弫鍛婃叏椤撱垹纾婚柟鍓х帛閳锋垶銇勯幒鍡椾壕缂備礁顦遍弫濠氱嵁閸℃稒鍊烽柛婵嗗椤旀劕鈹戦悜鍥╃У闁告挻鐟︽穱濠囨嚃閳哄啰锛滈梺褰掑亰閸欏骸鈻撳⿰鍫熺厸閻忕偟纭堕崑鎾诲箛娴e憡鍊梺纭呭亹鐞涖儵鍩€椤掑啫鐨洪柡浣圭墪閳规垿鎮欓弶鎴犱桓闂佸湱枪閹芥粎鍒掗弮鍫熷仺缂佸顕抽敃鍌涚厱闁哄洢鍔岄悘鐘绘煕閹般劌浜惧┑锛勫亼閸婃牠宕濋敃鈧…鍧楀焵椤掍胶绠剧€光偓婵犱線鍋楀┑顔硷龚濞咃絿妲愰幒鎳崇喓鎷犻懠鑸垫毐闂傚倷鑳舵灙婵炲鍏樺顐ゆ嫚瀹割喖娈ㄦ繝鐢靛У绾板秹寮查幓鎺濈唵閻犺櫣灏ㄥ銉р偓瑙勬尭濡繂顫忛搹鍦<婵☆垰鎼~宥囩磽娴i鍔嶉柟绋垮暱閻g兘骞嬮敃鈧粻濠氭偣閸パ冪骇鐎规挸绉撮—鍐Χ閸℃ê闉嶇紓浣割儐閸ㄥ墎绮嬪澶嬪€锋い鎺嶇瀵灝鈹戦埥鍡楃仯闁告鍕洸濡わ絽鍟崐鍨叏濡厧浜鹃悗姘炬嫹

核心提示:第三个页面 name="frame3.php" <? include "../signup/MySQL(和PHP搭配之最佳组合).php"; //echo $userid; //echo $private; if($p)$p=1; else
第三个页面 name="frame3.php"
<?
include "../signup/MySQL(和PHP搭配之最佳组合).php";
//echo $userid;
//echo $private;
if($p)$p=1;
else $p=0;
if(($action="ok")and($p)){
$sql="select userid,id from chat_user_list where userid='$userid'";
$result=MySQL(和PHP搭配之最佳组合)_query($sql);
$roww=MySQL(和PHP搭配之最佳组合)_fetch_array($result);
$userrr=$roww["id"];
$sql="select userid,id from chat_user_list where id='$object'";
$result=MySQL(和PHP搭配之最佳组合)_query($sql);
if($row1=MySQL(和PHP搭配之最佳组合)_fetch_array($result))
$object=$row1["userid"];
else {
$object="大家";
$k=1;}
$select="select row from user_message order by row DESC";
$result=MySQL(和PHP搭配之最佳组合)_query($select)or die(" false fgfg");
$rowlist=MySQL(和PHP搭配之最佳组合)_fetch_array($result)or die("false fgs");
$max_row=$rowlist["row"];
$row=$max_row+1;
$time1=date("G:i");
$sql="INSERT INTO user_message (userid,object,message,status,action1,color,row,time1) values('$userid','$object','$message','$private','$action1','$color','$row','$time1')";
MySQL(和PHP搭配之最佳组合)_query($sql)or die(MySQL(和PHP搭配之最佳组合)_error());
if($k){$object="大家"; $private=0;}
else
$object=$row1["id"];
}
?>
<html>
<head>
<title>input table</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT LANGUAGE="JavaScript">
<!--
function user(user){
document.form1.object.value=user;
}
function changnick(){
window.open("changnick.php?userid=<?echo $userid ;?>","changnick","toolbar=no,directories=no,menubar=no,width=800,height=570,width=340,height=220,status=0");
}
//-->
</SCRIPT>
</head>
<body bgcolor="#6699FF" text="#000000">
<div id="Layer1" style="position:absolute; left:125px; top:4px; width:498px; height:79px; z-index:1">
<form name="form1" method="post" align="center" action="<? echo $PHP_SELF; ?>?action=ok">
<p> <font color="#6699ff">.</font>
<input type="text" name="object" size="10" value="<?echo $object?>">
<input type="hidden" name="userid" value="<?echo $userid ?>">
说
<input type="hidden" name="p" value="1">
<input type="text" name="message" size="30">
<input type="submit" name="ok" value="发送">
</p>
<p> <font color="#6699FF">.</font>
<select name="action1">
<option selected value="说">说话</option>
<option value="悄悄地">悄悄</option>
<option value="兴高采烈地">高兴 </option>
更多精彩
赞助商链接