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;
}
}
SecondShot's Official Website
