Facebook 查询语言仅提供用户 ID

Question

我正在尝试打印使用我的应用程序的用户的朋友。使用 Facebook 查询语言（FLQ）来做到这一点。但查询只给出用户 ID。我如何获取带有个人资料图片的用户名

这是我的代码：

require 'facebook.php';

$facebook = new Facebook(array(
'appId'  => 'xxxxxxxxxxx',
'secret' => 'xxxxxxxxxxxxxx',
'cookie' => true, // enable optional cookie support
));

$session = $facebook->getSession();
if ($session) {
try {
$some_friends = $facebook->api(array(
      'method' => 'fql.query',
      'query' => 'SELECT uid2 FROM friend WHERE uid1='.$facebook->getUser().' LIMIT 10'
    ));
} catch (FacebookApiException $e) {
error_log($e);
}
}
print_r($some_friends);

这是结果：

Array ( 
    [0] => Array ( [uid2] => 521117187 ) 
    [1] => Array ( [uid2] => 526583873 ) 
    [2] => Array ( [uid2] => 527579769 ) 
    [3] => Array ( [uid2] => 531219912 ) 
    [4] => Array ( [uid2] => 533654770 ) 
    [5] => Array ( [uid2] => 539141589 ) 
    [6] => Array ( [uid2] => 539243220 ) 
    [7] => Array ( [uid2] => 539342366 ) 
    [8] => Array ( [uid2] => 549294033 ) 
    [9] => Array ( [uid2] => 557508969 )
     )

---

已解决...

Answer 1

您可以通过将 uid 发布到

http://graph.facebook.com/UID/picture

例子
http://graph.facebook.com/557508969/picture

也是他的名字
http://graph.facebook.com/557508969/（JSON 编码）

Answer 2

我认为如果我理解你的问题，你必须将你的选择查询更改为

SELECT id,username,profile_pic FROM friend WHERE uid1='.$facebook->getUser().' LIMIT 10'

。

Answer 3

您需要使用 FQL 子查询，因为朋友表不包含有关用户的更多信息。试试这个：

require 'facebook.php';

$facebook = new Facebook(array(
'appId'  => 'xxxxxxxxxxx',
'secret' => 'xxxxxxxxxxxxxx',
'cookie' => true, // enable optional cookie support
));

$session = $facebook->getSession();
if ($session) {
try {
$some_friends = $facebook->api(array(
      'method' => 'fql.query',
      'query' => 'SELECT uid,name,picture FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1='.$facebook->getUser().') LIMIT 10'
    ));
} catch (FacebookApiException $e) {
error_log($e);
}
}
print_r($some_friends);