Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Due to same-origin-policy, XMLHttpRequest is not normally allowed to fetch data from other domains. There are work-arounds such as CORS or using a proxy on your domain or using an embedded flash or java applets.</p> <p>However, JSONP is a different story. That's because JSONP does not technically return data. JSONP returns a javascript file. As such, getting data using JSONP simply requires you to add a script tag to your page:</p> <pre><code>&lt;script src="http://other.server.com/path/to/jsonp/data"&gt;&lt;/script&gt; </code></pre> <p>To do it programmatically:</p> <pre><code>var jsonp = document.createElement('script'); jsonp.src = "http://other.server.com/path/to/jsonp/data"; document.body.appendChild(jsonp); </code></pre> <p>The problem with this is that script tags don't return anything. To solve this, the JSONP protocol passes a function name to the server so that the server will wrap that function around the JSON data.</p> <p>For example, if your regular JSON data looks like this:</p> <pre><code>{"result":"something"} </code></pre> <p>The JSONP equivalent would look something like this:</p> <pre><code>callback({"result":"something"}) </code></pre> <p>So, to take the original example, our new code would now be:</p> <pre><code>function processResult (obj) { console.log(obj); } var jsonp = document.createElement('script'); jsonp.src = "http://other.server.com/path/to/jsonp/data?jsonp=processResult"; document.body.appendChild(jsonp); </code></pre> <p>Notice how we're passing the name of the function to handle the return value in the query param of the URL.</p> <p>Note that while in this example the parameter is "jsonp" the server may implement it using some other name. Another common one is "callback", as in <code>callback=processResult</code>. Read the API documentation of the server you're connecting to.</p>
    singulars
    1. This table or related slice is empty.
    1. POUsing XMLHttpRequest to get words from another website
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USslebetman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUsing XMLHttpRequest to get words from another website
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COOhh I see! thank you very much, that's actually helped me understand it a lot better
      singulars
      1. PO
      1. USDaniel Morgan
    2. COI have another question for you because I'm not back in University until after the weekend, do you have any example websites that display JSON data randomly? I can only access the original webpage from my University network. There probably isn't but just thought I'd ask. Thanks!
      singulars
      1. PO
      1. USDaniel Morgan
    3. COYou can try USGS earthquake data: http://earthquake.usgs.gov/earthquakes/feed/geojsonp/2.5/week. It uses a hardcoded callback function called `eqfeed_callback` so you need to define that function in your code.
      singulars
      1. PO
      1. USslebetman
 

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