开发者

Export Facebook "I like" votes to a database

开发者 https://www.devze.com 2023-03-07 22:23 出处:网络
I\'m trying to build an application to let users vote pictures in my site. Users can vote by clicking the \"I like\" button.

I'm trying to build an application to let users vote pictures in my site. Users can vote by clicking the "I like" button. I have to register votes for each picture and store that values in a database. I need this information in order to show those pictures in my web site ordered by votes descending (and I'll pick up the votes from the db).

I don't know how to e开发者_如何学运维xport those data to the db. The application will be written in ASP classic.

I've read here Facebook Like button and MySQL database to perform FQL

SELECT like_count FROM link_stat WHERE url="url is here"

There was also the suggestion to read here: http://developers.facebook.com/docs/reference/fql/link_stat

It says to run this query

$facebook->api_client->fql_query('SELECT share_count, like_count, comment_count, total_count FROM link_stat WHERE url="YOUR_SHARE_URL"');

My problem is that I work in ASP Classic and I don't know how to run that query.


Check this out, it seems like you can simply escape you query statement and add it to the url.

http://developers.facebook.com/docs/reference/fql/links/

eg.

https://api.facebook.com/method/fql.query?query=SELECT+share_count%2C+like_count%2C+comment_count%2C+total_count+FROM+link_stat+WHERE+url%3D%22google.com%22&access_token=2227470867|2.AQCjzTJiS0GEC4Mm.3600.1314694800.0-100001742787554|HvVVWfurhpbzG-j5cS5LHGlkFew

0

精彩评论

暂无评论...
验证码 换一张
取 消