我已经创建了HTML表单，单击提交按钮后，所有值都存储在MySQL数据库中。
我想创建编辑表单的功能。我正在考虑单击后Edit按钮表单应该与新表单完全相同，只是所有已插入数据库的填充值。
我怎样才能做到这一点？我想有点像将带有值的HTML代码存储到数据库（从<form>到</form>），但我不知道这是否是好主意，并且完全可能。
我的真实表单有 100 多个字段，但简化后看起来像：
网页表单：
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Record Form</title>
</head>
<body>
<form action="insert.php" method="post">
<p>
<label for="firstName">First Name:</label>
<input type="text" name="firstname" id="firstName">
</p>
<p>
<label for="lastName">Last Name:</label>
<input type="text" name="lastname" id="lastName">
</p>
<p>
<label for="emailAddress">Email Address:</label>
<input type="text" name="email" id="emailAddress">
</p>
<input type="submit" value="Submit">
</form>
</body>
</html>
要插入到数据库的 PHP 代码：
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "demo");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$first_name = mysqli_real_escape_string($link, $_POST['firstname']);
$last_name = mysqli_real_escape_string($link, $_POST['lastname']);
$email_address = mysqli_real_escape_string($link, $_POST['email']);
// attempt insert query execution
$sql = "INSERT INTO persons (first_name, last_name, email_address) VALUES ('$first_name', '$last_name', '$email_address')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
?>
您可以通过查询数据库中的所有值来实现这一点：
$result = mysqli_query($link, "SELECT * from persons WHERE UserId = '$UserId'");
while ($row = mysqli_fetch_assoc($result)) {
$first_name = $row['first_name']);
$last_name = $row['last_name']);
$email_address = $row['email_address']);
}
mysqli_close($link);
然后在 value 属性中echo：
<label for="firstName">First Name:</label>
<input type="text" name="firstname" id="firstName" value=<?php echo $first_name ?>">
<label for="lastName">Last Name:</label>
<input type="text" name="lastname" id="lastName" value=<?php echo $last_name ?>">
<label for="emailAddress">Email Address:</label>
<input type="text" name="email" id="emailAddress" value=<?php echo $email_address ?>">