<?php

class Database{
	private $localhost = 'localhost';
	private $username = 'root1';
	private $password = '';
	private $dbname = 'myblog';

	private $dbh;
	private $error;
	private $stmt;

	public function __construct(){

		$dsn = 'mysql:host='.$this->localhost . ';dbname='.$this->dbname;

		$options = array(
			PDO::ATTR_PERSISTENT  	=> true,
			PDO::ATTR_ERRMODE		=> PDO::ERRMODE_EXCEPTION
			);

		try{
			$this->dbh = new PDO($dsn, $this->username, $this->password, $options);

		}catch(Exception $e){
			$this->error = $e->getMessage();

		}
	}

	public function query($query){
		$this->stmt = $this->dbh->prepare($query);
	}

	public function bind($param, $value, $type = null){
		if(is_null($type))
		{
			switch(true){
				case is_int($value):
				$type = PDO::PARAM_INT;
				break;
				case is_bool($value):
				$type = PDO::PARAM_BOOL;
				break;
				case is_null($value):
				$type = PDO::PARAM_NULL;
				break;
				default:
				$type = PDO::PARAM_STR;
			}
		}
		$this->stmt->bindValue();
	}

	public function execute()
	{
		$this->stmt = $this->dbh->execute();
	}

	public function resultset()
	{
		$this->execute();
		return $this->stmt->fetchAll(PDO::FETCH_ASSOC);
	}
}


?>