StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12032763
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-08-20T05:45:39.977
FavoriteCount
0
LastActivityDate
2012-08-20T05:59:02.743
LastEditDate
2012-08-20T05:59:02.743
LastEditorUserId
1599551
OwnerUserId
1599551
ParentId
12032352
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Mind you, this is just something quick I typed up in about 10 mins, so I'm sure there is a better way to do this, but, it gets the job done.</p> <p>PHP:</p> <pre><code>if(isset($_POST['submit'])) { $to = "test@websitehere.com"; $subject = "Form Tutorial"; $name_field = $_POST['name']; $email_field = $_POST['email']; $order = array(); foreach($_POST['item'] as $item => $name) { if ($_POST['quantity_'.$name] > 0) { $add_order = array('pretty'=>$_POST['pretty-name_'.$name],'qty'=>$_POST['quantity_'.$name],'message'=>$_POST['message_'.$name]); array_push($order,$add_order); } } $body = "From: $name_field\nE-Mail: $email_field\n"; $body .= "Their Order:\n"; foreach ($order as $item){ $body .= "--".$item['qty']."x ".$item['pretty']."\n Extra: ".$item['message']."\n\n"; } echo "Data has been submitted to $to!"; mail($to, $subject, $body); } </code></pre> <p>HTML:</p> <pre><code><form action="test.php" method="post"> <div class ="item_left"> Mexican Torta - $8.50<input name="item[]" type="hidden" value="torta"/> <input name="pretty-name_torta" type="hidden" value="Mexican Torta"/><br> How Many? <input name="quantity_torta" type="text" /><br> <input name="message_torta" type="text" value="Enter special order instructions here..." /> </div> <br /> <div class ="item_center"> Fish Sandwich - $8.50<input name="item[]" type="hidden" value="fish"/> <input name="pretty-name_fish" type="hidden" value="Fish Sandwhich"/><br> How Many? <input name="quantity_fish" type="text" /><br> <input name="message_fish" type="text" value="Enter special order instructions here..." /> </div> <br /> <div class ="item_right"> Hamburger w/ Fries - $7.00<input name="item[]" type="hidden" value="hamburger"/> <input name="pretty-name_hamburger" type="hidden" value="Hamburger"/><br> How Many? <input name="quantity_hamburger" type="text" /><br> <input name="message_hamburger" type="text" value="Enter special order instructions here..." /> </div> <br /><br /> <input type="submit" name="submit" value="Order" /> </form> </code></pre> <p>OUTPUT: (Similar to)</p> <pre><code>Their Order: --22x Mexican Torta Extra: Enter special order instructions here... --1x Fish Sandwhich Extra: Lots of stuff --2x Hamburger Extra: Mmmm Fries </code></pre> <p>Jared is right. You need to have a way to distinguish between the different items. Hence why I added a extra hidden input in there.</p> <p>Long story short, Every item gets put into an array. PHP goes through this array and picks out what has a quantity value greater than 0. If it has, add that items info into a second array. The last half of this, goes through that new array, and makes it look all nice and pretty for you.</p> <p>If you need me to clarify or fix anything, lemme know.</p> <p>EDIT: Went ahead and added it into the mail function (boredom).</p> <p>PS: I noticed you were using unsanitized varables. I probably shouldn't need to, but I will say it anyways. Make sure you are checking and cleaning user input before you do much with it. Probably not that big of a deal here, but it could still turn bad in certain situations.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSending PHP Form Data
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USOberst
UserOwnerUserId
1. USOberst
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.