class PdoConnection{ //variable to hold connection object. protected static $db; //private construct - class cannot be instatiated externally. private function __construct() { try { // assign PDO object to db variable self::$db = new PDO('mysql:host=localhost;dbname=gamefool_jst', 'gamefool_jst', 'jay071377', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") ); self::$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); } catch (PDOException $e) { //Output error - would normally log this to error file rather than output to user. echo "Connection Error: " . $e->getMessage(); } } public static function getConnection() { if (!self::$db) { new PdoConnection(); } return self::$db; } }
|
|
|