<?php

	class sqldatabase {

		private $databaseHost;
		private $databaseName;
		private $databaseUser;
		private $databasePassword;

		public $query;

		public function __construct($databaseHost='', $databaseName='', $databaseUser='', $databasePassword='') {

			$this->databaseHost = $databaseHost;
			$this->databaseName = $databaseName;
			$this->databaseUser = $databaseUser;
			$this->databasePassword = $databasePassword;

			if ($this->databaseName != '' and $this->databaseUser != '' and $this->databasePassword != '') {

				$this->connect();

			}

		}

		private function connect() {

			mysql_connect ($this->databaseHost, $this->databaseUser, $this->databasePassword); // Login to the Database
			mysql_select_db ($this->databaseName);

		}

		public function makesafe($variable) {

			$variable = htmlspecialchars( $variable, ENT_QUOTES );

				if( get_magic_quotes_gpc(   ) ) {

					$variable = stripslashes( $variable );

				}

			$variable = str_replace( "\"", "", $variable );
			//$variable = htmlentities( $variable );
			$variable = mysql_real_escape_string( $variable );

			return $variable;

		}
		public function query( $query ) {

			$query = mysql_query($query);
			$this->query = $query;
		}

		public function fetch ($query='') {

			if ($query == '') {

				$query = $this->query;

			} else {

				$query = mysql_query($query);
				$this->query = $query;

			}

			$result = mysql_fetch_object($query);
			return $result;

		}

		public function fetchAll ($query='') {

			if ($query == '') {

				$query = $this->query;

			} else {

				$query = mysql_query($query);

			}

			while ($result = mysql_fetch_object($query)) {

				$fetch[] = $result;

			}

			unset($this->query);

			return $this->array_to_object($fetch);


		}

		public function count($query='') {

			if ($query == '') {

				$result = mysql_num_rows($this->query);

			} else {

				$query = mysql_query($query);
				$result = mysql_num_rows($query);
			}

			return $result;

		}

		public function array_to_object($array = array()) {

			if (is_array($array)) {

			    if (!empty($array)) {

					$data = false;

		    	    foreach ($array as $akey => $aval) {

						$data -> {$akey} = $aval;

        			}

       				return $data;

			    }

			} else {

				return $array;

			}

		}

		public function getColumnType ($table, $column) {

  		    $query = mysql_query("SELECT $column FROM $table");

   			if (!$query) {

				return false;

			}

      		$field = mysql_field_type($query, 0);

			if (!$field) {

				mysql_free_result($field);
				return false;

   			}

			mysql_free_result($query);
    		return $field;

		}

		public function insert ( $table, $array='' ) {

			if ($array == '') {

				$query = $table;
				$query = mysql_query ( $query );

					$id = mysql_insert_id();

					if ($id == 0) {

						return true;

					} else {

						return $id;

					}

			} else {

				if (is_array($array)) {

					if (empty($array)) {

						return false;

					} else {

						$cols = '(';
						$values = '(';

	   					foreach ($array as $key=>$value) {     // iterate values to input

					        $cols .= "`$key`, ";
						 	$values .= "'$value', ";

						}


						$cols = rtrim($cols, ', ').')';
						$values = rtrim($values, ', ').')';
					    $query = $this->insert("INSERT INTO `$table` $cols VALUES $values");
						return $query;

					}


				} else {

					return false;

				}

			}

		}

		public function delete ($table, $column, $value='') {

		if ($value == '' and is_array($column) == true) {

			foreach ($column as $key => $value) {

				$by  .= "`$key` = '$value' and ";

			}

			$by = rtrim($by, ' and ');

			$query = mysql_query("DELETE FROM `$table` where $by");


		} else {

			$query = mysql_query("DELETE FROM `$table` where `$column` = '$value'");

			if (!$query) {

				return false;

			}

			return true;

		}

		}

		public function update ($table, $where, $wvalue, $array='') {

			if (is_array($array)) {

				if (empty($array)) {

					return false;

				} else {
	   				foreach ($array as $key=>$value) {     // iterate values to input

					 	$values .= "`$key` = '$value', ";
					}


					$values = rtrim($values, ', ');
				    $query = mysql_query("UPDATE `$table` SET $values WHERE `$where` = '$wvalue'");
					return $query;

				}

			}

		}

		public function updateTwo ($table, $whereOne, $isOne, $whereTwo, $isTwo, $array='') {

			if (is_array($array)) {

				if (empty($array)) {

					return false;

				} else {
	   				foreach ($array as $key=>$value) {     // iterate values to input

					 	$values .= "`$key` = '$value', ";
					}


					$values = rtrim($values, ', ');
				    $query = mysql_query("UPDATE `$table` SET $values WHERE `$whereOne` = '$isOne' and `$whereTwo` = '$isTwo'");
					return $query;

				}

			}

		}

	}

?>