StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16578089
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-16T02:32:07.577
FavoriteCount
0
LastActivityDate
2013-05-16T02:41:33.080
LastEditDate
2013-05-16T02:41:33.080
LastEditorUserId
1041885
OwnerUserId
1041885
ParentId
16578019
PostTypeId
2
Score
12
ViewCount
0
LastEditorDisplayName
text
Body
The second argument of <code>json_decode</code> tells the function whether to return the data as an object, or an array. Object access uses the <code>-></code> symbol. To return an object from <code>json_decode</code> either use <code>json_decode($jsonString)</code> or <code>json_decode($jsonString, false)</code> (the second argument is <a href="http://php.net/manual/en/function.json-decode.php">false by default</a>) <pre><code>$jsonString = '{ "this_is_json" : "hello!" }'; $obj = json_decode($jsonString); echo $obj->this_is_json // "hello!"; </code></pre> You can also access your json data as an array by setting the second argument to <code>true</code> <pre><code>$jsonString = '{ "this_is_json" : "hello!" }'; $arr = json_decode($jsonString, true); echo $arr['this_is_json'] // "hello!"; </code></pre> What can be a little more conceptually confusing, is that PHP <code>json_decode</code> can return either an array of objects (rather than just an object), or an associative array. Consider the following json string. This string represents a "collection" (square brackets) of json data structures (curly braces). <pre><code>[ { "name": "One" }, { "name": "Two" } ] </code></pre> If we assign this json to the variable <code>$string</code> hopefully this will illustrate the difference <pre><code>$asObjects = json_decode($string); $asAssociativeArray = json_decode($string, true); foreach ($asObjects as $obj) { echo $obj->name; } foreach ($asAssociativeArray as $arr) { echo $arr['name']; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGetting JSON data with PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPete Mitchell
UserOwnerUserId
1. USPete Mitchell
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POGetting JSON data with PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

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.