<?php


Class Db_Class
{
	var $fields=array();
	var $values=array();
	var $selects=array();
	var $wheres=array();
	var $data, $numRows;
	var $insertId;
	var $dbLink;
	
	function Db_Class()
	{
		db_connect();
	}
	
	
	function escape($str)
	{
		return trim(mysql_real_escape_string($str));
	}
	
	function set($field,$value)
	{
		$value=$this->escape($value);
		
		$this->fields[]=$field;
		$this->values[]=$value;
	}
	
	
	function select($fields)
	{
		$fields=explode(',',$fields);
		
		foreach ($fields as $k=>$field)
		{
			$this->selects[]=$field;
		}
	}
	
	function where($field,$value,$operator='=')
	{
		$x=count($this->wheres);
		
		$this->wheres[$x]['field']=$field;
		$this->wheres[$x]['value']=$this->escape($value);
		$this->wheres[$x]['op']=$operator;
	}
	
	
	function fetch($table)
	{
		$sql="SELECT";
		foreach ($this->selects as $field)
		{
			$sql.=' '.$field.',';
		}
		
		$sql=substr($sql,0,strlen($sql)-1);//Remove the trailing comma
		$sql.=' FROM '.$table;
		if (count($this->wheres) > 0)
		{
			 $sql.=' WHERE ';
			
			foreach ($this->wheres as $k=>$v)
			{
				extract($v);
				
				$sql.=$field.' '.$op." '".$value."'";
				
				if ($k < count($this->wheres)-1)
					$sql.=' AND ';
			}
		}
		
		$this->query($sql);
		
		$this->selects=array();
		$this->wheres=array();
	}
	
	
	
	function query($sql)
	{
		
		//echo "$sql <br /><br />";
		$this->clearAll();
		
		$result=mysql_query($sql) or die($sql.'<br /><br />'.mysql_error());
		
		if (! is_resource($result))
			return true;
			
			
		$this->numRows=mysql_num_rows($result);
		while ($data = mysql_fetch_assoc($result))
		{
			$x=count($this->data);
			foreach ($data as $k=>$v)
			{
				$this->data[$x][$k]=trim(stripslashes($v));
			}
		}
		mysql_free_result($result);
		
		return true;
	}
		
		
	function num_rows()
	{
		if (is_numeric($this->numRows) && $this->numRows >=1)
			return $this->numRows;
		else
			return 0;
	}
	
	
	
	function get($fieldName)
	{
		$return=array();
		
		foreach ($this->data as $k=>$v)
		{
			$return[]=$v[$fieldName];
		}
		return $return;	
	}
	
	
	function getSingle($fieldName)
	{
		return @$this->data[0][$fieldName];
	}		
	
	
	function getAll()
	{
		$return= $this->data;
		return $return;
	}
	
	function getAllSingle()
	{
		return $this->data[0];
	}
	
	
	function clearAll()
	{
		$this->data=array();
		$this->numRows=0;
	}
	
	
	function insert($table)
	{
		$fields=implode(',',$this->fields);
		$values="'".implode("','",$this->values)."'";
		
		$sql="INSERT INTO $table ($fields) VALUES($values)";
		$this->query($sql);
		
		$this->insertId=mysql_insert_id();
		
		$this->fields=array();
		$this->values=array();
	}
	
	
	function insert_id()
	{
		if (is_numeric($this->insertId) && $this->insertId > 0)
			return $this->insertId;
		else
			return 0;
	}
	
	
	
	function update($table)
	{
		$sql="UPDATE $table SET";
		
		foreach ($this->fields as $k=>$field)
		{
			$value=$this->values[$k];
			
			$sql.=" $field='$value',";
		}
		
		$sql=substr($sql,0,strlen($sql)-1);
		
		if (count($this->wheres) > 0)
		{
			 $sql.=' WHERE ';
			
			foreach ($this->wheres as $k=>$v)
			{
				extract($v);
				
				$sql.=$field.' '.$op." '".$value."'";
				
				if ($k < count($this->wheres)-1)
					$sql.=' AND ';
			}
		}
		
		$this->query($sql);
		
		$this->fields=array();
		$this->values=array();
		$this->wheres=array();
	}
	
	
}

?>