<?php
class Database {
    private $_handler;
 	public function __construct($host = "localhost", $username = "root", $password = "gKdu5bY9", $database = "usersuse")
    {
 		try {
			$this->_handler = new PDO('mysql:host=' . $host . ';dbname=' . $database, $username, $password);
 			$this->_handler->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
 		}
 		catch (Exception $e) {
			throw new Exception('Database connection error :' . $e->getMessage());
 		}
 	}

 	private function query($sql, ...$args)
    {
		$request = $this->_handler->prepare($sql);
 		if($request ==! false) {
 			if($request->execute($args))
			{
 				$resultArray = $request->fetchAll(PDO::FETCH_ASSOC);
 				$request->closeCursor();
 				return $resultArray;
			}
			else {
                echo 'Request failed :' . $sql;

 				return null;
			}
 		} else {
                echo 'Wrong request :' . $sql;
 			return null;
 		}
 	}

 	private function execute($sql, ...$args)
 	{
 		$request = $this->_handler->prepare($sql);
 		if($request ==! false) {
 			if($request->execute($args))
			{
                $this->_rowCount = $request->rowCount();
 				return true;
			}
			else {
                echo 'Request failed :' . $sql;
                var_dump($request->errorInfo());
 				return false;
			}
 		} else {
            echo 'Wrong request :' . $sql;
 			return false;
 		}
 	}

    public function getLastInsertId()
    {
        return $this->_handler->lastInsertId();
    }