Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Assuming you want to do this in pure JavaScript/JQuery - you'll need to use an iframe as the target of a form, there is a caveat - you will not be able to use the return data (the ID / success of the call) because of the same origin policy.</p> <p>First create a form that will hold the file input and any other variables you wish to set:</p> <pre><code>&lt;form id="upload-photo-form"&gt; &lt;input name="source" id="source" size="27" type="file" /&gt; &lt;input name="message" id="message" type="text" value="message example please ignore" /&gt; &lt;/form&gt; </code></pre> <p>Here is the main function used which creates an iframe, points the form to use it, and then retrieves the latest photo from the album using FQL.</p> <pre><code>function fileUpload(form, action_url, div_id) { // Create an iframe var iframe = document.createElement("iframe"); iframe.setAttribute('id', "upload_iframe"); iframe.setAttribute('name', "upload_iframe"); iframe.setAttribute('width', "0px"); iframe.setAttribute('height', "0px"); iframe.setAttribute('border', "0"); iframe.setAttribute('style', "width: 0; height: 0; border: none;"); // Add to document. form.parentNode.appendChild(iframe); window.frames['upload_iframe'].name = "upload_iframe"; iframeId = document.getElementById("upload_iframe"); // Add event to detect when upload has finished var eventHandler = function () { if (iframeId.detachEvent) { iframeId.detachEvent("onload", eventHandler); } else { iframeId.removeEventListener("load", eventHandler, false); } setTimeout(function() { try { $('#upload_iframe').remove(); } catch (e) { } }, 100); FB.api({ method: 'fql.query', query: 'SELECT src_big,pid,caption,object_id FROM photo WHERE aid= "' + albumID + '" ORDER BY created DESC LIMIT 1' }, function(response) { console.log(response); } ); } if (iframeId.addEventListener) iframeId.addEventListener('load', eventHandler, true); if (iframeId.attachEvent) iframeId.attachEvent('onload', eventHandler); // Set properties of form... form.setAttribute('target', 'upload_iframe'); form.setAttribute('action', action_url); form.setAttribute('method', 'post'); form.setAttribute('enctype', 'multipart/form-data'); form.setAttribute('encoding', 'multipart/form-data'); // Submit the form... form.submit(); } </code></pre> <p>At runtime you will presumably know the albumObjectID from a previous call, and have the access token from the session object that is returned by login or session onauthchange.</p> <pre><code>var url = 'https://graph.facebook.com/' + albumObjectID + '/photos?access_token=' + accessToken; fileUpload($('#upload-photo-form')[0], url, $('#upload-photo-div')[0]);` </code></pre> <p>Obviously this isn't production code, there are a few things you can do to improve it's reliability (like checking the width, height, caption &amp; tags of the submitted image to the latest image). Checking the latest image before &amp; after the attempted upload etc. </p> <p>PS: Watch out for the albumObjectID vs albumID, they are different however both can be obtained using some simple FQL queries. (eg: <code>SELECT aid, object_id, can_upload, name FROM album WHERE owner = me() AND name = "My Album Name"</code>)</p> <p>Hope this helps.<br /> CameraSchoolDropout</p>
    singulars
    1. This table or related slice is empty.
    1. POFacebook new javascript sdk- uploading photos with it!
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USCameraSchoolDropout
    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. COThis is the best workaroud I've found. Still, even though I'm able to submit the photo using something similar to this technique, I'm later unable to check the response to validate the upload. Any though on how to do it?
      singulars
      1. PO
      1. UStiagoboldt
    2. COif it's a make or break scenario I would either: a) upload the file to my own server and then have it perform the transfer (essentially using your server on the same domain as a proxy). b) use an optimistic concurrency model by querying the album photos before and after the upload, if there has been a change it's very likely the upload was successful - this has the advantage of being achievable purely in javascript. good luck.
      singulars
      1. PO
      1. USCameraSchoolDropout
    3. COI've personally have setup a django server to handle this part. If anyone follows this thread, there's no viable way to guarantee the upload success, just by requesting and see if there's something there, as @CameraSchoolDropout suggested. But that sucks.
      singulars
      1. PO
      1. UStiagoboldt
 

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