StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4941108
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-02-09T03:46:37.817
FavoriteCount
0
LastActivityDate
2011-02-09T05:09:43.423
LastEditDate
2011-02-09T05:09:43.423
LastEditorUserId
602401
OwnerUserId
602401
ParentId
4941008
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code><?php // to eventually re-fill the fields $name = ""; $email = ""; $gender = ""; $age = ""; $comments = ""; // to re-select a radio button and select option $Mchecked = ""; $Fchecked = ""; $selectMinus_30=""; $select30_to_60=""; $select60_plus=""; // to display errors $error = ""; $done=false; if (isset($_POST["name"]) && isset($_POST["email"]) && isset($_POST["age"])){ if($_POST["name"]==""){ $error = "empty name <br/>"; } if($_POST["email"]==""){ $error = $error . "empty mail <br/>"; } if(!isset($_POST["gen"])){ $error = $error . "empty gender <br/>"; } else{ $gender = $_POST["gen"]; if ($gender == "Male"){ $Mchecked = "checked"; } else if ($gender == "Female"){ $Fchecked = "checked"; } } if($_POST["comments"]==""){ $error = $error . "error: empty comments <br/>"; } $name = $_POST["name"]; $email = $_POST["email"]; $comments = $_POST["comments"]; $age = $_POST["age"]; if ($age == "Under 30"){ $selectMinus_30 = "selected"; } else if ($age == "Between 30 and 60"){ $select30_to_60 = "selected"; } else if ($age == "60+"){ $select60_plus = "selected"; } if ($error==""){ $done=true; } } ?> <html> <head> <title>Lab6 : P1</title> </head> <body> <?php if (!$done){ ?> <fieldset> <legend><h4>Enter your information in the fields below</h4></legend> <p class="error" style="color:red;"><?php echo $error;?></p> <form name="info" method="post" action="<?php echo $_SERVER["PHP_SELF"];?>" method="post"> <strong>Name:</strong> <input type="text" name="name" id="name" value="<?php echo $name; ?>" /><br/> <strong>Email:</strong> <input type="text" name="email" id="email" value="<?php echo $email; ?>" /><br/> <br/> <strong>Gender</strong><br/> <input type="radio" name="gen" value="Male" <?php echo $Mchecked;?>>Male</input><br/> <input type="radio" name="gen" value="Female" <?php echo $Fchecked;?>>Female</input><br/> <br/> <select name="age" value="<?php echo $age;?>"> <option value="Under 30" <?php echo $selectMinus_30;?>>Under 30</option><br/> <option value="Between 30 and 60" <?php echo $select30_to_60;?>>Between 30 and 60</option><br/> <option value="60+" <?php echo $select60_plus;?>>60+</option> </select> <br/> Comments: <textarea name="comments" cols="20" rows="5"><?php echo $comments; ?></textarea> </fieldset> <input type="submit" name="submit" value="Submit my Information" /> </form> <?php }else{ echo "Thank you, ".$name." for your comments: " . "<strong>" . $comments . "</strong>"; echo "<br/>We will reply to you at:" . "<em>" . $email . "</em>"; } ?> </body> </html> </code></pre> <p>Here I did proper validation, and also re-fill the form when you submit with any empty field.<br/></p> <hr> <p>P.S. Thank you Marc B , I didn't realize that my first post was aweful.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POValidate Empty / Radio Fields - Php
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMash
UserOwnerUserId
1. USMash
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POValidate Empty / Radio Fields - Php
  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
  VTUndeletion
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
CommentsPostId
1. COThat'd be a highly inefficient method. If the entire form's sent unfilled, you'd only get one message per form submission as to what's wrong. "No name" [fill in name] "No email" [fill in email] etc... As well, you're not filling in the previous submitted values, so the user would have to start from scratch each time.
  singulars
  PostPostId
  PO
  UserUserId
  USMarc B

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.