确保在提交表单时正在执行正确的SQL查询语句。以下是可能的
以下是一个PHP代码示例,演示如何更新MySQL表:
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (isset($_POST["submit"])) {
$name = $_POST["name"];
$email = $_POST["email"];
$phone = $_POST["phone"];
$sql = "UPDATE users SET name='{$name}', email='{$email}', phone='{$phone}' WHERE id='{$_GET['id']}'";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
$conn->close();
}
?>