StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJSON Jquery Array type
primarykey
Id
5010161
data
AcceptedAnswerId
5010443
AnswerCount
1
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2011-02-15T22:16:48.653
FavoriteCount
0
LastActivityDate
2011-02-15T22:46:54.960
LastEditDate
2011-02-15T22:43:51.543
LastEditorUserId
218196
OwnerUserId
618658
ParentId
0
PostTypeId
1
Score
0
ViewCount
1478
LastEditorDisplayName
text
Body
<p>I have a basic question on JSON Jquery, and it seams I am sort of stuck some at a point of extracting array objects. My Code below is in javascript, and I just wanted some clarifications as what I might be doing wrong here.</p> <pre><code><?php $nor = $_SESSION["north"]; $sou = $_SESSION["south"]; $eas = $_SESSION["east"]; $wes = $_SESSION["west"]; session_destroy(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>jQuery JSON test</title> </head> <body> <script type="text/javascript" src="http://code.jquery.com/jquery-1.5.js"></script> <script type="text/javascript"> var north = "<?php echo $nor ?>"; var south = "<?php echo $sou ?>"; var east = "<?php echo $eas ?>"; var west = "<?php echo $wes ?>"; document.write(north,south,east,west); $(document).ready(function(){ alert("begin loop"); $.getJSON('http://api.geonames.org/earthquakesJSON?north=' + north + ' &south=' + south + '&east=' + east + '&west=' + west +'&callback=?', function(data){ alert(data.earthquakes); }); }) </script> </body> </html> </code></pre> <p>So when I use alert(data.earthquakes); I get undefined operation, which is fine but I know here I am getting a response back. However the architecture of the JSON is as following:</p> <pre><code>{"earthquakes": [ {"eqid":"2007hear","magnitude":8.4,"lng":101.3815,"src":"us","datetime":"2007-09-12 09:10:26","depth":30,"lat":-4.5172}, {"eqid":"2007aqbk","magnitude":8,"lng":156.9567,"src":"us","datetime":"2007-04-01 18:39:56","depth":10,"lat":-8.4528}, {"eqid":"2007hec6","magnitude":7.8,"lng":100.9638,"src":"us","datetime":"2007-09-12 21:49:01","depth":10,"lat":-2.5265} ]} </code></pre> <p>So I have tried different ways of extracting information such as <code>alert(data.earthquakes[1].eqid);</code> and <code>alert(data.earthquakes.eqid[1]);</code>, however I am not getting the dedicated array as wanted. </p> <p>Could someone direct me as </p> <ol> <li>how to get the desired architecture result appropriately and </li> <li>if I want to use array and for loop to extract all the elements into local array, </li> </ol> <p>how to do that?</p>
Tags
<javascript><jquery><json><geonames>
Title
JSON Jquery Array type
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USFelix Kling
UserOwnerUserId
1. USkforkarim
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
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

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.