<?php
/* Class awDatabase.php by Alan Waldron
 * http://www.alanwaldron.com
 * October 28, 2008
*/
 
	class awDatabase {
		var $mysql_host = MYSQL_HOST;
		var $mysql_username = MYSQL_USERNAME;
		var $mysql_password = MYSQL_PASSWORD;
		var $mysql_database = MYSQL_DATABASE;
		var $sql_error_reporting = TRUE;
		
		function dbconnect() {
			$db = mysql_connect($this->mysql_host, $this->mysql_username, $this->mysql_password);
		    if (!$db) { return error("Could not connect to DB.<br>".mysql_error()); }
		    else { mysql_select_db($this->mysql_database); return 1; }
		}
		
		function dbvar($key) {
			$this->dbconnect();
			return $this->quickSQL("SELECT var_value FROM site_variables WHERE var_key='".$key."'");
			mysql_close();
		}
		
		function dbvar_set($key,$value) {
			$this->dbconnect();
			return $this->quickUPDATE("UPDATE site_variables SET var_value='".$value."' WHERE var_key='".$key."'");
			mysql_close();
		}
		
		function quickCOL($sql) {
			$this->dbconnect();
			$res = mysql_query($sql);
			if (mysql_num_rows($res) > 0) {
				for ($i=0; $row = mysql_fetch_row($res); $i++) $arr[$i] = $row[0];
				return $arr;
			} else {
				if ($sql_error_reporting) echo "\n<P>".$sql."\n<P>".mysql_error();
				return FALSE;
			}
			mysql_close();
		}
		
		function quickSQL($sql) {
			$this->dbconnect();
			$res = mysql_query($sql);
			if (mysql_num_rows($res) > 0) {
				$row = mysql_fetch_row($res);
				return $row[0];
			} else {
				if ($sql_error_reporting) echo "\n<P>".$sql."\n<P>".mysql_error();
				return FALSE;
			}
			mysql_close();
		}
		
		function quickUPDATE($sql) {
			$this->dbconnect();
			if (mysql_query($sql) > 0) return TRUE;
			else {
				if ($sql_error_reporting) echo "\n<P>".$sql."\n<P>".mysql_error();
				return FALSE;
			}
			mysql_close();
		}
		
		function quickRSET($sql) {
			$this->dbconnect();
			$res = mysql_query($sql);
			if (mysql_num_rows($res) > 0) {
				for ($i=0; $row = mysql_fetch_assoc($res); $i++) {
					foreach ($row as $key => $val) $arr[$i][$key] = $val;
				}
				return $arr;
			} else {
				if ($sql_error_reporting) echo "\n<P>".$sql."\n<P>".mysql_error();
				return array();
			}
			mysql_close();
		}
		
		function quickROW($sql) {
			$this->dbconnect();
			$res = mysql_query($sql);
			if (mysql_num_rows($res) > 0) {
				$row = mysql_fetch_array($res);
				return $row;
			} else {
				if ($sql_error_reporting) echo "\n<P>".$sql."\n<P>".mysql_error();
				return FALSE;
			}
			mysql_close();
		}
		
		function table_dump($tbl_name) {
			$i=0;
			$r = $this->quickRSET("SELECT * FROM ".$tbl_name);
			$res = mysql_query("SELECT * FROM ".$tbl_name);
			$row = mysql_fetch_assoc($res);
			foreach ($row as $key => $val) $c[$i++] = $key;
			$out = '<br/><table border=0 cellspacing=1 cellpadding=0 bgcolor="#CCCCCC" style="font:10px Arial;">'."\n";
			$out .= '<tr bgcolor="#DDDDDD">'."\n";
			for ($i=0; $i < count($c); $i++) {
				$out .= '<th><b>'.$c[$i].'</b></th>'."\n";
			} 
			$out .= '</tr>'."\n";
			for ($i=0; $i < count($r); $i++) {
				$out .= '<tr bgcolor="#'.($i%2==0?'FFFFFF':'EEEEEE').'">'."\n";
				foreach ($r[$i] as $key => $val) {
					$out .= '<td>'.$val.'</td>'."\n";
				}
				$out .= '</tr>'."\n";
			}
			$out .= '</table>';
			return $out;
		}
	}
	
?>