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; }