execute()只要您可以将值视为
PDO::PARAM_STR(字符串),就可以始终将其绑定在参数中。
$result_set = $pdo->prepare("INSERT INTO `users` (`username`, `password`, `first_name`, `last_name`) VALUES (:username, :password, :first_name, :last_name)");$result_set->execute(array( ':username' => '~user', ':password' => '~pass', ':first_name' => '~John', ':last_name' => '~Doe'));您可以像任何数组一样使用传递的数组:
$user = "Nile";$pdo->execute(array(":user" => $user));


