public function __construct($dsn, $username = null, $password = null, array $driver_options = null)
{
parent::__construct($dsn, $username, $password, $driver_options);
$this->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$this->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
$this->setAttribute(\PDO::ATTR_STATEMENT_CLASS, array("PdoStatement"));
}
public function __construct()
{
global $phpbb_root_path;
$database = $phpbb_root_path . 'store/messenger.db';
parent::__construct('sqlite:' . $database);
parent::setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
function connect()
{
parent::__construct('mysql:host=' . $this->DB_HOST . ';dbname=' . $this->DB_NAME, $this->DB_USER, $this->DB_PASS);
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// always disable emulated prepared statement when using the MySQL driver
$this->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}
public function __construct($dsn, $username, $password, $options = [])
{
$post_query = null;
// Let's grab the DB engine
if (strpos($dsn, ':') !== false) {
$this->dbengine = explode(':', $dsn)[0];
}
// If no charset is specified, default to UTF-8
switch ($this->dbengine) {
case 'mysql':
if (strpos($dsn, ';charset=') === false) {
$dsn .= ';charset=utf8';
}
break;
case 'pgsql':
$post_query = 'SET NAMES UNICODE';
break;
}
// Let's call the parent constructor now
parent::__construct($dsn, $username, $password, $options);
// Let's turn off emulated prepares
$this->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
if (!empty($post_query)) {
$this->query($post_query);
}
}
/**
* Creates a data source instance to represent a connection to the database.
* The first argument can either be a string DSN or an array which contains
* the construction arguments.
*
* @param mixed $dsn String DSN or array of arguments (dsn, username, password)
* @param string $username
* @param string $password
* @param array $driver_options
*/
function __construct($dsn, $username = '', $password = '', $driver_options = array())
{
if (is_array($dsn)) {
$args = $dsn;
if (isset($args[0])) {
$dsn = $args[0];
}
if (isset($args[1])) {
$username = $args[1];
}
if (isset($args[2])) {
$password = $args[2];
}
if (isset($args[3])) {
$driver_options = $args[3];
}
}
try {
parent::__construct($dsn, $username, $password, $driver_options);
parent::setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $exception) {
throw new DataSourceCouldNotConnectException($exception->getMessage(), get_defined_vars());
}
$this->cachePrefix = self::CACHE_PREFIX . $dsn . '::*::';
$this->provider = $this->instantiateProvider();
}
public function __construct(array $config)
{
$dsn = sprintf('%s:host=%s;dbname=%s', $config['dbtype'], $config['dbhost'], $config['dbname']);
$username = isset($config['username']) ? $config['username'] : '';
$password = isset($config['password']) ? $config['password'] : '';
parent::__construct($dsn, $username, $password);
}
public function __construct($database)
{
if (is_array($database)) {
$db_config = $database;
} else {
$db_config = EE::is_set('_config', 'databases', $database) ? EE::get('_config', 'databases', $database) : false;
}
if (!$db_config) {
trigger_error('No database config of ' . $database . ' found', E_USER_WARNING);
}
if (!isset($db_config['dsn'])) {
trigger_error('No database dsn config of ' . $database . ' found', E_USER_WARNING);
}
$extension = substr($db_config['dsn'], 0, strpos($db_config['dsn'], ':'));
if (!in_array($extension, PDO::getAvailableDrivers())) {
trigger_error('PDO extension of ' . $extension . ' could not be found', E_USER_WARNING);
}
$instance = null;
$username = isset($db_config['username']) ? $db_config['username'] : null;
$password = isset($db_config['password']) ? $db_config['password'] : null;
$params = isset($db_config['params']) ? $db_config['params'] : null;
try {
$instance = parent::__construct($db_config['dsn'], $username, $password, $params);
} catch (PDOException $e) {
trigger_error('Could not connect to database ' . $database . ': ' . $e->getMessage(), E_USER_ERROR);
}
return $instance;
}
public function __construct($connConfigName = 'default')
{
if (!isset(self::$arrConnConfig[$connConfigName])) {
throw new Exception("JPDO Exception : connConfigName '{$connConfigName}' does not exist!");
}
$connConfig = self::$arrConnConfig[$connConfigName];
if (!isset($connConfig['dsn'])) {
throw new Exception("JPDO Exception : in connConfig '{$connConfigName}', 'dsn' should has been set!");
}
if (!isset($connConfig['user'])) {
throw new Exception("JPDO Exception : in connConfig '{$connConfigName}', 'user' should has been set!");
}
if (!isset($connConfig['password'])) {
throw new Exception("JPDO Exception : in connConfig '{$connConfigName}', 'password' should has been set!");
}
$attr = array();
if (isset($connConfig['persistent_connection']) && $connConfig['persistent_connection'] == 'Y') {
$attr[PDO::ATTR_PERSISTENT] = true;
$attr[PDO::ATTR_AUTOCOMMIT] = true;
}
try {
@parent::__construct($connConfig['dsn'], $connConfig['user'], $connConfig['password'], $attr);
} catch (PDOException $e) {
print "DB Error: " . $e->getMessage() . "<br />";
}
$this->query("SET NAMES 'utf8';");
}
/**
* Connect to database
*
* @return $this
*/
public function connect()
{
parent::__construct($this->dsn, $this->username, $this->password, $this->options);
$this->execute('SET NAMES UTF8');
$this->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
return $this;
}
public function __construct($dsn, $username = null, $passwd = null, $options = null)
{
parent::__construct($dsn, $username, $passwd, $options);
$this->listeners = new \ArrayObject();
$this->muteListeners = false;
$this->transactionName = null;
}
function __construct($user, $pass, $host, $dbname)
{
$engine = 'mysql';
$host = 'localhost';
$dns = $engine . ':dbname=' . $dbname . ";host=" . $host;
parent::__construct($dns, $user, $pass);
}
private function conecta()
{
if (!$this->conectado) {
parent::__construct(DB_TYPE . ':host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS);
$this->conectado = true;
}
}
public function __construct($dsn = null, $username = null, $password = null, array $driver_options = null)
{
// Get the System DB Config
global $databaseConfig;
// Make the config easier to work with
$conf = (object) $databaseConfig;
// fix for sqlite dbs
$type = strtolower(str_replace('Database', '', $conf->type));
if ($type == 'sqlitepdo') {
$type = 'sqlite';
}
// DSN
if (!$dsn) {
$dsn = $type . ':' . 'host=' . $conf->server . ';' . 'dbname=' . $conf->database;
}
// Authentication
if (!$username) {
$username = $conf->username;
}
if (!$password) {
$password = $conf->password;
}
// Connect
parent::__construct($dsn, $username, $password, $driver_options);
}
public function __construct($host, $dbName, $user, $pass, ErrorHandler $errorHandler, $dbType = 'mysql')
{
$this->errorHandler = $errorHandler;
parent::__construct($dbType . ':host=' . $host . ';dbname=' . $dbName, $user, $pass);
// Throw an exception in case of an error
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
public function __construct()
{
if (self::$dsn === null) {
throw new DatabaseException('Booya\\DatabaseException: dsn not configured.');
}
parent::__construct(self::$dsn, self::$username, self::$password, array(self::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", self::ATTR_EMULATE_PREPARES => false, self::ATTR_ERRMODE => self::ERRMODE_EXCEPTION));
}
/**
* Creates a new PDO instance
*
* @param string $type Simple string such as 'mysql' or a PDO DNS string
* @param string $dbname
* @param string $host
* @param string $user
* @param string $pass
* @param string $port
* @param array $opts PDO specific driver options
*/
public function __construct($type, $dbname = '', $host = '', $user = '', $pass = '', $port = '', array $opts = array())
{
if (empty($dbname) && empty($host)) {
$dns = $type;
// Get the driver that is to be used
$splitDns = explode(':', $dns);
$driver = $splitDns[0];
} else {
if ($type == 'mysql' || $type == 'mysqli') {
$driver = 'mysql';
$dns = sprintf('mysql:host=%1$s;dbname=%2$s', $host, $dbname);
if (trim($port)) {
$dns .= ';port=' . $port;
}
} else {
if ($type == 'pgsql') {
$driver = 'pgsql';
$port = trim($port) ? $port : 5432;
$dns = sprintf('pgsql:host=%1$s port=%2$s dbname=%3$s user=%3$s password=%4$s', $host, $port, $dbname, $user, $pass);
}
}
}
if (!in_array($driver, PDO::getAvailableDrivers())) {
throw new SQL_InvalidDriver('PDO driver "' . $driver . '" is not available, ensure it is installed', 20);
}
try {
$opts = array_merge($opts, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
if ($driver == 'mysql') {
$opts[PDO::MYSQL_ATTR_USE_BUFFERED_QUERY] = true;
}
parent::__construct($dns, $user, $pass, $opts);
} catch (PDOexception $e) {
throw new SQL_UnableToConnect($e->getMessage(), 21);
}
}
/**
* possible sqlserver values are mysql, sybase, mssql
*/
public function __construct($host, $user, $pass, $dbname = null, $sqlserver = "mysql")
{
try {
if (strtolower($sqlserver) == "mysql") {
$dsn = "mysql:host={$host}";
if ($dbname) {
$this->dbname = $dbname;
$dsn = "mysql:host={$host};dbname={$dbname}";
}
parent::__construct($dsn, $user, $pass);
} else {
if (strtolower($sqlserver) == "sqlite") {
$dsn = "sqlite:{$dbname}";
parent::__construct($dsn);
} else {
die("Unknown DSN. Please set config.php");
}
}
Logger::getLogger("AuieoATS")->info("dsn is {$dsn}");
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->setStopOnError();
$this->fetchmode = PDO::FETCH_ASSOC;
} catch (PDOException $e) {
die($e);
}
}
public function __construct()
{
parent::__construct("mysql:host=localhost;dbname=busticket;", "root", "");
$this->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
// always disable emulated prepared statement when using the MySQL driver
$this->setAttribute(\PDO::ATTR_EMULATE_PREPARES, TRUE);
}
/**
* 构造函数
*
* @access public
* @param string $dsn 数据源
* @param string $user 连接帐户
* @param string $password 连接密码
* @param array $options 选项
*/
public function __construct($dsn, $user, $password, $options = array())
{
parent::__construct($dsn, $user, $password, $options);
$this->setAttribute(PDO::ATTR_TIMEOUT, 30);
$this->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$this->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('Driver_Db_Pdostatement', array($this)));
}
function __construct()
{
if (DB_TYPE == "pgsql") {
try {
//PostgreSQL
parent::__construct(DB_TYPE . ":host=" . DB_HOST . ";port=" . DB_PORT . ";dbname=" . DB_NAME . ";user="******";password="******"<script>alert('" . $e->getMessage() . "')</script>";
}
} else {
if (DB_TYPE == "mysql") {
try {
// MySQL
parent::__construct(DB_TYPE . ":host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PASS);
} catch (PDOException $e) {
echo "<script>alert('" . $e->getMessage() . "')</script>";
}
} else {
try {
// DB2
parent::__construct(DB_TYPE . ":DRIVER={" . DB_DRIVER . "};DATABASE=" . DB_NAME . ";" . "HOSTNAME=" . DB_HOST . ";PORT=" . DB_PORT . ";PROTOCOL=" . DB_PROTOCOL . ";", DB_USER, DB_PASS);
} catch (PDOException $e) {
echo "<script>alert('" . $e->getMessage() . "')</script>";
}
}
}
}
public function __construct()
{
set_exception_handler(array(__CLASS__, 'exception_handler'));
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES ' . $this->charset, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_PERSISTENT => $this->persistent);
parent::__construct('mysql:host=' . $this->host . ';dbname=' . $this->database . ';charset=' . $this->charset, $this->user, $this->password, $options);
restore_exception_handler();
}
public function connect()
{
if (!$this->isConnected) {
parent::__construct($this->dsn, $this->user, $this->password, $this->options);
$this->isConnected = true;
}
}
public function __construct($dsn, $username = null, $password = null, $driver_options = null)
{
parent::__construct($dsn, $username, $password, $driver_options);
$this->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('StormPDOStatement', array($this)));
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
}
function PDOdb($db_type)
{
$args = func_get_args();
$this->type = $db_type;
switch ($db_type) {
case self::ACCESS:
$args[0] = self::ODBC;
call_user_func_array(array($this, 'odbc_access'), $args);
break;
case self::MSSQL:
$args[0] = self::ODBC;
call_user_func_array(array($this, 'odbc_mssql'), $args);
break;
case self::MYSQL:
call_user_func_array(array($this, 'mysql'), $args);
break;
case self::PGSQL:
call_user_func_array(array($this, 'pgsql'), $args);
break;
default:
}
// Instanciate PDO and connect to DB or die
try {
parent::__construct($this->dsn, $this->uid, $this->pwd);
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo sprintf("Message : %s<br/><br/>", $e->getMessage());
die;
}
}
/**
* Constructs a new PDO intance.
*
* @param string $dsn Connection string.
* @param string $user User to login to database with.
* @param string $password Password to login to database with.
* @param Array $driverOptions Various driver option.
* @param string $prefix Table prefix to use instead of the default one.
*/
public function __construct($dsn, $user = null, $password = null, $driverOptions = array(), $prefix = null)
{
if (strpos($dsn, "sqlite:") === 0) {
$this->sqliteFilePath = substr($dsn, strlen("sqlite:"));
}
if (strpos($dsn, "mysql:") === 0) {
$newDsn = array();
$parts = explode(';', substr($dsn, strlen("mysql:")));
foreach ($parts as $part) {
$part = explode('=', $part);
if ($part[0] == 'username') {
$user = trim($part[1]);
} else {
if ($part[0] == 'password') {
$password = trim($part[1]);
} else {
$newDsn[] = implode('=', $part);
}
}
}
$dsn = "mysql:" . implode(';', $newDsn);
}
parent::__construct($dsn, $user, $password, $driverOptions);
$this->tablePrefix = $prefix;
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}
public function __construct()
{
DBParameters::construct();
parent::__construct('mysql:host=' . DBParameters::Hostname() . ';dbname=' . DBParameters::DBname(), DBParameters::Username(), DBParameters::Password(), array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
// parent::setFetchMode(PDO::FETCH_OBJ);
$this->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
}
function __construct()
{
$config = \Yaf\Application::app()->getConfig()->database['mysql'];
$dsn = "mysql:host={$config['host']};port={$config['port']};dbname={$config['dbname']}";
parent::__construct($dsn, $config['user'], $config['pass'], array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES'utf8';"));
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
/**
*
* @param string $host 数据库地址
* @param int $port 端口
* @param string $username 帐号
* @param string $passwd 密码
* @param string $database 数据库
* @param string $charset 编码，默认为utf8,也建议使用utf8
*/
public function __construct($host, $port, $username, $passwd, $database, $charset = "utf8")
{
$dsn = 'mysql:dbname=' . $database . ';host=' . $host . ';port=' . $port;
$this->_dsn = $dsn;
$options = array(\PDO::MYSQL_ATTR_INIT_COMMAND => 'set names ' . $charset, \PDO::ATTR_CASE => \PDO::CASE_LOWER, \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION, \PDO::ATTR_TIMEOUT => 30, \PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => TRUE, \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC);
parent::__construct($dsn, $username, $passwd, $options);
}
public function __construct($dsn, $user, $password)
{
parent::__construct($dsn, $user, $password);
$this->query("SET NAMES ´utf8´");
$this->query("SET CHARACTER SET utf8");
logger("INFO", "Database Class Initialized");
}
public function __construct()
{
// load the config object
$config = Load::library('Config');
// get the connection name based off the enviroment
$connection = $config->getEnvironment();
// load the connection details
$details = $config->get('connections.' . $connection);
try {
// instantiate the PDO object
$this->dbh = parent::__construct($details[0], $details[1], $details[2]);
} catch (PDOException $e) {
if ($config->isDev()) {
// throw the original exception
throw new Exception('PDO exception caught: ' . $e->getMessage());
} else {
// throw the generic DB exception
throw new Exception('Database connection error');
}
}
// set the PDO error mode to exception
parent::setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// return the DB handle
return $this->dbh;
}
