Pastable version of My DB static class based around PDO

<pre class='prettyprint' language='php'>&lt;?php
/**
 * Db Class
 *
 * Database interaction with help from PDO
 *
 * @copyright  2009
 * @version    1.0
 * @author     Alex
 */
 
 class Db
 {
 	private static $_instance = NULL;
 
 
 	private function __construct() {
	
		// can not call me
	}
	
	private function __clone() {
	
		// no!
	}
	
	public static function getInstance() {
	
		if (!self::$_instance)
		{
		
			try {
		
				self::$_instance = new PDO('mysql:host=' . CONFIG_MYSQL_SERVER . ';dbname=' . CONFIG_MYSQL_DATABASE, CONFIG_MYSQL_USERNAME, CONFIG_MYSQL_PASSWORD);;
				self::$_instance-&gt; setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		
			} catch(PDOException $e) {
			
				trigger_error($e-&gt;getMessage());
			
			}
		
		}
		
		return self::$_instance;
		
	
	}
	
	
	
	public static function query($query /*string*/, $bindings = NULL)
	{
	
		$queryPortion = substr($query,0, 6);
	
		try {
	
			if ($bindings) {
	
					$prepared = self::getInstance()-&gt;prepare($query);
					
					foreach($bindings as $binding=&gt;$data) { // defaults to string
										
						if (!is_array($data)) {
							$prepared-&gt;bindParam($binding, $data);

} else {
						
							switch(count($data)) {
							
								case 1:
									$prepared-&gt;bindParam($binding, $data['value']);
									break;							
							
								case 2:
									$prepared-&gt;bindParam($binding, $data['value'], $data['dataType']);
									break;
									
								case 3:
									$prepared-&gt;bindParam($binding, $data['value'], $data['dataType'], (int)$data['length']);
									break;							
								
								default:
									trigger_error('An error has occured with the prepared statement bindings.');
									return false;
									break;
							}
						}
					
					}
					
					$prepared-&gt;execute();
							
					return $prepared-&gt;fetchAll(PDO::FETCH_ASSOC);
					
	
			} else if (String::match($queryPortion, 'select')) { // if this is a select query
			
				$rows = self::getInstance()-&gt;query($query);
			
				return $rows-&gt;fetchAll(PDO::FETCH_ASSOC);
					
			} else {
			
				return self::getInstance()-&gt;exec($query);

}
			
			
		} 
		catch(PDOException $e)
		{
			trigger_error($e-&gt;getMessage());
		}
		
	
	}
	
	public static function getLastInsertId()
	{
		try {
			self::getInstance()-&gt;lastInsertId();
		  }
		catch(PDOException $e)
		{
			trigger_error($e-&gt;getMessage());
		}
	
	}
	
	public static function disconnect()
	{
		// kill PDO object
		self::$_instance = NULL;
	
	}
 }</pre>
<a href="http://www.refactormycode.com/codes/769-my-db-static-class-based-around-pdo" 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 My DB static class based around PDO