php - 如何使用 PHP 更新 MYSQL PDO 中获取列的值

Question

如何更新我为 MySQL PDO 提取和选择的列中的值。我现在的代码。

    if ($submitcode != $dbcode)
  {
  $SQL = $odb -> prepare("SELECT `status` FROM `members` WHERE `username` = :username");
  $SQL -> execute(array(':username' => $username));
  $status = $SQL -> fetchColumn(0) // ((I want this selected column for status value to change to 1.))
  die('Some error message');
  }

Answer 1

if ($submitcode != $dbcode)
{
$sql = "UPDATE `members` SET `status` = :status WHERE `username` = :username";

//Prepare UPDATE SQL statement.
$statement = $odb->prepare($sql);

$status = 1;

$statement->bindValue(':username', $username);
$statement->bindValue(':status', $status);

//Execute UPDATE statement.
$update = $statement->execute();

}