带有$ var数据的SQL Update列

$newCity = $_POST['city'];

$set = mysqli_query($con, "UPDATE users SET city = '$newCity' WHERE username = '$theUser'");

I'm trying to update mySql column through UPDATE using a value of a variable. But when I check the value, it updates, but once I refresh the execute, it changes the value to NULL

Edit: $theUser = a working session username

Try:

if(isset($_POST['city'])){
 $newCity = $_POST['city'];
 $set = mysqli_query($con, "UPDATE users SET city = '$newCity' WHERE username = '$theUser'");
}

Also please try to filter your user input before passing it to query.

if(isset($_POST['city'])){
   $newCity = mysqli_real_escape_string($_POST['city']);
   $theUser = mysqli_real_escape_string($userUser); // assuming you haven't escaped it already.
   $query = "UPDATE users SET city = '$newCity' WHERE username = '$theUser'";
   $set = mysqli_query($con, $query);
}