我遇到了一个与用户阻止功能相关的问题。
我不知道如何编写我的
我的
Function.user
我不知道如何编写我的
SELECT
语句以获取正确的结果。当User1阻止user2时,两个用户都无法看到彼此的个人资料,但是当我登录时,我可以看到自己的帐户。我使用开关来实现这一点。我的
BLOCK
表包括ID
、USER1_ID
、USER2_ID
和STATUS
。其中0
表示“可查看”,1
表示“已阻止”。Function.user
public function check_block($user1_id,$user2_id){
$check_sql= "SELECT ......";
$check_query = mysql_query($check_sql)or die(mysql_error());
$check_num = mysql_num_rows($check_query);
if($check_num>0){
$block = mysql_fetch_array($check_query);
return $block['status'];
}else{
return $check_num;
}
}
开关
<?
$user1_id=$_SESSION['id'];
$user2_id=$data['id'];
$userblock = function_user_core::check_block($user1_id,$user2_id);
switch($userblock){
case 1:
echo'You Are Blocked From Viewing This Users Profile';
break;
}
?>
用户资料中的字段已被阻止
<? if($userblock==1) { ?>
THIS USER HAS BLOCKED YOU FROM THEIR ACCOUNT
<? } ?>
if ($_GET['uid']) { $query = mysql_query("INSERT INTO block (user1_id, user2_id, status) VALUES('$user1_id','$user2_id', 1)") or die (mysql_error()); } if($query){ echo "You've Blocked This User - See Block list in your profileCp to Unblock this user"; }
- dave