How do i use FQL with php api? and access token

Question

Grr... I cant seem to get fql working. One thing, I think the docs are old because i dont think api() likes just an array. Anyway:

$user_id = $facebook->getUser();//works
$access_token = $facebook->getAccessToken();//works
$fql = 'SELECT name from user where uid = ' . $user_id;
    $ret_obj = $facebook->api(array(
                                   'method' => 'fql.query',
                            'access_token' => $access_token,
                                  'query' => $fql,
                                 ));
print_r($ret_obj);// dont work. actually I get exceptions

I've tried all kinds of combinations of params for api(), to no avail.

$user = curl('https://graph.facebook.com/'.$user_id.'?access_token='.$access_token);

does work, though.

score 6 · Accepted Answer · answered Jul 07 '12 at 04:05

6

I use this:

function fql($q, $access_token) {
    // Run fql query
    $fql_query_url = 'https://graph.facebook.com'
    . '/fql?q='. urlencode($q)
    . '&access_token=' . urlencode($access_token);
    $fql_query_result = file_get_contents($fql_query_url);


    $length = strlen(PHP_INT_MAX);
    $fql_query_result = preg_replace('/"(user_id)":(\d{' . $length . ',})/', '"\1":"\2"', $fql_query_result);

    return json_decode($fql_query_result, true);
}

answered Jul 07 '12 at 04:05

antirealm

408
3
10

what is your preg_replace line doing? – Doug Cassidy Jul 09 '12 at 20:28
1

I'm using this function, but have replaced the file_get_contents with my curl wrapper function (my server had an issue with fgc and outside urls) thanks. – Doug Cassidy Jul 10 '12 at 16:27

How do i use FQL with php api? and access token

1 Answers1

Linked