php - login with facebook with database

Question

in my localhost site i am using login with facebook feature and it's working fine but now i want to store user details to my database so, i put some code in facebook SDK file fb-callback.php like...

<?php
session_start();
require_once 'facebook-php-sdk-v4/src/Facebook/autoload.php';
$fb = new FacebookFacebook([
  'app_id' => 'app_id', // Replace {app-id} with your app id
  'app_secret' => 'app_secret',
  'default_graph_version' => 'v2.5',
  ]);

$helper = $fb->getRedirectLoginHelper();

try {
  $accessToken = $helper->getAccessToken();
} catch(FacebookExceptionsFacebookResponseException $e) {
  // When Graph returns an error
  echo 'Graph returned an error: ' . $e->getMessage();
  exit;
} catch(FacebookExceptionsFacebookSDKException $e) {
  // When validation fails or other local issues
  echo 'Facebook SDK returned an error: ' . $e->getMessage();
  exit;
}

if (! isset($accessToken)) {
  if ($helper->getError()) {
    header('HTTP/1.0 401 Unauthorized');
    echo "Error: " . $helper->getError() . "
";
    echo "Error Code: " . $helper->getErrorCode() . "
";
    echo "Error Reason: " . $helper->getErrorReason() . "
";
    echo "Error Description: " . $helper->getErrorDescription() . "
";
  } else {
    header('HTTP/1.0 400 Bad Request');
    echo 'Bad request';
  }
  exit;
}

// Logged in
echo '<h3>Access Token</h3>';
var_dump($accessToken->getValue());

// The OAuth 2.0 client handler helps us manage access tokens
$oAuth2Client = $fb->getOAuth2Client();

// Get the access token metadata from /debug_token
$tokenMetadata = $oAuth2Client->debugToken($accessToken);
echo '<h3>Metadata</h3>';
var_dump($tokenMetadata);

// Validation (these will throw FacebookSDKException's when they fail)
$tokenMetadata->validateAppId("app_id"); // Replace {app-id} with    your app id
// If you know the user ID this access token belongs to, you can validate it here
//$tokenMetadata->validateUserId('123');
$tokenMetadata->validateExpiration();

if (! $accessToken->isLongLived()) {
  // Exchanges a short-lived access token for a long-lived one
  try {
    $accessToken = $oAuth2Client->getLongLivedAccessToken($accessToken);
  } catch (FacebookExceptionsFacebookSDKException $e) {
    echo "<p>Error getting long-lived access token: " . $helper->getMessage() . "</p>

";
    exit;
  }

  echo '<h3>Long-lived</h3>';
  var_dump($accessToken->getValue());
}

$_SESSION['fb_access_token'] = (string) $accessToken;
$fbApp = new FacebookFacebookApp('app_id',  'app_secret');
$request = new FacebookFacebookRequest($fbApp, $accessToken, 'GET', '/me');
try {
  $response = $fb->getClient()->sendRequest($request);
} catch(FacebookExceptionsFacebookResponseException $e) {
  // When Graph returns an error
  echo 'Graph returned an error: ' . $e->getMessage();
  exit;
} catch(FacebookExceptionsFacebookSDKException $e) {
  // When validation fails or other local issues
  echo 'Facebook SDK returned an error: ' . $e->getMessage();
  exit;
}

$graphNode = $response->getGraphNode();
include "config.php";
$query = "INSERT INTO users VALUES ('', '".$graphNode['name']."', '".$graphNode['email']."')";
$result = mysql_query($query);
if ($result) {
// User is logged in with a long-lived access token.
// You can redirect them to a members-only page.
header('location:index.php');
}
else{
  echo "Problem In Login";
}
?>

but it inserting only name in database not email. Please help me.

Answer 1

it's done with this.

$_SESSION['fb_access_token'] = (string) $accessToken;
$fbApp = new FacebookFacebookApp('1014758295283866', 'b1a98e587c8bef98dfb273db67214afb');
$request = new FacebookFacebookRequest($fbApp, $accessToken, 'GET', '/me', ['fields' => 'id,name,email']);
try {
     $response = $fb->getClient()->sendRequest($request);
} catch(FacebookExceptionsFacebookResponseException $e) {
  // When Graph returns an error
  echo 'Graph returned an error: ' . $e->getMessage();
  exit;
} catch(FacebookExceptionsFacebookSDKException $e) {
  // When validation fails or other local issues
  echo 'Facebook SDK returned an error: ' . $e->getMessage();
  exit;
}

$graphNode = $response->getGraphNode();
include "config.php";
$query = "INSERT INTO users VALUES ('', '".$graphNode['name']."', '".$graphNode['email']."')";
$result = mysql_query($query);
if ($result) {
// User is logged in with a long-lived access token.
// You can redirect them to a members-only page.
header('location:index.php');
}
else{
  echo "Problem In Login";
}