StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7926666
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-10-28T08:08:55.443
FavoriteCount
0
LastActivityDate
2011-10-28T08:13:58.887
LastEditDate
2011-10-28T08:13:58.887
LastEditorUserId
381673
OwnerUserId
381673
ParentId
1390983
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
For sake of completeness (as I can't add comments yet), let me also add this detail as another answer: (Edit: To be read after realizing that the source data (i.e. in the OP's case, database result set) could be the problem (by returning numeric columns as strings), and json_encode() in fact was not the source of the problem) Manual pages of both "<a href="http://us.php.net/manual/en/function.mysql-fetch-array.php" rel="nofollow">mysql_fetch_array</a>": <blockquote> Returns an array of strings that corresponds to the fetched row, </blockquote> ... and "<a href="http://us.php.net/manual/en/function.mysql-fetch-row.php" rel="nofollow">mysql_ fetch_ row</a>": <blockquote> Returns an numerical array of strings that corresponds to the fetched row </blockquote> clearly states that; the entries in the returned array will be strings. (I was using the DB class in phpBB2 (yes I know, it's obsolete!), and "sql_fetchrow()" method of that class uses "mysql_fetch_array()") Not realizing that, I also ended up finding this question, and understanding the problem! :) As Pascal Martin stated above in his follow-up comments, I believe a solution that takes care of the "incorrect type" problem at the source (i.e. by using the "<a href="http://us.php.net/manual/en/function.mysql-field-type.php" rel="nofollow">mysql_field_type()</a>" function and doing the casting right after fetch, (or other fetch methods like "object"?)) would be the better in general.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP json_encode encoding numbers as strings
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USOzgurH
UserOwnerUserId
1. USOzgurH
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.