如何使用WHERE使用pdo将内容插入到mysql中

Question

So I am trying to change the status of something when values are met using WHERE

Code:

$insertstatus = $DBH->prepare("INSERT INTO
   csvdata (status)  VALUES ('$status') WHERE username = '".$username."'");
        $insertstatus->execute();

Not working. If you could give me a hand.

Thank you for your time!

Answer 1

If you want to use the where clause, you need to use update. From the looks of it, you are trying to update anyhow as you are only using one column from your table.

$insertstatus = $DBH->prepare("update
   csvdata set status=  '$status' WHERE username = '".$username."'");
    $insertstatus->execute();

As PeeHaa correctly points out though, using a prepared statement with parameters would be a slight change in your code, and a better option for you. You can do it like this:

$sql="update csvdata set status=:status where username=:username";
$sth=$DBH->prepare($sql);
$sth->execute(array(':status' => $status, ':username' => $username));

This way you are preparing the statement so the database knows what will happen. You then pass the variables to the database via the execute() function in an array.