<?php
class database {
    private $dbConnection;

    public function __construct($dbhost, $dbname, $dbuser, $dbpass) {
        try {
            $this->dbConnection=new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
        } catch (PDOException $e) {
            return FALSE;
        }
    }

    public function ping() {
        if($this->dbConnection==NULL) return FALSE;
        if($this->dbConnection->getAttribute(PDO::ATTR_CONNECTION_STATUS)) return TRUE; else return FALSE;
    }

    public function dbQuery($query) {
        $this->ping();
        $results=$this->dbConnection->query($query);
        return $results->fetchAll(PDO::FETCH_ASSOC);
    }

    public function dbParamQuery($query, $params=NULL) {
        $trans=$this->dbConnection->prepare($query);
        if(!is_null($params)) {
            foreach($params as $key=>$value) {
                if(!is_int($key)) {
                    $trans->bindValue($key, $value);
                } else {
                    $trans->bindValue(($key+1), $value);
                }
            }
        }
        if(!$trans->execute()) return FALSE;
        return $trans->fetchAll(PDO::FETCH_ASSOC);
    }
}
?>