StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POInputting two or more values to the database simultaneously
primarykey
Id
15159143
data
AcceptedAnswerId
15160626
AnswerCount
1
ClosedDate
2013-03-02T00:56:24.150
CommentCount
5
CommunityOwnedDate
CreationDate
2013-03-01T13:39:13.757
FavoriteCount
0
LastActivityDate
2013-03-03T07:40:57.260
LastEditDate
2013-03-03T07:40:57.260
LastEditorUserId
472495
OwnerUserId
1930357
ParentId
0
PostTypeId
1
Score
0
ViewCount
1432
LastEditorDisplayName
text
Body
<p>I'm new with PHP, am I doing this right? The function of the code below will put the 2 values inside the database simultaneously. Once I input the values in the 2 text boxes, only the value in the first textbox is stored into the database. How can I store these two values into database with one form?</p> <p><strong>add.php</strong></p> <pre><code> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_database", $con); mysql_close($con); ?> <html> <body> <form action="insert.php" method="post" name="form1"> Firstname: <input type="text" name="firstname" /> Firstname1: <input type="text" name="firstname" /> Age: <input type="text" name="age" /> <input type="submit" name="form1" /> </form> </body> </html> </code></pre> <p><strong>insert.php</strong> </p> <pre><code> <html> <head> <title>Record Added</title> <meta http-equiv="refresh" content="0;url=select.php"> </head> <body> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_database", $con); $sql="INSERT INTO biodata (FirstName) VALUES ('$_POST[firstname]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con); ?> <a href="select.php"> see</a> </body> </html> </code></pre> <p><strong>select.php</strong></p> <pre><code> <?php $dbHost = 'localhost'; $dbUser = 'root'; $dbPass = ''; $dbName = 'my_database'; $dbConn = mysql_connect ($dbHost,$dbUser, $dbPass) or die ('MySQL connect failed. ' . mysql_error()); mysql_select_db($dbName) or die('Cannot select database. ' . mysql_error()); ?> <html> <head> <title>Display</title> </head> <table align="center" border=1> <tr> <th> First Name</th> <th>Last Name </th> <th> Age </th> </tr> <?php $query = "SELECT * FROM biodata"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)){ ?> <tr><td><?php echo $row['FirstName'];?></td> </tr> <?php }?> </table> </body> </html> </code></pre>
Tags
<php><mysql>
Title
Inputting two or more values to the database simultaneously
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UShalfer
UserOwnerUserId
1. USMiggy
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

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.