AJAX: Process Requests from Database synchronously

Question

I have a table with 200 rows. I am trying to access a third party API for IMDB website, which will return response for the title given in the below format.

http://www.imdbapi.com/?t=Inception

My table has all titles populated. Now I need to access this URL with 't' parameter being changed dynamically from the database. I have my synchronous java script ready, but How do I call this script in a loop for n rows. Thank you.

Take a look at http://api.jquery.com/jQuery.ajax/ ;-) - if you are a little bit familiar with JavaScript you should do it! — thedom, Jan 23 '11 at 19:33
imdbapi.com? The legality of this api is slightly questionable if you don't mind me saying so. And what exactly is your problem? Use the http://www.imdbapi.com/?t=Inception&r=xml variant and then do a foreach($urls as $url){ grab_xml($url); } — Flying Swissman, Jan 23 '11 at 22:23

score 0 · Accepted Answer · edited May 23 '17 at 10:33

I'm assuming you have preloaded the titles into a JavaScript array of the form: ['Title1', 'Title2'] etc. My example below makes use of JQuery to simplify the use of Ajax.

var titles = ['Inception', 'Batman Begins', 'Terminator Salvation'];

for (var i=0;i<titles.length;i++) {
  $.getJSON('http://www.imdbapi.com/?t=' + titles[i], function(data) {
      // HANDLE THE DATA HERE
  });
}

There is one small catch, however. The code is not going to work on most browsers because you are trying to access a site whose domain is different from yours. That is called cross-domain scripting and most browsers do not allow it. This is typically handled by means of a proxy i.e. you get your server to connect to the URL using an Http client and then you access it from your server. JSONP is another approach you might use. This post can be helpful:

Firefox setting to enable cross domain ajax request

AJAX: Process Requests from Database synchronously

1 Answers1