mou

echo "<meta charset=utf-8>";
$dsn = 'mysql:host=localhost;bdname=bd_demon;charset=UTF8';
$user = 'DemoN';
$password = '123';
$name = 'Vasya';
try{
    $PDO = new PDO($dsn, $user, $password);
    $stmt = $PDO->prepare("SELECT * FROM users where name = ?");
    if ($stmt->execute(array($name))){
      while ($row = $stmt->fetch()) {
        print_r($row);
      }
    }
} catch (PDOException $e) {
    echo 'Подключение не удалось: ' . $e->getMessage();
}