导出 Facebook“我喜欢”对数据库进行投票
我正在尝试构建一个应用程序,让用户对我网站中的图片进行投票。用户可以通过点击“我喜欢”按钮进行投票。 我必须为每张图片登记投票并将该值存储在数据库中。我需要这些信息,以便在我的网站上按投票降序显示这些图片(我将从数据库中获取投票)。
我不知道如何将这些数据导出到数据库。 该应用程序将用 ASP classic 编写。
我在这里读过 Facebook Like 按钮和 MySQL 数据库 执行 FQL
SELECT like_count FROM link_stat WHERE url="url is here"
还有建议阅读此处:http://developers.facebook。 com/docs/reference/fql/link_stat
它说要运行此查询
$facebook->api_client->fql_query('SELECT share_count, like_count, comment_count, total_count FROM link_stat WHERE url="YOUR_SHARE_URL"');
我的问题是我在 ASP Classic 中工作,但我不知道如何运行该查询。
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 export 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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
检查一下,似乎您可以简单地转义查询语句并将其添加到 url 中。
http://developers.facebook.com/docs/reference/fql/links/
例如。
https://api.facebook.com/method/fql.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|HvV大众furhpbzG-j5cS5LHGlkFew
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