Class DB

class Db {
 
	private $_conf = false;
 
	public function __construct() {
		$this->parseConf();
		$this->dbConnect();
	}
 
	private function parseConf() {
		$this->_conf = parse_ini_file("crunksauce.ini", true);
	}
 
	private function dbConnect() {
		if (!isset($this->_conf['database'])) {
			echo 'no db details found';
			exit;
		}
		else {
			$db = $this->_conf['database'];
			$con = mysql_connect($db['host'], $db['user'], $db['pass']) 
			or die("connect fail");
			mysql_select_db($db['dbname'], $con) 
			or die("db select fail");
		}
	}
 
	private function quote($str='') {
		return str_replace("'", "\'", $str);
	}
 
	private function query($query=false) {
		return $query ? @mysql_query($query) : false;
	}
 
	// public functions
 
	public function result($query=false) {
		return $query ? @mysql_fetch_assoc($this->query($query)) : false;
	}
 
	public function results($query=false) {
		$ar = false;
		if ($query) {
			$res = $this->query($query);
			if ($res) {
				$ar = array();
				while ($r = mysql_fetch_assoc($res)) {
					$ar[] = $r;
				}
			}
		}
		return $ar;
	}
 
	public function insert($tbl=false, $data=array()) {
		if ($tbl && count($data) > 0) {
			foreach ($data as $key => $d) {
				if (!is_numeric($d)) {
					$data[$key] = "'" . $this->quote($d) . "'";
				}
			}
			$query = "INSERT INTO " . $tbl . " 
			(" . implode(", ", array_keys($data)) . ") 
			VALUES (" . implode(", ", $data) . ")";
			return $this->query($query) ? mysql_insert_id() : false;
		}
		else { return false; }
	}	
 
	public function update($tbl=false, $where=false, $data=array()) {
		if ($tbl && $where && count($data) > 0) {
			$set = array();
			foreach ($data as $key => $d) {
				$line = $key . "="; 
				$line .= !is_numeric($d) ? "'" . $this->quote($d) . "'" : $d;	
				$set[] = $line;		
			}
			$query = "UPDATE " . $tbl . " 
			SET " . implode(", ", $set) . " 
			WHERE " . $where;
			return $this->query($query);
		}
		else { return false; }
	}
 
	public function delete($tbl=false, $where=false) {
		if ($tbl && $where) { 
			return $this->query("DELETE FROM " . $tbl . " WHERE " . $where);
		}
		else { return false; }
	}
 
	public function debug($a) {
		echo "<pre>";
		print_r($a);
		echo "</pre>";
	}
 
}