<?php

class db  {
	function __construct() {
		$this->link = mysql_connect(MYSQL_SERVER, MYSQL_USER, MYSQL_PASS);
		$this->Args = func_get_args();
		if(count($this->Args) == 0) {
			$this->db = mysql_select_db(MYSQL_DB);
		}
		else {
			$this->db = mysql_select_db($this->Args[0]);
		}
    }

    function getResult($result) {
    	$i=0;
		while($olddata = mysql_fetch_assoc($result)) {
			$keys = array_keys($olddata);
			foreach($keys as $key) {
				$newdata[$i][$key] = stripslashes($olddata[$key]);
			}
			$i++;
		}
		return $newdata;
    }

    function query($sql) {

		$result = mysql_query($sql) or die($sql . " " . mysql_error());
		return $result;
	}

	function update($table, $data, $key, $value) {
		$i=0;
		$count = count($data) - 1;
		foreach($data as $k=> $item) {
			if(preg_match("/date/", $k)) {
				$item = date("Y-m-d H:i:s", strtotime($item));
			}

			if($i==$count) {
				$sql .= $k . " = '" . mysql_real_escape_string($item) . "'";
			}
			else {
				$sql .= $k . " = '" . mysql_real_escape_string($item) . "', ";
			}
			$i++;
		}
		$sql = "UPDATE " . $table . " SET " . $sql . ", last_update = NOW() WHERE " . $key . " = '" . $value . "'";

		if($this->validate($table, $data)) {
			$result = $this->query($sql);
			return $result;
		}
		else {
			return false;
		}
	}

	function remove($table, $key, $value) {
		$sql = "DELETE FROM " . $table . " WHERE " . $key . " = '" . $value . "'";
		$result = $this->query($sql);
		return result;
	}

	function add($table, $data) {
		$i=0;
		$count = count($data) - 1;
		foreach($data as $k=> $item) {
			if(preg_match("/date/", $k)) {
				$item = date("Y-m-d H:i:s", strtotime($item));
			}

			if($i == $count) {
				$field_sql .= $k;
				$data_sql .= "'" .  mysql_real_escape_string($item) . "'";
			}

			else {
				$field_sql .= $k . ", ";
				$data_sql .= "'" . mysql_real_escape_string($item) . "',";
			}

			$i++;
		}
		$sql = "INSERT INTO " . $table . "  (" . $field_sql . ", last_update, created) VALUES(".$data_sql.", NOW(), NOW())";
		if($this->validate($table, $data)) {
			$result = $this->query($sql);
			return $result;
		}
		else {
			return false;
		}
	}

    function getData($table, $select_field = "*", $where_field, $value) {
		$sql = "SELECT " . $select_field . " FROM " . $table . " WHERE " . $where_field . " = '" . $value . "'";
		$result = $this->query($sql);
		$newdata = $this->getResult($result);
		return $newdata;
    }

	function getInsertID() {
		return mysql_insert_id();
	}
}
?>