Databases
StackOverflow2013
Postsdbo
POFacebook API & Ajax POST request
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFacebook API & Ajax POST request
    primarykey
    data
    text
    <p>I have a Facebook connect/disconnect link. When user clicks on "Facebook connect" link (on <strong>index.php</strong>), it checks the user state (Is he connected to Facebook or not?) then if he's not connected, my script sends an Ajax $.post request to <strong>connect.php</strong> in order to retrieve infos from database (for instance : Is the user registered in our database?). After that, it sends back a response to index.php : if there is no error, the page is refreshed. In this case, if everything is ok, after the page is refreshed by the script (<strong>window.location.reload();</strong>), we should see the Facebook user ID (UID).</p> <p>The problem is the UID is still empty after the page is reloaded through the ajax callback. But, if I refresh the page manually one more time, I can now see the UID.</p> <p>I test many ways to understand where the problem comes from, and I found there is a problem with this Facebook request : <strong>$me = $facebook->api('/me');</strong></p> <p>Anyway, I can't do without <strong>$me = $facebook->api('/me');</strong> so if you want to test my script and find the problem, here is what you need ! (don't forget the last Facebook SDK) ;-)</p> <p>Any help would be very apreciated ! Thanks !</p> <p><strong>index.php</strong></p> <pre><code>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /&gt; &lt;title&gt;Facebook Connect&lt;/title&gt; &lt;script src="js/jquery.js"&gt;&lt;/script&gt; &lt;?php /* FACEBOOK APP CONFIGURATION */ $appId = 'YOU_APP_ID'; $appSecret = 'YOUR_APP_SECRET'; define("APPID",$appId); define("APPSECRET",$appSecret); /* API CALL */ if (!class_exists('FacebookApiException')) { require_once('inc/facebook.php' ); } $facebook = new Facebook(array( 'appId' =&gt; APPID, 'secret' =&gt; APPSECRET, )); $fb_user = $facebook-&gt;getUser(); if ($fb_user) { try { $me = $facebook-&gt;api('/me'); $uid = $facebook-&gt;getUser(); } catch (FacebookApiException $e) { //echo error_log($e); $fb_user = null; } } ?&gt; &lt;/head&gt; &lt;body&gt; &lt;div id="fb-root"&gt;&lt;/div&gt; &lt;script&gt;(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/fr_FR/all.js#xfbml=1&amp;appId=&lt;?=APPID?&gt;"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));&lt;/script&gt; &lt;script type="text/javascript"&gt; window.fbAsyncInit = function() { FB.init({ appId : '&lt;?=APPID?&gt;', oauth : true, status : true, cookie : true, xfbml : true }); }; function fb_connect() { alert('FB.getLoginStatus'); FB.getLoginStatus(function(response) { if (response.status === 'connected') { var access_token = response.authResponse.accessToken; var user_id = response.authResponse.userID; // window.location.reload(); // } else { alert('FB.login'); FB.login(function(response) { var access_token = response.authResponse.accessToken; var user_id = response.authResponse.userID; $.post('connect.php', function(data) { var obj = $.parseJSON(data); if (obj['error']==0) { alert(obj['message']); window.location.reload(); } else { alert(obj['message']); } }); // }, { scope: 'email, publish_stream, user_birthday' }); } }); } function fb_logout() { FB.logout(function(response) { window.location.reload(); }); } (function() { var e = document.createElement('script'); e.src = document.location.protocol + '//connect.facebook.net/fr_FR/all.js'; e.async = true; document.getElementById('fb-root').appendChild(e); }()); &lt;/script&gt; &lt;p&gt;UID : &lt;?=$fb_user?&gt;&lt;/p&gt; &lt;?php if ($fb_user) { ?&gt; &lt;a href="#" onclick="fb_logout();"&gt;Disconnect&lt;/a&gt; &lt;?php } else { ?&gt; &lt;a href="#" onclick="fb_connect();"&gt;Facebook connect&lt;/a&gt; &lt;?php } ?&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p><strong>connect.php</strong></p> <pre><code>&lt;?php /* FACEBOOK APP CONFIGURATION */ $appId = 'YOUR_APP_ID'; $appSecret = 'YOUR_APP_SECRET'; define("APPID",$appId); define("APPSECRET",$appSecret); /* API CALL */ if (!class_exists('FacebookApiException')) { require_once('inc/facebook.php' ); } $facebook = new Facebook(array( 'appId' =&gt; APPID, 'secret' =&gt; APPSECRET, )); $fb_user = $facebook-&gt;getUser(); if ($fb_user) { try { $me = $facebook-&gt;api('/me'); $uid = $facebook-&gt;getUser(); } catch (FacebookApiException $e) { //echo error_log($e); $fb_user = null; } } /* CALLBACK */ $result = array(); if ($fb_user) { $result['error'] = 0; $result['message'] = $me['first_name'];; } else { $result['error'] = 1; $result['message'] = 'error'; } echo json_encode($result); ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USXavier C.
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTDuplicate
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COHave you checked for error messages/exceptions thrown from your PHP script? Btw., I don’t see you POSTing any data to your `connect.php`, and all this file does is requesting user data from Facebook and sending it back to the client as JSON – only to then reload the page, so that the whole _requesting user data from Facebook_ part is done _again_ – what’s the logic behind that please?
      singulars
      1. POFacebook API & Ajax POST request
      1. USCBroe
    2. COYou're right, I don't POST anything here, but I just ask Facebook to connect user through ajax and send back the JSON data (in fact I've shortened the script but it checks info in database in connect.php in real). But once I go back and dynamically refresh the index.php page, normally I should be Facebook authenticated and I should see my Facebook infos. But it fails. Only a manual page refresh lets me see my FB infos. So I don't understand...
      singulars
      1. POFacebook API & Ajax POST request
      1. USXavier C.
    3. COWell have you tried it without this still pretty superfluous sounding AJAX step – after login, just reload the index.php …?
      singulars
      1. POFacebook API & Ajax POST request
      1. USCBroe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload