<?php
$user = 'phpuser';
$pass = 'phppass';

try {
  $dbh = new PDO('mysql:host=localhost;dbname=mydb', $user, $pass);

  foreach ($dbh->query('SELECT * FROM test') as $row) {
    print_r($row);
  }
  $dbh = null;
} catch (PDOException $e) {
  print "error " . $e->getMessage() . "<br />";
  die();
}