Facebook：了解用户何时喜欢网址 [英] Facebook: Find out when user liked an URL

问题描述

我可以从 url_like 中获取 user_id - url / em>表。

如上所述，只有两列是 user_id，url 。

我尝试通过多种方式获得喜欢URL的日期，通过连接多个表，但没有运气。

许多示例中的一个可能是< p

 
 SELECT url，id，type，site FROM object_url WHERE url IN（
 SELECT url FROM url_like WHERE user_id = {$ target} 
）LIMIT 1000，
 

有没有办法获取用户喜欢特定网址时的日期/时间戳？ >

据说我甚至尝试不可能...

解决方案

我发现这个解决方案解决我的问题

我依靠FQL

  public static $ since ='2012/01/01'; 
 ... 
 ... 
 
 // $ target1代表我，它的值为我的FB ID 
 //所以我正在选择我喜欢的所有链接st year 
 $ object_id_raw = static :: $ facebook-> api（array（
'method'=> 'fql.query'，
'query'=> SELECT link_id FROM link WHERE owner = {$ target1} AND created_time>.strtotime（static :: $ since）
））; 
 //只是提取ID以备以后使用
 $ object_id = array（）; 
 foreach（$ object_id_raw as $ oid）：
 array_push（$ object_id，$ oid ['link_id']）; 
 endforeach; 
 
 //  -  friendId代表我朋友的FB ID 
 //这个查询是从我喜欢的链接中选择的，这意味着我们有他们喜欢的... 
 //此API调用返回对象ID（链接的ID）。做任何你想要的... 
 $ result = static :: $ facebook-> api（array（
'method'=>'fql.query'，
'query '=>SELECT object_id FROM like WHERE object_id IN（'.implode（'，'，$ object_id）。'）AND user_id = {$ friendId}
））; 
  

I can get pair of user_id - url from url_like table.
The only two columns are, as mentioned, user_id, url.

I tried to get get date of 'liking' the URL by many ways, by connecting multiple tables, but no luck.
One of many examples might be

SELECT url, id, type, site FROM object_url WHERE url IN (
    SELECT url FROM url_like WHERE user_id = {$target}
) LIMIT 1000",

Is there any way how to get date/timestamp of when user liked particular URL?

As said I even tried impossible...

解决方案

I found this solution that solves my problem

I rely on FQL

public static $since = '2012/01/01';
...
...

// $target1 stands for "me", it has value of my FB ID
// So I am selecting all links I liked in past year
$object_id_raw = static::$facebook->api(array(
    'method'    => 'fql.query',
    'query' => "SELECT link_id FROM link WHERE owner = {$target1} AND created_time > ".strtotime(static::$since)
));
// Just extracting IDs for later usage
$object_id = array();
foreach($object_id_raw as $oid):
    array_push($object_id, $oid['link_id']);
endforeach;

// - friendId stands for FB ID of my friends
// This query is selecting from links I liked,that means we have them liked both...
// This API call returns object ID's (ID's of links). Do whatever you want with them...
$result = static::$facebook->api(array(
    'method'    => 'fql.query',
    'query' => "SELECT object_id FROM like WHERE object_id IN ('".implode("','", $object_id)."') AND user_id = {$friendId}"
));

这篇关于Facebook：了解用户何时喜欢网址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！