<?php

class Mysql{

	protected $conn;

	public function __construct($dbhost, $dbuser, $dbpass, $dbname){
		$this->conn = mysql_connect($dbhost, $dbuser, $dbpass, 1);
		if(!$this->conn){
			die('Could not connect: ' . mysql_error());
		}
		mysql_select_db($dbname, $this->conn);
	}

	public function query($sql){
		$query = mysql_query($sql, $this->conn);
		return $query;
	}

	public function find($sql){
		$obj = mysql_fetch_object($this->query($sql));
		return $obj;
	}

	public function findall($sql){
		$array = [];
		$query = $this->query($sql);
		while($rs = mysql_fetch_object($query)){
			$array[] = $rs;
		}
		return $array;
	}

	public function get($sql){
		$result = @mysql_result($this->query($sql), 0);
		return $result;
	}

	public function getall($sql){
		$array = [];
		$query = $this->query($sql);
		while($rs = mysql_fetch_row($query)){
			$array[] = $rs[0];
		}
		return $array;
	}

	public function insert_id(){
		return mysql_insert_id($this->conn);
	}

	public function close(){
		return mysql_close($this->conn);
	}

}