mysql 测试用户_mysql – 用户共同朋友测试的朋友与另一个用户

因为在MySQL中查询会如此复杂和缓慢,我不会自己使用它,这里是PHP的解决方案,只有一个查询：

// $db = mysqli_connect(...);

function findMutualFriends($of,$mutual_with){

global $db;

$user_friends = array();

$mutual_friends = array();

$results = array();

$res = mysqli_query($db,"SELECT user_1,user_2,status FROM Friends WHERE ((user_2 = '$of' OR user_1 = '$of') OR (user_2 = '$mutual_with' OR user_1 = '$mutual_with')) AND status >= 0;";

while($row = mysqli_fetch_assoc($res)){

if($row['user_1'] == $of || $row['user_2'] == $of){

$user_friends[] = (($row['user_1'] == $of) ? $row['user_2'] : $row['user_1']);

}

if($row['user_1'] == $mutual_with || $row['user_2'] == $mutual_with){

$mutual_friends[(($row['user_1'] == $mutual_with) ? $row['user_2'] : $row['user_1'])] = 1;

}

}

foreach($user_friends as $friend){

if($mutual_firends[$friend]){

$results[] = $friend;

}

}

return $results;

}

?>

请注意,它尚未经过测试.可能包含一些小的语法错误,但应该返回一个共同的朋友数组.