Skip to content

Instantly share code, notes, and snippets.

Nicholas Bowers NicholasRBowers

Block or report user

Report or block NicholasRBowers

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View states and counties
$counties = array(
"Alabama" => array(
"Autauga County",
"Baldwin County",
"Barbour County",
"Bibb County",
"Blount County",
"Bullock County",
"Butler County",
"Calhoun County",
@NicholasRBowers
NicholasRBowers / fb-extract-comments.php
Created Nov 20, 2012 — forked from stephanschubert/fb-extract-comments.php
Extract comments from your page on Facebook
View fb-extract-comments.php
<?php
// Displays comments for a certain URL.
$url = 'http://developers.facebook.com/docs/reference/fql/comment/';
// FQL multi-query to fetch all the data we need to display comments.
$queries = array(
'q1' => 'SELECT post_fbid, fromid, object_id, text, time FROM comment WHERE object_id IN (SELECT comments_fbid FROM link_stat WHERE url ="'.$url.'")',
'q2' => 'SELECT post_fbid, fromid, object_id, text, time FROM comment WHERE object_id IN (SELECT post_fbid FROM #q1)',
'q3' => 'SELECT name, id, url, pic_square FROM profile WHERE id IN (SELECT fromid FROM #q1) or id in (SELECT fromid FROM #q2)',
You can’t perform that action at this time.