php – 从表单输入数据到数据库PDO

我现在有正确的代码(我认为),但我无法弄清楚数据是如何输入的.正如您在我的代码中看到的那样,我让数据库在用户提交表单时创建行.但是,数据库只会在//插入行和//插入另一行的语音标记内找到任何内容.

例如,现在如果用户完成并提交表单,无论他们输入什么信息,我只会在我的数据库中显示“Joe”和“joe@example.com”等.显然我需要他们的答案,否则我的表格将是无关紧要的(数据提交也是如此).我完全错过了这个标记还是我错过了一些愚蠢的东西？我尝试过改变和研究,但我正在努力.对这一切真的很新.

形成：

<form action="testsubmit-pdo.php" method="post">
<label>Student Name :</label>
<input type="text" name="stu_name" id="name" required="required"       placeholder="Please Enter Name"/><br /><br />
<label>Student Email :</label>
<input type="email" name="stu_email" id="email" required="required" placeholder="john123@gmail.com"/><br/><br />
<label>Student City :</label>
<input type="text" name="stu_city" id="city" required="required" placeholder="Please Enter Your City"/><br/><br />
<input type="submit" value=" Submit " name="submit"/><br />
</form>

PHP：

try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname",$username,$password);

// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

// prepare sql and bind parameters
$stmt = $conn->prepare("INSERT INTO demo (stu_name,stu_email,stu_city)
VALUES (:stu_name,:stu_email,:stu_city)");
$stmt->bindParam(':stu_name',$stu_name);
$stmt->bindParam(':stu_email',$stu_email);
$stmt->bindParam(':stu_city',$stu_city);

// insert a row
$stu_name = "Joe";
$stu_email = "joe@example.com";
$stu_city = "Joeland";
$stmt->execute();

// insert another row
$stu_name = "Mary";
$stu_email = "mary@example.com";
$stu_city = "Maryland";
$stmt->execute();

echo "New records created successfully";
}
catch(PDOException $e)
{
echo "Error: " . $e->getMessage();
}
$conn = null;