StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP form (values disappearing, dont know how it is being processed)
primarykey
Id
8052529
data
AcceptedAnswerId
8052583
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-08T15:06:51.523
FavoriteCount
0
LastActivityDate
2011-11-08T18:50:35.917
LastEditDate
2011-11-08T18:45:16.303
LastEditorUserId
975286
OwnerUserId
975286
ParentId
0
PostTypeId
1
Score
0
ViewCount
526
LastEditorDisplayName
text
Body
<p>I'm a complete newbee in php (started just last week)</p> <p>Issue is like this:</p> <p>Basically, I was trying to ensure that once a sub-form is filled, then it is not altered. So, I used !isset to display the sub-form (i.e. if !isset is true) and if !isset is false, then it hides that sub-form and shows the next sub-form (the individuals form has only been designed).</p> <pre><code> <?php include($_SERVER['DOCUMENT_ROOT'].'/officespace/includes/functions.php'); echo'<html> <head> <title> Create </title> </head> <body>'; if(!isset($_POST["Category"])){ /* if no category is selected, then this code will display the form to select the category*/ Echo "Pls Select Category before clicking on Submit Category"; /* Breaking out of PHP here, to make the form sticky by using a php code inside form action*/ ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <fieldset> <legend>Select the Category of Person: </legend><br /> <input type="radio" name="Category" value="Individual" /> Individual<br /><br /> <input type="radio" name="Category" value="Company, Pvt Ltd" /> Company, Pvt Ltd<br /><br /> <input type="radio" name="Category" value="Company, Ltd" /> Company, Ltd<br /><br /> <input type="radio" name="Category" value="Partnership Firm" /> Partnership Firm<br /><br /> <input type="radio" name="Category" value="LLP Firm" /> LLP Firm<br /><br /> <input type="radio" name="Category" value="HUF" /> HUF<br /><br /> <input type="submit" name='Submit Category' value="Submit Category" /><br /> </fieldset> </form> <?php } Else { $Category = $_POST["Category"]; Echo "$Category"; Echo "<br />"; /* Using swich statement to test the value of Category, and accordingly echo appropriate forms*/ switch ($Category) { case "Individual": if(!isset($_POST['Submit_Data_for_Individual'])){ //if no data for individual is submitted, //then this code will display the form to enter and submit data for Individual Echo /*displays message*/ "Pls Enter the Data for the Individual"; ?> <form action="<?php Echo $_SERVER['PHP_SELF']; ?>" method="post"> <fieldset> <br /> First Namee: <input type="text" name="Individual_First_Name" /> <br /> Middle Name: <input type="text" name="Individual_Middle_Name" /> <br /> Last Name: <input type="text" name="Individual_Last_Name" /> <br /> Date of Birth: <input type="text" name="date_of_birth/incorporation" /> <br /> Gender: <br /> <input type="radio" name="Gender" value="male" /> Male <br /> <input type="radio" name="Gender" value="female" /> Female <br /> Email 1: <input type="text" name="email_1" /> <br /> <input type="submit" name="Submit_Data_for_Individual" value="Submit Data for Individual" /> </fieldset> </form> <?php }Else { $email_1 = $_POST["email_1"]; $Gender = $_POST["Gender"]; validate_email($email_1); // this is a custom function which i made Echo $Gender; // just to see if value has been passes. problem lies here because its not showing anything // run other validations here // and if all valid then run mysqli insert query for individuals record } break; case "Company, Pvt Ltd": echo "Company, Pvt Ltd"; break; case "Company, Ltd": echo "Company, Ltd"; break; case "Company, Ltd": echo "Company, Ltd"; break; case "Partnership Firm": echo "Partnership Firm"; break; case "LLP Firm": echo "LLP Firm"; break; case "HUF": echo "HUF"; break; case NULL: echo "Error: nothing selected"; break; } } echo '</body> </html>'; ?> </code></pre>
Tags
<php>
Title
PHP form (values disappearing, dont know how it is being processed)
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USChinmay Kamat
UserOwnerUserId
1. USChinmay Kamat
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. PO
  singulars
  PostTypePostTypeId
  PTAnswer
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.