<?php
class DriverMYSQL {
    private $host;
    private $user;
    private $pass;
    private $dbname;

    function __construct($host = 'localhost', $user = 'root', $pass  = '', $dbname  = 'tusupertienda') {
        $this->host = $host;
        $this->user = $user;
        $this->pass = $pass;
        $this->dbname = $dbname;
    }


    private function getLink(){
        try {
            $link = mysqli_connect($this->host,$this->user,$this->pass);
            mysqli_select_db($link, $this->dbname);
            mysqli_set_charset($link, "utf8");

            return $link;
        } catch (Exception $ex) {
            echo $ex->getTraceAsString();
        }
    }

    public function processQuery($query){
        try {
            $object = mysqli_query($this->getLink(), $query);
            if ($object == false || mysqli_num_rows($object) == 0) {
                return false;
            }
            return $object;
        } catch (Exception $ex) {
            echo $ex->getTraceAsString();
        }
    }

    public function insertQuery($query){
                try {
            $object = mysqli_query($this->getLink(), $query);
            return $object;
        } catch (Exception $ex) {
            echo $ex->getTraceAsString();
        }
    }

    public function getSingleColumnFromConsult($result){
        try{
            return mysqli_fetch_array($result);
        } catch (Exception $ex) {
            echo $ex->getTraceAsString();
        }
    }

    public function getArrayFromConsult($result){
        try {
            if (isset($result)) {
                if($result != false){
                    $row = mysqli_fetch_all($result,MYSQLI_ASSOC);
                    return $row;
                }else{
                    throw new Exception("Busqueda sin resultado");
                }
            }else{
                throw new Exception("Error desconocido");
            }
        } catch (Exception $ex) {
            echo $ex->getMessage();
        }
    }
}