StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow can I display multiple (but seperate) JSON requests on the same page
primarykey
Id
1977761
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-12-30T00:18:25.470
FavoriteCount
0
LastActivityDate
2009-12-30T00:37:17.130
LastEditDate
2009-12-30T00:31:46.347
LastEditorUserId
34397
OwnerUserId
240241
ParentId
0
PostTypeId
1
Score
0
ViewCount
619
LastEditorDisplayName
text
Body
I have a web page where I want to display hotel reviews from the yelp.com API for a number of hotels. I have managed to do this for one hotel, and it works perfectly displaying the data under that specific hotel's details on the page. However, how can I now multiply this process so that I have separate reviews for each hotel? My web page can be seen at <a href="http://dev.bhx-birmingham-airport.co.uk/pages/hotels.php" rel="nofollow noreferrer">http://dev.bhx-birmingham-airport.co.uk/pages/hotels.php</a> to get an idea of what I'm trying to do. The source code I am using so far looks like: <pre><code><script> function showData(data) { $.each(data.businesses, function(i,business){ // extra loop $.each(business.reviews, function(i,review){ var content = 'Review - ' + review.text_excerpt + ' <a href="http://www.yelp.co.uk/biz/hilton-birmingham-metropole-hotel-solihull">Read more...</a>'; content += 'Rating - <img src="' + business.rating_img_url + '" />'; content += 'Date Added - ' + review.date + ''; $(content).appendTo('#hilton'); }); }); } $(document).ready(function(){ // note the use of the "callback" parameter writeScriptTag( "http://api.yelp.com/business_review_search?"+ "term=hilton%20metropole"+ "&location=B26%203QJ"+ "&ywsid=[...]"+ "&callback=showData"); // <- callback }); function writeScriptTag(path) { var fileref = document.createElement('script'); fileref.setAttribute("type","text/javascript"); fileref.setAttribute("src", path); document.body.appendChild(fileref); } </script> </code></pre>
Tags
<javascript><jquery><json><api>
Title
How can I display multiple (but seperate) JSON requests on the same page
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSLaks
UserOwnerUserId
1. USSimon Cooper
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYou can replace your `writeScriptTag` function with jQuery's `getScript` method: http://docs.jquery.com/Ajax/jQuery.getScript
 singulars
 PostPostId
 POHow can I display multiple (but seperate) JSON requests on the same page
 UserUserId
 USSLaks

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.