<?php

//
//	Class:		MySql.php
//	Author: 	Rob Hendriks
//	Version:	α 0.1
//

class MySQL
{
	private $MySQL_Hostname = NULL;
	private $MySQL_Username = NULL;
	private $MySQL_Password = NULL;
	private $MySQL_Database = NULL;
	
	private $MySQL_Conn_SQL = NULL;
	private $MySQL_Conn_DB = NULL;
	
	public function __construct($a, $b, $c, $d)
	{
		$this->MySQL_Hostname = $a;
		$this->MySQL_Username = $b;
		$this->MySQL_Password = $c;
		$this->MySQL_Database = $d;
		
		$this->Connect();
	}
	
	private function Connect()
	{
		$a = mysql_connect($this->MySQL_Hostname, $this->MySQL_Username, $this->MySQL_Password, false);
		$this->MySQL_Conn_SQL = $a;
		
		$b = mysql_select_db($this->MySQL_Database, $this->MySQL_Conn_SQL);
		$this->MySQL_Conn_DB = $b;
	}
	
	public function Insert($a, $b, $c)
	{
		$_table = $a;
		$_coll = $b;
		$_val = $c;
		
		$_coll_arr = explode(",", $_coll);
		$_coll_index = count($_coll_arr);
		
		$_val_arr = explode(",", $_val);
		$_val_index = count($_val_arr);
		
		$_colls = NULL;
		$_vals = NULL;
		
		$_sql = "INSERT INTO `%a` %b VALUES%c";
		
		$_old = array('%a');
		$_new = array($a);
		
		$_sql = str_replace($_old, $_new, $_sql);
		
		
		for($i = 0; $i < $_coll_index; $i++)
		{
			$_colls .= $_coll_arr[$i];
			$_vals .= "'".$_val_arr[$i]."'";
			
			if($i != $_coll_index -1) 
			{
				$_colls .= ",";
				$_vals .= ",";
			}
		}
		
		$_colls = ("(" .$_colls. ")");		
		$_vals = ("(" .$_vals. ")");
		
		$_old = array('%b','%c');
		$_new = array($_colls, $_vals);
		
		$_sql = str_replace($_old, $_new, $_sql);
		
		$_query = mysql_query($_sql);
	}
	
	public function Select($a, $b, $c)
	{
		if($a != "" && $b != "" && $c != "")
		{
			$_table = $a;
			$_where = $b;
			$_coll = $c;
			
			$_where_arr = explode(",", $_where);
			$_where_col = $_where_arr[0];
			$_where_index = $_where_arr[1];
			
			$_coll_arr = explode(",", $_coll);
			$_coll_index = count($_coll_arr);
			
			$_sql = "SELECT * FROM `%a` WHERE `%b` = '%c'";
			
			$_old = array('%a', '%b', '%c');
			$_new = array($a, $_where_col, $_where_index);
			
			$_sql = str_replace($_old, $_new, $_sql);
			$_query = mysql_query($_sql);
			
			$_result = NULL;
			
			while($_obj = mysql_fetch_object($_query))
			{
				for($i = 0; $i < $_coll_index; $i++)
				{
					$j = $_coll_arr[$i];
					$_var = $_obj->$j;
					$_result .= $_var;
					
					if($i != $_coll_index -1) $_result .= ",";
				}
			}
			
			$_result = explode(",", $_result);
			return $_result;
		}
		else
		{
			return NULL;
		}
	}
	
	public function Update($a, $b, $c, $d)
	{
		$_table = $a;
		$_where = $b;
		$_coll = $c;
		$_val = $d;
		
		$_where_arr = explode(",", $_where);
		$_where_col = $_where_arr[0];
		$_where_index = $_where_arr[1];
		
		$_coll_arr = explode(",", $_coll);
		$_coll_index = count($_coll_arr);
		
		$_val_arr = explode(",", $_val);
		$_val_index = count($_val_arr);
		
		$_sql = "UPDATE `%a` SET * WHERE `%c` = '%d'";
		
		$_old = array('%a', '%c', '%d');
		$_new = array($a, $_where_col, $_where_index);
		
		$_sql = str_replace($_old, $_new, $_sql);
		
		$_result = NULL;
		
		for($i = 0; $i < $_coll_index; $i++)
		{
			$_result .= "`".$_coll_arr[$i]."` = '".$_val_arr[$i]."'";
			if($i != $_coll_index -1) $_result .= ",";
		}
		
		$_old = array('*');
		$_new = array($_result);
		
		$_sql = str_replace($_old, $_new, $_sql);

		$_query = mysql_query($_sql);
	}
	
	public function Create($a)
	{
		$_name = $a;
		
		$_sql = "CREATE DATABASE %a";
		
		$_old = array('%a');
		$_new = array($_name);
		
		$_sql = str_replace($_old, $_new, $_sql);
		
		mysql_query($_sql);
	}
	
	public function Delete($a, $b)
	{
		$_table = $a;
		$_where = $b;
		
		$_where_arr = explode(",", $_where);
		$_where_col = $_where_arr[0];
		$_where_index = $_where_arr[1];
		
		$_sql = "DELETE FROM `%a` WHERE `%b` = '%c'";
		
		$_old = array('%a','%b','%c');
		$_new = array($_table, $_where_col, $_where_index);
		
		$_sql = str_replace($_old, $_new, $_sql);
		
		echo($_sql);	
		
		mysql_query($_sql);
	}
	
	public function RandomHash()
	{
		$a = ((rand(0, 100) * 2) / 3) * ((rand(100, 200) * 2) / 3);
		$b = ((rand(200, 300) * 2) / 3) * ((rand(300, 400) * 2) / 3);
		$c = $a * $b;
		$d = md5($c);

		return $d;
	}
	
	public function StringHash($a)
	{
		$b = md5($a);
		return $b;
	}
	
	public function isConnected()
	{
		if($this->MySQL_Conn_SQL)
		{
			return true;
		}
		return false;
	}
}

?>