<?php
if(!defined('TASK')){
	die();
}
class Database{

	public $isConnect;
	protected $datab;
	private $dbHost ='localhost';
	private $dbPort ='3306';
	private $dbUser = 'root';
	private $dbPass = '';
	private $dbName = 'tasks';

	public function __construct(){
		$this->isConnect = true;
		try {
			$this->datab = new PDO("mysql:host={$this->dbHost};port={$this->dbPort};dbname={$this->dbName};charset=utf8",$this->dbUser,$this->dbPass, $opitons = null);
			$this->datab->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$this->datab->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
		} catch (PDOException $e) {
			//throw new PDOException($e->getMessages());
			echo '<p> Не получилось подключиться к базе данных!</p>';
			die();
		}
	}

	public function getRow($query, $params = []){
		try {
			$stmt = $this->datab->prepare($query);
			$stmt -> execute($params);
			return $stmt->fetch();
		} catch (PDOException $e) {
			//throw new PDOException($e->getMessages());
			return false;
		}
	}
	public function getRows($query, $params = []){
		try {
			$stmt = $this->datab->prepare($query);
			$stmt -> execute($params);
			return $stmt->fetchAll();
		} catch (PDOException $e) {
			//throw new PDOException($e->getMessages());
			return false;
		}
	}
	public function insertRow($query, $params = []){
		try {
			$stmt = $this->datab->prepare($query);
			$stmt -> execute($params);
			return true;
		} catch (PDOException $e) {
			///throw new Exception($e->getMessages());
			return false;
		}
	}
}