StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17118137
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-06-14T22:24:49.203
FavoriteCount
0
LastActivityDate
2013-06-14T22:24:49.203
LastEditDate
LastEditorUserId
0
OwnerUserId
0
ParentId
17101285
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Here's a jQuery implementation that polls the server script every 1000ms and displays the result. Your typical response time + browser processing time should be significantly less than your polling interval or your requests might back-up.</p> <p><strong>Javascript:</strong></p> <pre><code><!DOCTYPE html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>eventCounter</title> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script> <script type="text/javascript"> var interval = setInterval(function() { // this is where your ajax call is made. $.ajax('geteventcounter.php', { cache: false, dataType:'json', success: function(data) { // do your browser-side processing here. $('#eventCounter').text(data.eventcounter); } }); }, 1000); </script> </head> <body> <p>eventCounter is <span id=eventCounter></span></p> </body> </html> </code></pre> <p><strong>Server side PHP:</strong> For this example, uses a session variable which it increments on every request and returns a JSON string.</p> <pre><code><?php session_start(); // initialise counter, or increment it. if (isset($_SESSION['eventcounter'])) { $_SESSION['eventcounter']++; } else { $_SESSION['eventcounter'] = 0; } // set output mime type header("ContentType: application/json"); // copy session variable to a new array, convert to JSON and send. echo json_encode(['eventcounter' => $_SESSION['eventcounter']]); ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I request a variable from the webserver using AJAX?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. This table or related slice is empty.
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. COserver is not compatible with php
  singulars
  PostPostId
  PO
  UserUserId
  USuser2266621
2. COYou asked how to request a variable with AJAX. I've given you an example, and for completeness I provided the PHP script I used to test it. This is not supposed to be a final solution - you will need to adapt it to your needs, and bring it up to production standard yourself.
  singulars
  PostPostId
  PO
  UserUserId
  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.