该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
这是ajax/ajax_message_leave.php页面
include('ajaxyanzheng.php');
include('../little/func.php'); $id = $p->getid();//ajax运行时这个变量没有被覆盖,登陆其他人页面留言时需要处理
$datetime = date("Y-m-d G:i:s");
$visitid = @$_POST['mid'];
$visitedid = @$_POST['id'];
$message=@$_POST['message'];
$message=mb_convert_encoding($message, "gb2312", "utf-8");
$check=@$_POST['check'];
//if($check==1){
// $sql="insert into t_guestbook(sayid,listenid,note,hide,datetime,hostid)values($visitid,$visitedid,'$message',1,'$datetime',$visitedid)";
// // echo"
//}
//
//if($check==0){
// $sql="insert into t_guestbook(sayid,listenid,note,hide,datetime,hostid)values($visitid,$visitedid,'$message',0,'$datetime',$visitedid)";
//}
$sql="insert into t_guestbook(sayid,note,hide,datetime,hostid)values($visitid,'$message',$check,'$datetime',$visitedid)";
if(mysql_query($sql)){
// echo"
if($id==$visitedid){//这个if语句是判断上面注释的不能被覆盖的id是否访问的是本人的留言板
$sql = "select * from t_guestbook where hostid = $id order by datetime desc ";//相等就是登陆人访问自己的留言板
}else{
$sql = "select * from t_guestbook where hostid = $visitedid order by datetime desc ";//不相等就是访问别人的,显示留言的过滤条件就为where hostid = $visitedid
}
$mq = mysql_query($sql)or die(mysql_error());
if(mysql_num_rows($mq)==0){
echo"
return;
}
while($afc = mysql_fetch_array($mq)){
$pict = read_field('t_person','picturename',$afc['sayid']);
$namep = read_field('t_person','realname',$afc['sayid']);
$i = $afc['sayid'];
if($i==$id){
echo " ";
echo "".$namep.": ";
}else{
echo " ";
echo "".$namep.": ";
}
echo $afc['note']."     ";
echo $afc['datetime'];
echo"
";
echo"
";
}
}else{
echo mysql_error();
}