StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18625057
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-09-04T22:48:49.240
FavoriteCount
0
LastActivityDate
2013-09-04T22:55:53.707
LastEditDate
2013-09-04T22:55:53.707
LastEditorUserId
315988
OwnerUserId
315988
ParentId
18624967
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I'm assuming your real question is "how can I take data in PHP and make a copy of that data available to Javascript". There are two main approaches you could take: <ol> <li>Have your Javascript, when triggered, attempt to get information from the server via AJAX call. That would be a separate PHP script and the JS would have to pass in some sort of ID or other information to help you figure out what it needs. <ul> <li>Requires a separate PHP script and extra plumbing.</li> <li>Better when the amount of data is large</li> <li>Better when there are a lot of these buttons and users won't use that many of them</li> <li>Forms the foundation of much fancier stuff later on</li> </ul></li> <li>Embed the information into the HTML, and have the Javascript read it out. <ul> <li>Easier to do</li> <li>Page is bigger</li> <li>May become a problem once you start doing it a lot</li> <li>You'll probably need to do this just a little bit even after AJAX gets used, to pass IDs and things.</li> </ul></li> </ol> I'd suggest you try the "quick and dirty" way for the moment, just to get a feel for it. For example, in your PHP page: <pre><code><?php /* ... */ $defaultMessage = "Hello world! Watch me contain single quotes (') and double quotes(\") and other things!"; /* ... */ ?> <button id="new_message" onclick="createMessage(<?= htmlentities(json_encode($defaultMessage))?>">New Message</button> </code></pre> I'm not 100% sure on the escaping, but test with single and double quotes in the data to ensure nothing goes awry, and remember that you need to escape it one way to avoid breaking HTML, and again in another way to avoid breaking javascript. Then in your JS file: <pre><code>function createMessage(defaultMessage) { // ... textarea.value = defaultMessage; // ... } </code></pre> In this way you've put data from PHP into the HTML output, and then later (after the PHP script has stopped running) the user's browser gets the HTML and can can pull that data back out for whatever purpose it needs.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POEmbedding PHP within javascript
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USDarien
UserOwnerUserId
1. USDarien
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.