PDO准备语句：替换列的值

Question

How do you use prepared statements and bound parameters to replace a value in a column? For example,

$stmt = "UPDATE users SET name = :name
    WHERE name = :name";

$stmt->bindParam(:name, $oldName);
$stmt->bindParam(:name, $newName);
$stmt->execute();

Answer 1

You can't use same named bind parameters within prepare statement your parameters name must be unique as

$stmt = $connection->prepare("UPDATE users SET name = :newName
    WHERE name = :oldName");

$stmt->bindParam(':oldName', $oldName);
$stmt->bindParam(':newName', $newName);