<?php

class db {

    protected $host = "localhost";
    protected $dbname = "dbtest";
    protected $user = "root";
    protected $pass = "XXXXXXX";

    function execute($query, $parameters, $usefetch) {

        $dsn = "mysql:host=$this->host;dbname=$this->dbname";
        $pdo = new PDO($dsn,$this->user,$this->pass);

        $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        try {
            $statement = $pdo->prepare($query);
            $statement->execute($parameters);

            if($usefetch) {
                $result = $statement->fetchAll(PDO::FETCH_ASSOC);
                return $result;
            } else {
                return "SUCCESS";
            }
        }

    catch(PDOException $ex) { return $ex; }

    }

    function __get($var) {
        return $this->$var;
    }

}