function dbConnect($timeout, $options = array())
{
$db = new pdo(PDO_dsn, PDO_username, PDO_password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$db->setAttribute(PDO::ATTR_TIMEOUT, "0");
foreach ($options as $option) {
$db->exec($option);
}
return $db;
}
/**
* Get Database PDO connection
* @param - no param
* @return pdo
*/
public function getDb()
{
if (self::$pdo == null) {
$dsn = DBENGINE . ':dbname=' . DATABASE . ';host=' . HOST . ';portname=' . PORTNAME . ';';
try {
self::$pdo = new PDO($dsn, USERNAME, PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
//Enabling exceptions
self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo $e->getMessage();
}
}
return self::$pdo;
}
/**
* 创建pdo实例
*/
protected function connect()
{
$dsn = 'mysql:dbname=' . $this->settings["dbname"] . ';host=' . $this->settings["host"] . ';port=' . $this->settings['port'];
$this->pdo = new \PDO($dsn, $this->settings["user"], $this->settings["password"], array(\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES ' . (!empty($this->settings['charset']) ? $this->settings['charset'] : 'utf8')));
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$this->pdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
}
<?php
echo "this is a database test.";
$ip = '192.168.33.61';
$port = '3306';
$user = '******';
$pass = '';
$info = sprintf("mysql:host=%s;port=%s,database=;", $ip, $port);
$db = new pdo($info, $user, $pass, array(PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$sth = $db->query('use test_database');
$sth = $db->prepare('select * from fukens');
$sth->execute(array());
while ($line = $sth->fetch()) {
var_dump($line);
}
exit;
<?php
try {
$con = new pdo('mysql:host=localhost;dbname=test', 'root', '');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo $e->getMessage();
die;
}
function get_db_connection()
{
$db = new pdo(DB_DRIVER . ":dbname=" . DB_NAME . ";charset=utf8;host=" . DB_HOST, DB_USER, DB_PASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $db;
}
/**
* Executes sql statement without any return value. Please consider the usage of
* prepared statements which is fully supported.
*
* <code>
* <?php
* dbConn::execute("INSERT INTO :prefix:user (username, registered) VALUES (:0, :1);", 'felix', (new DateTime));
* ?>
*
* @param string $query The query in sql language.
* @param multiple strings The values that will fill the variables in the query.
* @static
*/
public static function execute()
{
$argsCount = func_num_args();
$par = array();
// no query as parameter given
if ($argsCount < 1) {
throw new Exception("No Sql-Query given");
}
// if there are parameters, insert in
if ($argsCount > 1) {
// create array with parameters for pdo usage
for ($i = 1; $i < $argsCount; $i++) {
$key = ":" . ($i - 1);
$par[$key] = func_get_arg($i);
}
}
// insert table prefix
$query = func_get_arg(0);
$query = str_replace(":prefix:", dbConn::$tablePrefix, $query);
// create pdo connection
$db = new pdo("mysql:" . "host=" . dbConn::$host . ";" . "dbname=" . dbConn::$database . ";" . "charset=UTF8", dbConn::$username, dbConn::$password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
// prepare and execute
$sth = $db->prepare($query, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
if (!$sth) {
throw new Exception($db->errorInfo());
}
$sth->execute($par);
} catch (Exception $ex) {
throw new Exception($ex->getMessage());
}
// close database connection
$db = null;
}
