A
Anonymous
Guest
Here's a simple connection script:
Then in your main file, you would call it like such:
Code:
<?php
/**
* PDO database; only one connection is allowed.
*/
class Database {
private $_pdo;
// Store the single instance.
private static $_instance;
/**
* Get an instance of the Database.
* @return Database
*/
public static function getInstance() {
if (!self::$_instance) {
self::$_instance = new self();
}
return self::$_instance;
}
/**
* Constructor
*/
public function __construct() {
$db_options = array(
PDO::ATTR_EMULATE_PREPARES => false // important! use actual prepared statements (default: emulate prepared statements)
, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION // throw exceptions on errors (default: stay silent)
, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC // fetch associative arrays (default: mixed arrays)
);
$this->_pdo = new PDO('mysql:host=localhost;dbname=Your_Database;charset=utf8', 'root', 'Your_Password', $db_options);
}
/**
* Empty clone magic method to prevent duplication.
*/
private function __clone() {}
/**
* Get the PDO connection.
*/
public function getConnection() {
return $this->_pdo;
}
}
Then in your main file, you would call it like such:
Code:
require ('class.database.inc.php');
$db = Database::getInstance();
$pdo = $db->getConnection();