StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16225140
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-25T21:35:47.400
FavoriteCount
0
LastActivityDate
2013-04-25T21:35:47.400
LastEditDate
LastEditorUserId
0
OwnerUserId
1429585
ParentId
10132685
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
<p>I'm not sure if you're still interested in a solution, but I was able to modify the json-api plugin models/post.php file to display the repeater data as an array. This is a modification of a modification made by <a href="http://wordpress-problem.com/marioario-on-plugin-json-api-fixed-get-all-custom-fields-the-right-way/" rel="nofollow">http://wordpress-problem.com/marioario-on-plugin-json-api-fixed-get-all-custom-fields-the-right-way/</a></p> <p>replace the set_custom_fields_value() function with the following:</p> <pre><code>function set_custom_fields_value() { global $json_api; if ($json_api->include_value('custom_fields') && $json_api->query->custom_fields) { // Query string params for this query var $params = trim($json_api->query->custom_fields); // Get all custom fields if true|all|* is passed if ($params === "*" || $params === "true" || $params === "all") { $wp_custom_fields = get_post_custom($this->id); $this->custom_fields = new stdClass(); // Loop through our custom fields and place on property foreach($wp_custom_fields as $key => $val) { if (get_field($key)) { $this->custom_fields->$key = get_field($key); } else if ($val) { // Some fields are stored as serialized arrays. // This method does not support multidimensionals... // but didn't see anything wrong with this approach $current_custom_field = @unserialize($wp_custom_fields[$key][0]); if (is_array($current_custom_field)) { // Loop through the unserialized array foreach($current_custom_field as $sub_key => $sub_val) { // Lets append these for correct JSON output $this->custom_fields->$key->$sub_key = $sub_val; } } else { // Break this value of this custom field out of its array // and place it on the stack like usual $this->custom_fields->$key = $wp_custom_fields[$key][0]; } } } } else { // Well this is the old way but with the unserialized array fix $params = explode(',', $params); $wp_custom_fields = get_post_custom($this->id); $this->custom_fields = new stdClass(); foreach ($params as $key) { if (isset($wp_custom_fields[$key]) && $wp_custom_fields[$key][0] ) { $current_custom_field = @unserialize($wp_custom_fields[$key][0]); if (is_array($current_custom_field)) { foreach($current_custom_field as $sub_key => $sub_val) { $this->custom_fields->$key->$sub_key = $sub_val; } } else { $this->custom_fields->$key = $wp_custom_fields[$key][0]; } } } } } else { unset($this->custom_fields); } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POJSON API to show Advanced Custom Fields - WordPress
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USkillianlgrant
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. This table or related slice is empty.
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.