Databázový wrapper

<?php
class MyDB {
    private static $options = array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    );
    private $db;
    private $dsn;

    function __construct($dsn) {
        $this->dsn = $dsn;
    }

    private function getDB() {
        if (!isset($this->db)) {
            $this->db = new PDO($this->dsn, NULL, NULL, self::$options);
        }
        return $this->db;
    }

    function query($sql) {
        try {
            return $this->getDB()->query($sql);
        } catch (PDOException $error) {
            die("Nastala chyba v dotazu: ".$error->getMessage());
        }
    }

    function prepare($sql) {
        try {
            return $this->getDB()->prepare($sql);
        } catch (PDOException $error) {
            die("Nastala chyba v dotazu: ".$error->getMessage());
        }
    }
}

$db = new MyDB('sqlite::memory:');

$db->query("CREATE TABLE users (username, password, email, reg_time, reg_ip)");

$insert = $db->prepare(
    "INSERT INTO users (username, password, email, reg_time, reg_ip)
        VALUES (:user, :pass, :email, :time, :ip)"
);
$data = array(
    ":user" => 'user',
    ":pass" => 'pass',
    ":email" => 'email',
    ":time" => 'reg_time',
    ":ip" => 'reg_ip',
);
$insert->execute($data);

$select = $db->prepare('SELECT * FROM users');
$select->execute();
while ($row = $select->fetch(PDO::FETCH_ASSOC)) {
    print_r($row);
}