Facebook App : Problem with storing user info

Posted by Jack on Stack Overflow See other posts from Stack Overflow or by Jack
Published on 2010-03-23T08:19:29Z Indexed on 2010/03/23 8:23 UTC
Read the original article Hit count: 312

Filed under:
|
|
|

I want to store basic user info like name and proxied email into my MySQL database. Here's my code

$user = $facebook->require_login($required_permissions = 'publish_stream','status_update','email');

$con = mysql_connect("xxxx","xxxxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("xxx_userdb", $con);
//Uptil Here it is working fine...No problem with db connection

$fql_firstname = "select first_name from user where uid = '$user'";
$fql_lastname = "select last_name from user where uid = '$user'";
$fql_email = "select proxied_email from user where uid = '$user'";


$fql_fname_result = $facebook->api_client->fql_query($fql_firstname);
$fql_lname_result = $facebook->api_client->fql_query($fql_lastname);
$fql_email_result = $facebook->api_client->fql_query($fql_email);

echo "<pre>FQL Result:" . print_r($fql_fname_result,true) . "</pre>";
echo "<pre>FQL Result:" . print_r($fql_lname_result,true) . "</pre>";
echo "<pre>FQL Result:" . print_r($fql_email_result,true) . "</pre>";

Here's the output I get

FQL Result:

FQL Result:

FQL Result:

What am I doing wrong?

© Stack Overflow or respective owner

Related posts about facebook

Related posts about php