WHERE clause confusion with PDO

Question

I'm having some trouble understanding how to use prepared statements, when you need to match one value against several columns at once.

In other words what instead of doing this:

$stmt = $dbh->prepare("SELECT * FROM REGISTRY where name = ?");
$stmt->bindParam(1, $name); 

I wanted to do this:

$stmt = $dbh->prepare("SELECT * FROM REGISTRY where firstname = ? or lastname = ?");

with both '?' representing the same string.

Answer 1

Try...

$stmt = $dbh->prepare("SELECT * FROM REGISTRY where firstname = :name or lastname = :name"); $stmt->bindParam(':name', $name);

Answer 2

Why not just use a named parameter:

$stmt = $dbh->prepare("SELECT * FROM REGISTRY WHERE firstname = :name OR lastname = :name");
$stmt->bindParam(':name', $name);