<?php

/**
 * Description of dbClass
 *
 * @author fabi0
 */
final class dbClass {

    private static $databaseInstance = NULL;

    private function __construct() {

    }

    public static function query($sql, $params = NULL) {
        if (!isset($sql)) {
            throw new Exception('Empty SQL string.');
        }
        $return = array();
        if (!is_object(self::$databaseInstance)) {
            self::setInstance();
        }
        $sth = self::$databaseInstance->prepare($sql);
        if (is_array($params)) {
            foreach ($params as $key => $value) {
                $sth->bindParam(':' . $key, $value);
            }
        }
        $sth->execute();
        while ($result = $sth->fetch(PDO::FETCH_ASSOC)) {
            $return[] = $result;
        }
        return $return;
    }

    private function setInstance() {
        if (!is_object(self::$databaseInstance)) {
            self::$databaseInstance = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8', DB_USER, DB_PASSWORD);
            self::$databaseInstance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }
    }

    public static function getInstance() {
        return self::$databaseInstance;
    }

}