使用 SQL 查询更新用户信息 - Updating User Information using SQL query

Updating User Information using SQL query

更新的代码，键入信息并单击提交按钮以运行此代码后，它将返回到帐户页面，但不更新数据库：

<font face="ClearSans-Thin">
<font color="lightgray">
<?php
include 'editaccount.php';
include 'connection.php';
?>
<center>
<?php
if (isset($_POST['uregsubmit'])) {
    $firstname = $_POST['ufirstname'];
    $lastname = $_POST['ulastname'];
    $email = $_POST['uemail'];
    $dob = $_POST['udob'];
    $user = $_POST['uregisterusername'];
    $pass = $_POST['uregisterpassword'];
    }
    //the query
$query = "UPDATE Users SET FirstName='$firstname', LastName='$lastname' WHERE Username='$user'";
//execute the query
$result = mysqli_query($connection, $query)
or die("Error: ".mysqli_error($connection));
//check and see if any data returned


?>
</center>

在 if 语句中编写 sql 查询

<?php
if (isset($_POST['uregsubmit'])) {
    $firstname = $_POST['ufirstname'];
    $lastname = $_POST['ulastname'];
    $email = $_POST['uemail'];
    $dob = $_POST['udob'];
    $user = $_POST['uregisterusername'];
    $pass = $_POST['uregisterpassword'];
    //the query
    $query = "UPDATE Users SET FirstName='$firstname', LastName='$lastname' WHERE Username='$user'";
    //execute the query
    $result = mysqli_query($connection, $query)
    or die("Error: ".mysqli_error($connection));
    //check and see if any data returned
}
?>

你在 WHERE 之前有一个额外的逗号