Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Answers: 1. I think you are on the right track. You could also ensure that a [native user] logged in can access the sign up page and push the FB account join to user profile page or something like that.</p> <ol start="3"> <li>You could easily get the user id since its a public info provided by facebook for all registered accounts. But that user will need to allow your app inorder to be able to get their info from facebook profile. But the good news is that almost all the work is done by facebook for you and you just have to point the user to the right url. There is also the social plugin that you could to register users on your site/app with the <a href="https://developers.facebook.com/docs/plugins/registration/" rel="noreferrer">Facebook register social plugin</a></li> </ol> <p>As noted in in the facebook api documentation, <code>$uid</code> will contain the facebook user id of the current user [browsing your site] or null after a call to <code>$uid = $facebook->getUser();</code></p> <p>So first of, you could check that the $uid is valid [not null or zero]. Then if is passes that test, you could attempt to retrieve the public profile info by issuing a <code>$user = $facebook->api('/me')</code>. That should provide your with the user profile if the is logged in to facebook already. If not then the user perhaps has a facebook account but not logged in.</p> <blockquote> <p>Note that the api('/me') could throw an exception if the right token was not passed, so you should wrap it in a try-catch block and handle the exception according to your app.[Perhaps assume that the user is not logged in. If you are sure that your app_id and secret id are valid ]</p> </blockquote> <p>If $user is null then you can get the url to redirect the user to [for facebook login ] by calling <code>$loginUrl = $facebook->getLoginUrl()</code> and redirect the user or provide a clickable link to URL. </p> <p>All these are documented in the <a href="https://developers.facebook.com/docs/reference/php/" rel="noreferrer">facebook api documentation</a></p> <p>Sample Code:</p> <pre><code>&lt;?php require_once("facebook.php"); $config = array(); $config['appId'] = 'app id'; $config['secret'] = 'secret app id'; $facebook = new Facebook($config); $uid = $facebook-&gt;getUser(); if( ! $uid){ // we have an id try{ $user = $facebook-&gt;api('/me'); //get the current user's FB public profile if($user){ // we have a valid user who is logged in to his facebook account $logoutURL = $facebook-&gt;getLogoutUrl(); // user } }catch(FacebookApiException $e){ $user = null; $loginURL = $facebook-&gt;getLoginUrl(); } } </code></pre> <p>Again all these are documented in the facebook PHP client so its your best choice to start. Facebook changes its api without much notification so you should visit their developer page in case your code start to behave strangely. </p> <p>Hope it helps!</p>
    singulars
    1. This table or related slice is empty.
    1. POAdd facebook login to an existing login system
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USshawndreck
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for your answer! Yeah this definitely helped me! It works now, when the user logs in I get the id, when the user logs out from facebook, then the user is logged out at my site. And when the user logs out from my site, the user is still logged in at facebook. So it works like I want. I only have one "problem" and that is to keep the user logged in. I guess the only solution is to create a unique code, like I do for users who logs in with user/pw with rembember me checked.
      singulars
      1. PO
      1. USSimonh
    2. COIf you do not want to be querying the Facebook API on every request even though the user is logged in to both Facebook and your site, then you should definitely create a session record for that user and provide a log out link that clears the session data on your site. You could keep a flag on this session record to mark it as alien/external so that privileges can be sorted out between your site registered users and facebook. Hope it helps!
      singulars
      1. PO
      1. USshawndreck
 

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