StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8180398
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-18T09:39:10.637
FavoriteCount
0
LastActivityDate
2011-11-18T09:39:10.637
LastEditDate
LastEditorUserId
0
OwnerUserId
821139
ParentId
8149662
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>I'm a little confused by your question, so you want 1 page that allows the user to fill in a blank form, see a filled out form and update a form?</p> <p>You can do the blank form or filled form by checking if an id exist, like this:</p> <pre><code><? if (isset(id)) // Here you can check if the id exists, which means you will be doing an update to the sql echo' <form method="post" action="pv.php?id=' . $row['ID'] . '&action=' . $form_action . '">  e.g. <label for="cemail">Last Name</label> * <input id="cemail" type="text" name="lastname" value="' . $row['Last_Name'] . '" maxlength="75" /> </form>'; // Put your sql update here to take the values from the above form } elseif (!isset(id)) // Here there is no id so you will want to insert { echo' <form method="post" action="pv.php?id=' . $row['ID'] . '&action=' . $form_action . '">  e.g. <label for="cemail">Last Name</label> * <input id="cemail" type="text" name="lastname" maxlength="75" /> // No value here because will insert new record </form>'; // Put your sql insert here to create a new record } ?> </code></pre> <p>Do you also want the user to be able to add a new comment entirely rather than editing the one already associated with their id? I think you would have to do this by giving them the option to add another comment, to do this I would create a new table and then insert the comments into that, so you have one table with the user information, then another table with the user comments, for example:</p> <pre><code>example_users: id = 1 fname=Joe lname=Bloggs email=jbloggs@example.com user_comments id=1 user_id=1 comment = Comment will be saved here </code></pre> <p>This way any user can have any number of comments, you could render this on the page by using a foreach statement to render a text box with all their existing comments and then have a blank one at the end for any new ones, then they can edit any comment and add a new comment. </p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POphp comment form
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USiain
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POphp comment form
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
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.