StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17130192
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-16T04:27:54.613
FavoriteCount
0
LastActivityDate
2013-06-16T04:35:26.963
LastEditDate
2013-06-16T04:35:26.963
LastEditorUserId
426803
OwnerUserId
426803
ParentId
17115396
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Conclusions: For problem #2. There a two types of JSON. a)JSONObject like this single row: <pre><code>{ 'id':'123', 'title':'my house' } </code></pre> b)JSONArray like this single row: <pre><code>[ { 'id':'123', 'title':'my house' } ] </code></pre> Do you see the brackets? Or like this other JSONArray: <pre><code>[ { 'id':'123', 'title':'my house' }, { 'id':'124', 'title':'my car' } ] </code></pre> With JSONObjects, you must use {{post.title}} in the template. <pre><code><div> {{post.title}} </div> </code></pre> {{post[0].title}} shall give you an error because data isn't an array. It doesn't use brackets. And with JSONArrays (with one or more rows), you can use ng-repeat in the template, like: <pre><code><div ng-repeat="post in post"> {{post.title}} </div> </code></pre> Or, also you can access directly a specific row: <pre><code><div> {{post[0].title}} {{post[1].title}} </div> </code></pre> <hr> For problem #1, you could use something like explained here: <a href="http://docs.angularjs.org/tutorial/step_11" rel="nofollow">Step #11 in AngularJS' tutorial ($resource)</a> But, I found easier to do a single change; this is my previous code: <pre><code>function postCtrl($scope, $http, $routeParams) { $http.get('post.php?id=' + $routeParams.postId).success(function(data) { $scope.post = data; }); $scope.description = $scope.post.meta_description; /*I can't access this value*/ } </code></pre> The problem is $scope.post only exists inside the function inside $http.get; it's like a private variable that can't be access from outside of the function. So an easier solution than to use $resource, was to move $scope.description inside $http.get. <pre><code>function postCtrl($scope, $http, $routeParams) { $http.get('post.php?id=' + $routeParams.postId).success(function(data) { $scope.post = data; $scope.description = data.meta_description; }); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAngularJS - How to access directly a $scope's row/value from the controller
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USLuis Arriojas
UserOwnerUserId
1. USLuis Arriojas
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.