PDO Connection Class

 <?php
	/**
	*	This file for define constant variable
	*	for PDO Class
	*	Create 2008-07-01 By POP (shikimasan [at] gmail.com)
	*	Support SQLite and MySQL
	*	Can Extends to all DNS
	*/

	define("DB_TYPE", "MySQL"); // MySQL & SQLite
	define("DB_HOST", "localhost");
	define("DB_USERNAME", "mysql username");
	define("DB_PASSWORD", "mysql database");
	define("DB_NAME", "mysql database name");
	define("DB_DNS_MYSQL", "mysql:host=" . DB_HOST . "; dbname=" . DB_NAME);
	define("DB_DNS_SQLITE", "sqlite:db/sqlite_file");
	define("DB_PREFIX", "yourdatabase_");
?> 

 <?php
	/**
	*	This file define Class to Connect and Query PDO Statement
	*	Don't forget to include config.inc.php
	*	Create 2008-07-01 By POP (shikimasan [at] gmail.com)
	*/

	require_once('config.inc.php');

	class Connect extends PDO {
		public function __construct() {
			try {
				if (DB_TYPE == "MySQL") {
					parent::__construct(DB_DNS_MYSQL, DB_USERNAME, DB_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
				}
				elseif (DB_TYPE == "SQLite"){
					parent::__construct(DB_DNS_SQLITE);
				}
				$this -> setAttribute(PDO::ATTR_STATEMENT_CLASS, array('DatabaseStatement', array($this)));
			}
			catch (PDOException $e) {
				$e -> getMessage();
			}
		}
		public function __destruct() {
		}
	}

	class DatabaseStatement extends PDOStatement {
		public $dbc;
		private function __construct($dbc) {
			$this -> dbc = $dbc;
			$this -> setFetchMode(PDO::FETCH_ASSOC);
		}
		public function __destruct() {
			$this -> dbc = NULL;
		}
	}
?> 

 <?php
	require_once('connection.inc.php');

	class PopClasses extends Connect {
		public function getAddDate($basedate, $day) {
			return date("Y-m-d", strtotime($basedate . "+" . $day . " day"));
		}
	}

	// เวลาเอาไปใช้งานจริงๆ
	require_once('../include/PopClasses.inc.php');
	$conn = new PopClasses();
	$conn -> beginTransaction();
	$_POST['passwd'] = md5($_POST['passwd']);	// SQLite ไม่มีฟังก์ชั่น md5 เลยต้องทำบน php แทน
	$SQLCom = "insert into " . DB_PREFIX . "account(username, passwd, name, lv) values('" . $_POST['username'] . "', '" . $_POST['passwd'] . "', '" . $_POST['name'] . "', '" . $_POST['lv'] . "')";
	$conn -> exec($SQLCom) or die($conn -> viewVar($conn -> errorInfo()));
	$conn -> commit();
?>