|
I want to get my friends picture and their last status message with time.
message,time FROM status
pic_square FROM user
$status = $facebook->api_client->fql_query("SELECT message,time FROM status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=...
Started by anthony on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Status.get is much better for this purpose: http://wiki.developers.facebook.com/index.php/Status.get.
Order by time, and limit to one result.
FQL accepts MySQL-style "ORDER BY" and "LIMIT" clauses.
|
|
I am using this to collect comments made abt a particular user. i want to display 7 comments on each page and want to enable pagination. what would be the steps of implementation. sorry. n00b question.
$query = "SELECT msg, user_id, comment_time FROM ...
Started by amit on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Of course, you....
LIMIT [count] OFFSET [offset results per page.
PostgreSQL uses seperate "select ...
LIMIT $start, $perpage";
You would [offset] [count]" to your query.
; // Build the query using those variables $query = "SELECT ...
|
|
I'm building a site that allows users to sign in using their facebook account.
I want to cache nice big versions of the users profile pictures. I know that i'm not allowed to cache images for more than 24 hours so i'm going to re-fetch the images once...
Started by Martin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You'll.
For the offline_access extended permission so you can query their own photos even when they're not online.
|
Ask your Facebook Friends
|
I'm wondering if this is the best way to tackle this issue. I am merging a Facebook users friends data, (from facebook - returns a multi array) with the votes from the users in that list that voted (from MySQL).
This is how I accomplished this. I'm a ...
Started by Brandon G on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
$friends = $facebook->api_client->fql_query( "SELECT uid, first_name....
api_client->fql_query( "SELECT uid, first_name, last_name FROM user WHERE uid IN (SELECT uid2 named Code Complete .
|
|
I am building a facebook app which is somehow generating these weird errors. the following are the errors I am facing:
Warning: Cannot modify header information - headers already sent by (output started at /home/amitver/public_html/roadies/index.php:2...
Started by amit on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
That error states that index....
Just a single " " and PHP will send that output to the user agent (browser) and you can no longer do header things like change cookies or send header() data .
Check for white space in any of the files that you are including .
|
|
Ok So I haven't tried messing with the facebook PHP API for months.. it's gross. Since template bundles are apparently now defunct, how can I publish a story into my users news feed for their friends? I've also already requested permissions. Edit: The...
Started by AFK on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
$uid ); if( $data[0.
This (and also request them)
function check_perms() { global $facebook, $uid; $data = $facebook->api_client->fql_query( "SELECT uid, publish_stream FROM permissions WHERE uid = " .
|
|
This might be the simplest of questions.
$appapikey = '...'; $appsecret = '...'; $facebook = new Facebook($appapikey, $appsecret); $user_id = $facebook->require_login();
i have the user authenticated and everything. now i want to say hello to the user...
Started by amit on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
):
$facebook->api_client->fql_query("SELECT name FROM user WHERE uid='$user_id'");
the following line to your code:
$userInfo = $facebook->api_client->users_getInfo($user_id, array('name'));
$name....
|
|
Situation:
my facebook application ( http://apps.facebook.com/mymagicmirror/ ) needed to detect user's gender, and then query opposite sex or male or female
FQL:
SELECT uid, name, pic, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1='.$...
Started by Unreality on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
For example, if you are using the PHP client before it) and the other lets you pass in the locale you want to use, like so:
public function &fql_query_localized($....
To your GET or POST request being sent by your API client.
|
|
Hello All,
how can i get a facebook user's info like name, country, etc without making him login using fb connect, etc if i already know his facebook id?
I mean can i use the php facebook client to get those details without prompting for login if i already...
Started by Sarfraz on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
$facebook->api_client->fql_query( "SELECT first_name, last, true); $this->fb->user = $facebookUserId; $this->fb->api_client->session_key....
Snatch up any data using a FQL query.
|
|
I want to fetch 'birthdays' of users, and their friends on my website, from their facebook profiles (with their facebook credentials supplied).
Is their a feature in Facebook API/Connect that I can use to fetch these details from facebook as possible ...
Started by Mohit Nanda on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
) { $data = $facebook->api_client->fql_query( "SELECT birthday_date FROM user WHERE uid=$f for birthdays for the given month/day: $current_date<br />"; $data = $facebook->api_client->fql = $....
|
