<?php

/**
 * Description of dbClass
 *
 * @author fabi0
 * $sql = "SELECT * FROM `lang` WHERE id=:ID";
 * $params = array('ID' => '1');
 * dbClass::query($sql, $params)
 */
final class dbClass {

    private static $databaseInstance = NULL;

    private function __construct() {

    }

    public static function query($sql, $params = NULL) {
        if (mb_strlen($sql) == 0) {
            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) {
                if ($value['data_type'] == 'PDO::PARAM_INT') {
                    $sth->bindParam(':' . $key, $value['variable'], PDO::PARAM_INT);
                }
                if ($value['data_type'] == 'PDO::PARAM_STR') {
                    $sth->bindParam(':' . $key, $value['variable'], PDO::PARAM_STR);
                }
            }
        }
        $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;
    }

}