php mysqli update query

Question

I have the following PHP script to update my DB, however, it doesn't work. The two echo's show in the UI that the variables are filled with the correct values. The query doesn't appear to be executed though. I don't get any errors whatsoever.

<?
    $rapportId = $_GET['variable1'];
    $rapportNaam = $_GET['variable2'];

    echo "rapportId = ". $rapportId;
    echo "<br>rapportNaam = ".$rapportNaam;     

    $mysqli = new mysqli("localhost", "twrwe", "twrewtww", "trwtw");

  $mysqli->query("Update Rapporten Set RapportNaam = $rapportNaam
                  Where RapportId = $rapportId
        ")or die(mysqli_error($db));
  $mysqli->commit();
    if ($mysqli->error) {
       printf("Errormessage: %s\n", $mysqli->error);
    }
  mysqli_free_result();
?>

Answer 1

You have to use '' for string data in the query as:

$mysqli->query("Update Rapporten 
Set RapportNaam = '$rapportNaam'
Where RapportId = $rapportId
") ;

Looking for a SQL Tutorial? Join the Intellipaat's SQL Course now to gain more knowledge on SQL.