PHP – Facebook – 使用FQL 取得分享、點讚的次數

2013-01-29 / JSN / 3 Comments / 296 次瀏覽

$fb_appid = "你的APPID";
$fb_secret    = "你的APP密碼";

$config['appId']    = $fb_appid;
$config['secret']    = $fb_secret;
$Facebook = new Facebook($config);






$fql = "SELECT     click_count, 
comment_count,
comments_fbid,
commentsbox_count,
like_count,
normalized_url,
share_count,
total_count, 
url 
FROM link_stat 
WHERE url = 'http://www.wondershow.tw/post_01.php?i=3240' "; //你要查詢的網址


$Fary['method']    = 'fql.query';
$Fary['query'] = $fql;
$LinkInfo = $Facebook->api($Fary);     

//print_r($LinkInfo); 
/*
 * 用Google Chrome 按 F12 查看原始碼，結果應該會是這樣：
    Array
    (
[0] => Array
(
[click_count] => 0
[comment_count] => 13
[comments_fbid] => 147508702070374
[commentsbox_count] => 0
[like_count] => 28
[normalized_url] => http://www.wondershow.tw/post_01.php?i=3240
[share_count] => 2
[total_count] => 43
[url] => http://www.wondershow.tw/post_01.php?i=3240
)
    )
*/


//由FQL的api取得應該會是陣列型態，並沒有經過JSON編碼，所以若我要取得欄位total_count的值:
echo $LinkInfo[0]['total_count']; //會得到 43

 
// 一般我們看到的分享數字或是點讚的數字，其實是total_count 喔！
//至於實際的點讚數是 like_count; 分享數是 share_count~ 可以自己比對看看
 


 

/*以下是關於FQL取得的欄位說明取自於官網 https://developers.facebook.com/docs/reference/fql/link_stat*/

Name	說明
click_count number	The number of times Facebook users have clicked a link to the page from a share or like
comment_count number	The number of comments users have made on the shared story
comments_fbid number	The object_id associated with comments plugin comments for this URL. This can be used to query for comments using the comment FQL table
commentsbox_count number	The number of comments from a comments plugin on this URL. This only includestop level comments, not replies
like_count number	The number of times Facebook users have "Liked" the page, or liked any comments or re-shares of this page
normalized_url string	The normalized URL for the page being shared
share_count number	The number of times users have shared the page on Facebook
total_count number	The total number of times the URL has been shared, liked, or commented on
url  string	URL of the web page users can share