contoh pdo user

<?php
$dsn = 'mysql:dbname=testdb;host=127.0.0.1';
$user = 'dbuser';
$password = 'dbpass';

try
{
    $conn = new PDO($dsn, $user, $password);
}
catch(PDOException $e)
{
    echo 'Connection failed: ' . $e->getMessage();
}

$sql = "select * from user where username like ?";
$stmt = $dbh->prepare($sql);
$stmt->execute(array(
    $user
));
if (!$stmt)
{
    echo "\nPDO::errorInfo():\n";
    print_r($conn->errorInfo());
}
else
{
    $userku = $stmt->fetchAll();

}