StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POthe form value can't input to mysql, but can connect mysql (PHP)
primarykey
Id
15919732
data
AcceptedAnswerId
0
AnswerCount
4
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-04-10T07:37:24.237
FavoriteCount
0
LastActivityDate
2013-04-10T08:52:45.633
LastEditDate
LastEditorUserId
0
OwnerUserId
2218999
ParentId
0
PostTypeId
1
Score
1
ViewCount
177
LastEditorDisplayName
text
Body
<p>I want to diy a php quiz, when you have full grade, you may input your information to my database, but when I have filled the form and put the sumbit. Have this error~</p> <p>Notice: Undefined index: firstname in C:\xampp\htdocs\record.php on line 19</p> <p>Notice: Undefined index: lastname in C:\xampp\htdocs\record.php on line 19</p> <p>Notice: Undefined index: age in C:\xampp\htdocs\record.php on line 19 mysql_connect.inc.php</p> <pre><code><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php //資料庫設定 //資料庫位置 $db_server = "localhost"; //資料庫名稱 $db_name = "quiz"; //資料庫管理者帳號 $db_user = "root"; //資料庫管理者密碼 $db_passwd = "123456"; //對資料庫連線 if(!@mysql_connect($db_server, $db_user, $db_passwd)) die("can't connect mysql"); //資料庫連線採UTF8 mysql_query("SET NAMES utf8"); //選擇資料庫 if(!@mysql_select_db($db_name)) die("can't connect db"); ?> </code></pre> <p>record.php</p> <pre><code><?php ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php session_start(); include("mysql_connect.inc.php"); $con = mysql_connect("localhost","root","123456"); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter', 'Griffin', '35')"); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')"); $sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$_POST[firstname]','$_POST[lastname]','$_POST[age]')"; mysql_close($con) ?> </code></pre> <p>process.php</p> <pre><code><html> <head> <style type="text/css"> #wrapper { width:950px; height:auto; padding: 13px; margin-right:auto; margin-left:auto; background-color:#fff; } </style> </head> <?php $fid = $_GET['id']; ?> <body bgcolor="#e1e1e1"> <div id="wrapper"> <center><font face="Andalus" size="5">Your Score</font></center> <br /> <br /> <?php $answer1= $_POST['answerOne']; $answer2= $_POST['answerTwo']; $answer3= $_POST['answerThree']; $score = 0; if ($answer1 == "A"){$score++;} if ($answer2 == "B"){$score++;} if ($answer3 == "C"){$score++;} echo "<center><font face='Berlin Sans FB' size='8'>Your Score is <br> $score/3</font></center>"; ?> <br> <br> <Center> <?php if ($score == 3) { echo " <form action='record.php' method='post' > ID: <input type='text' id='firstname'/><br> Phone: <input type='text' id='lastname'/><br> E-mail: <input type='text' id='age'/><br><br> <input type='submit' value='Submit Data' /> </form> "; } ?> </Center> </div> </body> </html> </code></pre>
Tags
<php><mysql><forms>
Title
the form value can't input to mysql, but can connect mysql (PHP)
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDante Man
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POthe form value can't input to mysql, but can connect mysql (PHP)
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COFollow it. http://stackoverflow.com/questions/15785519/variables-occasionally-empty-how-to-prevent-undefined-variable-error/15785579#15785579
  singulars
  PostPostId
  POthe form value can't input to mysql, but can connect mysql (PHP)
  UserUserId
  USDieepak

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.