Exemplo PDO

<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);

try {

    $dsn = "mysql:dbname=bacula;host=localhost;charset=utf8;";
    $dbuser = "root";
    $dbpass = "";

    $options = array (
        PDO::ATTR_CASE => PDO::CASE_LOWER,
        PDO::ATTR_ERRMODE    => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_PERSISTENT => true
    );

    $pdo = new PDO($dsn, $dbuser, $dbpass, $options);

    $stmt = $pdo->query("select * from client");
    $stmt->execute();

    while($row = $stmt->fetch(PDO::FETCH_BOTH)){
      echo $row->name . "\n";
    }

} catch (PDOException $e){
    echo "(". $e->getCode() . ") " .$e->getMessage() . " at line: " . $e->getLine();
}