How to query facebook graph and parse returned json in codeigniter

Question

I am trying to pull my friends list using the following url

$url = "https://graph.facebook.com/".$facebookid."/fql?
        q=SELECT uid,name FROM user WHERE uid IN(SELECT uid2 FROM friend WHERE uid1 = me()) ORDER BY name
        &access_token=".$accesstoken."
        &limit=10000&offset=0";
        //echo $url."<br/>";
$list = json_decode(file_get_contents($url));

When i try to print the array, it always return empty.. If the same url is tested all my friends list is listed in a json

How to parse this... I am using codeigniter

Hashem Qolami · Accepted Answer · 2014-02-25 11:07:17Z

1

You'd probably have to encode the query by urlencode() as follows:

$query = "SELECT uid, name FROM user WHERE uid IN(SELECT uid2 FROM friend WHERE uid1 = me()) ORDER BY name";

$url = "https://graph.facebook.com/$facebookid/fql?q=" . urlencode($query) .
       "&access_token=$accesstoken&limit=10000&offset=0";

$list = json_decode(file_get_contents($url), true);

Either to use file_get_contents or curl:

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);

if(! $result = curl_exec($ch)) {
    echo curl_error($ch);
} else {
    $res = json_decode($result, true);
}

curl_close($ch);
var_dump($res);

edited Feb 25, 2014 at 11:07

answered Feb 25, 2014 at 10:37

Hashem Qolami

99.8k27 gold badges157 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ramaraju.d Over a year ago

It isn't working, still returns an empty.. Anything to work with cURL ?

Hashem Qolami Over a year ago

@Ramaraju.d Make sure the query is correct. You can echo $url out and enter that directly into your address bar to check the result.

Ramaraju.d Over a year ago

Yes, i did it.. It works fine.. but the same doesn't fetch in an array. from the file_get_contents i am not getting the result

Hashem Qolami Over a year ago

@Ramaraju.d Updated the answer, used curl to get the result.

Collectives™ on Stack Overflow

How to query facebook graph and parse returned json in codeigniter

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related