db_conn.class.php

<?php

//db connection class using singleton pattern
class dbConn{
	
	//variable to hold connection object.
	protected static $db;
		
	private function __construct() {
            
            $file = 'sample.sqlite';
		
			try {
				// assign PDO object to db variable 
				self::$db = new PDO( 'sqlite:' . $file );
                                
				//enable error mode
				self::$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
			}
			catch (PDOException $e) {
				//catch and display error
				echo "Connection Error: " . $e->getMessage();
			}
		
	}
	
	// get connection function.
	public static function getConnection() {
		
		//if connection doesnt exist already, create one.
		if (!self::$db) {
			new dbConn();
		}
		
		//return connection.
		return self::$db;
	}
	
	
	
}//end class

?>