PHP MySQL Update Query无法使用vars

Question

$ID = trim($_GET["uid"]);
$Name = trim($_GET["name"]);

$result = $mysqli->query("UPDATE `Benutzer` SET `R_NAME`='$Name' WHERE `ID` = '$ID'");

The Result returns fine, but the Database is not updated. If I replace the vars with static values the Database IS updated.

Answer 1

Follow these steps:

1. Remove "trim" & use "mysql_escape_string".
2. Echo Check the values of Name & ID. Once you are getting them then follow up with the 3rd step.

3. Concatinate the sql string as shown by removing the tild operators:

   $result = $mysqli->query("UPDATE Benutzer SET R_NAME ='".$Name."' WHERE ID = '".$ID."'");