Pastable version of PHP5 Database Clas

<pre class='prettyprint' language='php'>&lt;?php

class DB {
	
	//connection variables
	protected $dbhost = 'localhost';
	protected $dbuser = 'root';
	protected $dbpass = '';
	protected $dbname = 'dbname';
	
	//normal global resources
	protected $db = null;
	protected static $instance = null;
	
	/**
	 * Singleton pattern for instantiating the DB class
	 */
	public static function GetInstance()
	{
		if(!self::$instance)
		{
			self::$instance = new DB;
		}
		return self::$instance;
	}
	
	protected function __construct()
	{
		if(($db = @mysql_connect($this-&gt;dbhost, $this-&gt;dbuser, $this-&gt;dbpass)) === false)
		{
			trigger_error('There was an error connecting to the server.');
			exit;
		}
		
		if((@mysql_select_db($this-&gt;dbname, $db)) === false)
		{
			trigger_error('There was an error selecting the database.');
			exit;
		}
		$this-&gt;db = $db;
	}
	
	/**
	 * simple method for sanitizing SQL query strings.
	 */
	public function Clean($string)
	{
		if(get_magic_quotes_gpc())
		{
			$string = stripslashes($string);
		}
		return mysql_real_escape_string($string);
	}
	
	/**
	 * DB class method call to the Query child class.
	 * SELECT queries only
	 * Returns an object.
	 */
	public function Query($statement)
	{
		return new Query($statement, $this-&gt;db);
	}
	
	/**
	 * DB class method call to the Execute child class.
	 * INSERT/UPDATE/DELETE queries only
	 * Returns number of rows affected.
	 */
	public function Execute($statement)
	{
		return new Execute($statement, $this-&gt;db);
	}
	
	/**
	 * Used to get the last inserted record
	 */
	public function InsertID()
	{
		return mysql_insert_id($this-&gt;link);
	}
	
	/**
	 * The transactional functions are giving me more of a headache than
	 * I sould care to have. The general idea behind what I want to do
	 * with them is be able to pass an array of SQL queries into one
	 * main method call, which in turn calls its child methods.
	 *
	 * The issue I have with this is that there are instances where I
	 * dont want to base a Commit / Rollback on whether or not the
	 * queries succeed or fail, but perhaps the time of day, or the
	 * privelage level of the user running the queries, etc.
	 */
	public function Transaction($queryArray)
	{
		/**
		 * this method call will return a new instance of the
		 * Transaction CLass. Operations are documented within
		 * the Transaction Class.
		 */
		 return new Transaction($queryArray, $this-&gt;db);
	}
	
	public function __destruct()
	{
		@mysql_close($this-&gt;db);
	}
	
}

/**
 * These are separate classes for the reason that I would like
 * to be able to edit them with as little distruption to the 
 * flow of the parent class as possible. 
 */

/**
 * Query child class. Used for running SELECT queries.
 * Called exclusively by the DB parent class in the Query method
 */
class Query
{
	protected $result;
	
	public function __construct($statement, $link)
	{
		if(($this-&gt;result = mysql_query($statement, $link)) === false)
		{
			trigger_error('There was an error in processing the Query method: '. mysql_error());
			exit;
		}
	}
	
	public function Fetch($class = null)
	{
		return @mysql_fetch_object($this-&gt;result);
	}
	
	public function __destruct()
	{
		@mysql_free_result($this-&gt;result);
	}
}

/**
 * Execute child class. Used for running INSERT/UPDATE/DELETE queries.
 * Called exclusively by the DB parent class in the Execute method
 */
class Execute
{
	public function __construct($statement, $link)
	{
		if((@mysql_query($statement, $link)) == false)
		{
			trigger_error('There was an error processing the Execute method: '. mysql_error());
			exit;
		}
		return @mysql_affected_rows($link);
	}
}

/**
 * Transaction child class. Used for transactional queries.
 * Called exclusively by the DB parent class in the Transaction method
 */
class Transaction
{
	public function __construct($queryArray, $link)
	{
		/**
		 * This is not working at all the way I want it to.
		 * 
		 * Essentially what it is doing, is running the first
		 * query, then basing the Commit / Rollback on the
		 * outcome of that single query. That's no good.
		 *
		 * I can see _why_ its not working, but that doesn't
		 * really help me to fix it. 
		 *
		 * $hold is set to 1 as its starting value, and as
		 * the loop progresses it either changes that or 
		 * doesnt, depending on the outcome. What it seems
		 * to be doing is running it once, and deciding
		 * &quot;Hey! the query worked!, lets commit changes!&quot;.
		 */
		$hold = 1;
		$this-&gt;Begin();
		foreach($queryArray as $query) {
			@mysql_query($query, $link);
			if(@mysql_affected_rows($link) == 0)
			{
				$hold = 0;
			}
		}
		if($hold == 0)
		{
			$this-&gt;Rollback();
			return false;
		} else {
			$this-&gt;Commit();
			return true;
		}
	}
	
	private function Begin()
	{
		@mysql_query('BEGIN', $link);
	}
	
	private function Commit()
	{
		@mysql_query('COMMIT', $link);
	}
	
	private function Rollback()
	{
		@mysql_query('ROLLBACK', $link);
	}
}

?&gt;</pre>
<a href="http://www.refactormycode.com/codes/391-php5-database-clas" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of PHP5 Database Clas