Maison >développement back-end >tutoriel php >my life would suck without you 聊天室php&mysql三
第三个页面 name="frame3.php"
include "../signup/mysql.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_query($sql);
$roww=mysql_fetch_array($result);
$userrr=$roww["id"];
$sql="select userid,id from chat_user_list where";
$result=mysql_query($sql);
if($row1=mysql_fetch_array($result))
$object=$row1["userid"];
else {
$object="大家";
$k=1;}
$select="select row from user_message order by row DESC";
$result=mysql_query($select)or die(" false fgfg");
$rowlist=mysql_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_query($sql)or die(mysql_error());
if($k){$object="大家"; $private=0;}
else
$object=$row1["id"];
}
?>