Safe "WHERE … IN" SQL statement in PDO

gistfile1.php

<?php
$db = new PDO('mysql:host=hostname;dbname=defaultDbName', 
              'username', 'password', 
              array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

$names  = array('Alice', 'Bob', 'Charlie');
$values = array_map(array($db,'quote'),$names);
$query  = 'SELECT * FROM my_table WHERE name IN ('.join(',',$values).')';

$result = $db->query($query);

while($row = $result->fetch(PDO::FETCH_ASSOC)) {
  // ...
}
?>

See http://inanimatt.com/php-prepared-statements.php for explanation