我正在尝试使用 html 和 php 更新数据库中的条目。但是,我不断收到错误消息,说我的 sql 语法错误。
这是php文件中的代码:
<?php
$server = "127.0.0.1";
$dbUsername = "root";
$dbPassword = "";
//create connection
$dbconn = new mysqli($server, $dbUsername, $dbPassword, $dbname);
$email_follow = $_POST['email_follow'];
$follow = $_POST['follow'];
$update = mysqli_query($dbconn, "UPDATE CustomerDetails SET Follow Up = '$follow' WHERE Email = '$email_follow'");
if ($dbconn->query($update) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $dbconn->error;
}
?>
这是html表单:
<form action="cust_details_followup.php" method="post">
Email:
<input type="email" name="email_follow" id="email_follow">
Enter Follow Up Details:
<input type="text" name="follow" id="follow">
<input type="submit" value="Update">
</form>
任何帮助表示赞赏。谢谢!
你的表属性Follow Up
有一个空格,你需要添加`来包装它
所以改变
UPDATE CustomerDetails SET Follow Up = '$follow' WHERE Email = '$email_follow'
至
UPDATE CustomerDetails SET `Follow Up` = '$follow' WHERE Email = '$email_follow'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句