/**
* Do real connection to Db server.
*
* @throws DbLinkException Thrown when no connection is possible.
*/
public function connect()
{
if (!$this->is_connected) {
$this->link->real_connect($this->host, $this->user, $this->pass, $this->schema, $this->port);
if ($this->link->connect_error) {
$this->errors[] = $this->link->connect_error;
throw new DbLinkException($this->link->connect_error, $this->link->connect_errno);
}
$this->link->set_charset(self::DEFAULT_CHARSET);
$this->is_connected = true;
}
}
public function connect()
{
$connect = '';
try {
$connect = new Mysqli(HOST, USERNAME, PASSWORD, DATABASE);
$connect->set_charset(CHARSET);
} catch (Exception $ex) {
echo $ex->getMessage();
}
return $connect;
}
/**
* [connect 数据库连接]
* @return [type] [description]
*/
private function connect(){
if(is_null(self::$link)){
$db = C('DB_DATABASE');
if(empty($db))echo "请先配置数据库";
$link = new Mysqli(C('DB_HOST'),C('DB_USER'),C('DB_PASSWORD'),C('DB_DATABASE'));
if($link->connect_error){
echo "数据库连接错误，请检查配置项";
}
$link->set_charset(C('DB_CHARSET'));
self::$link = $link;
}
}
protected function __connect()
{
$config = $this->getConfig();
$con = new \Mysqli($config->getHost(), $config->getUsername(), $config->getPassword(), $config->getDatabase(), sprintf('%s', $config->getPort()), $config->getSocket() ? $config->getSocket() : NULL);
if ($con->connect_errno) {
$msg = 'Could not connect to database "%s" at host %s:%s';
$msg = sprintf($msg, $config->getDatabase(), $config->getHost(), $config->getPort());
throw new \RuntimeException($msg);
}
$charset = $config->getCharset();
$charset = empty($charset) ? 'utf8' : $charset;
$con->set_charset($charset);
return $con;
}
/**
* [_connect 链接数据库]
* @return [type] [description]
*/
private function _connect()
{
if (is_null(self::$link)) {
$db = C("DB_DATABASE");
if (empty($db)) {
halt("请先配置数据库！");
}
$link = new Mysqli(C('DB_HOST'), C('DB_USER'), C('DB_PASSWORD'), $db, C('DB_PORT'));
if ($link->connect_error) {
halt("数据库连接出错，请检查数据库配置");
}
$link->set_charset(C("DB_CHARSET"));
self::$link = $link;
}
}
/**
* Create the database connection, select the appropriate db and call setOptions
* @param string $dbHost
* @param string $dbUname
* @param string $dbPass
* @param string $dbName
* @param string $dbPort
* @return void
*/
public function initialize($dbHost, $dbUname, $dbPass, $dbName, $dbPort)
{
$this->connection = mysqli_init();
if (!$this->connection->options(MYSQLI_INIT_COMMAND, 'set names utf8, collation_connection=utf8_unicode_ci')) {
trigger_error('MySQLi_options call failed');
}
$this->connection->options(MYSQLI_OPT_CONNECT_TIMEOUT, 2);
$this->connection->real_connect($dbHost, $dbUname, $dbPass, $dbName, $dbPort);
$this->connection->set_charset('utf8');
if (mysqli_connect_errno()) {
trigger_error('Unable to connect to MySQL: ' . mysqli_connect_error() . " H:'" . $_SERVER['HTTP_HOST'] . "'");
die;
}
$this->dbOnline = true;
}
/**
* [_connect 链接数据库]
* @return [type] [description]
*/
private function _connect()
{
if (is_null(self::$link)) {
if (empty(self::$dbConfig['DB_DATABASE'])) {
exit("请先配置数据库！");
}
$link = new Mysqli(self::$dbConfig['DB_HOST'], self::$dbConfig['DB_USER'], self::$dbConfig['DB_PASSWORD'], self::$dbConfig['DB_DATABASE'], self::$dbConfig['DB_PORT']);
if ($link->connect_error) {
exit("数据库连接出错，请检查数据库配置");
}
$link->set_charset(self::$dbConfig["DB_CHARSET"]);
self::$link = $link;
}
}
<?php
//การประกาศตัวแปร
$sitedb = "hq";
if ($sitedb == "hq") {
$mysqli_host = "192.168.1.5";
$mysqli_user = "******";
//super admin user :root / pass:root
$mysqli_pass = "******";
//P@ssw0rd
$mysqli_db = "prakongmitt_restaurant";
//ติดต่อเข้าฐานข้อมูล
} else {
$mysqli_host = "127.0.0.1";
$mysqli_user = "******";
//super admin user :root / pass:root
$mysqli_pass = "******";
//P@ssw0rd
$mysqli_db = "prakongmitt_restaurant";
}
$consqli = new Mysqli($mysqli_host, $mysqli_user, $mysqli_pass, $mysqli_db);
$consqli->set_charset("utf8");
// Check connection
if ($consqli->connect_error) {
die("Connection failed: " . $consqli->connect_error);
}
public function connectDB()
{
$connect = new Mysqli(SERVER, USER, PASSWORD, DB);
$connect->set_charset('utf8');
return $connect;
}
/**
*
* @staticvar <type> $db
* @param array $config
* @return Mysqli
*/
static function getDbObject($config = array())
{
static $db = null;
$conf = self::$config;
if (count($config)) {
foreach ($config as $option => $value) {
$conf[$option] = $value;
}
}
if ($db) {
return $db;
}
$db = new Mysqli($conf['host'], $conf['user'], $conf['password'], $conf['db']);
if ($conf['charset']) {
$db->set_charset($conf['charset']);
}
return $db;
}
