Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>first, you'll need to set up an application on facebook, and specify you'll be using it on a website. You can do that at <a href="http://developers.facebook.com/apps/" rel="nofollow">http://developers.facebook.com/apps/</a></p> <p>since you mention c# (which is vary hard to work with), here's the best way to do it in JS:</p> <pre><code>&lt;div id="fb-root"&gt;&lt;/div&gt; &lt;script language="javascript"&gt; var facebookappid = '##FACEBOOK_APP_ID##'; //this is the site owners facebook id. note she must make all her galleries and pictures public var userid = '8979567465474'; //load the facebook SDK window.fbAsyncInit = function() { FB.init({appId: facebookappid, status: true, cookie: true, xfbml: true}); }; (function() { var e = document.createElement('script'); e.async = true; e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js'; document.getElementById('fb-root').appendChild(e); }()); //get albums var albums; FB.api('/'+userid+'/albums/', 'get', function(response){ if (!response || response.error) { albums = response.error; } else { albums = response; } }); &lt;/script&gt; </code></pre> <p>From there you can take your albums variable, which is going to give you an array of album ids. Loop through each album, and use the same code FB.api to get '/'+userid+'/'+albumid+'/photos'</p> <p>You can use the Graph API explorer to view all of the information you get back from each array <a href="https://developers.facebook.com/tools/explorer?method=GET" rel="nofollow">https://developers.facebook.com/tools/explorer?method=GET</a></p> <p>Here's an example of the data returned from my profile pictures album: <a href="https://developers.facebook.com/tools/explorer?method=GET&amp;path=159665340734292%2Fphotos%2F" rel="nofollow">https://developers.facebook.com/tools/explorer?method=GET&amp;path=159665340734292%2Fphotos%2F</a></p> <p>Hopefully that helps! If you need further explanation just let me know :)</p>
    singulars
    1. This table or related slice is empty.
    1. POGet photos and photo albums from facebook
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USAE Grey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGet photos and photo albums from facebook
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COAlright, thanks I am going to try it out. I can actually do it in JavaScript as well since it is a web application. The part that confused me is that all examples showed that I need a token in order to access this info.
      singulars
      1. PO
      1. USmilagvoniduak
    2. COFacebook is the most confusing platform to work on ever. Most of their documentation is vague or even wrong. Haha. You get an access token when you initialize the API, you don't have to specify it in the code. You don't have the prompt the user for any information as you're not accessing their information, only someone elses. But that's why the photos have to be public.
      singulars
      1. PO
      1. USAE Grey
    3. COYou're client won't need to grant the app access if the data is public. Otherwise she will need to grant access to photos, and access data anytime permissions.
      singulars
      1. PO
      1. USAE Grey
 

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