public static function getDB()
{
if (self::$db === null) {
self::$db = new mysqli(Config::get("hostname"), Config::get("username"), Config::get("password"), Config::get("database"));
self::$db->query("SET NAMES 'utf8'");
}
}
public static function getDB()
{
if (null === self::$db) {
self::$db = new self();
}
return self::$db;
}
/**
* @return FluentPDO
*/
private static function getdb()
{
if (self::$db == null) {
self::$db = new FluentPDO(new PDO('mysql:dbname=' . MYSQL_DBNAME . ';charset=utf8', MYSQL_USERNAME, MYSQL_PASSWORD));
}
return self::$db;
}
public static function init()
{
if (self::$db == null) {
self::$db = new mysqli(contract_viewer_db_host, contract_viewer_db_username, contract_viewer_db_password, contract_viewer_db_db);
}
return self::$db;
}
private static function init()
{
if (DB::$db == null) {
include "config.php";
DB::$db = new SQLite3($config["temperature_DB"]);
}
}
/**
* select db
*
* @param unknown $dbName
*/
public static function selectDB($dbName)
{
self::instance($dbName);
//->selectDB($dbName);
// db config
$config = self::getConfig($dbName);
return self::$db = Database::getInstance($config);
}
public static function getInstance()
{
if (!isset(self::$db)) {
require_once BASEPATH . '/app/config/database.php';
self::$db = new PDO($db_config['dsn'], $db_config['user'], $db_config['password'], $db_config['opt']);
}
return self::$db;
}
public function connect($dbName)
{
self::$db = mysqli_connect('localhost', $this->username, $this->password, $dbName);
if (!self::$db) {
return mysqli_connect_error();
}
return true;
}
function __construct()
{
self::$host = Config::get('db_host');
self::$db = Config::get('db_name');
self::$user = Config::get('db_user');
self::$password = Config::get('db_pass');
parent::__construct(self::$host, self::$user, self::$password, self::$db);
}
public static function getInstance()
{
if (!self::$db) {
$pdo = new PDO(self::$dsn, self::$usr, self::$pwd, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
$structure = new NotORM_Structure_Convention($primary = "id", $foreign = "%s_id", $table = "%s", $prefix = "");
self::$db = new NotORM($pdo);
}
return self::$db;
}
public static function init($dbtype, $config)
{
//把获取到的$dbtype赋值给自身类(DB)的$db变量内
//new $dbtype;实例化数据库类型，并保存在$db内
self::$db = new $dbtype();
//调用自身类的$db变量，并执行connect()方法，参数为$config内的参数
//使用、执行$db的connect()方法
self::$db->connect($config);
}
private static function getDB()
{
if (is_null(self::$db)) {
$db_path = APP_FOLDER_PATH . '/gtfs-data/gtfs.db';
$db = new SQLite3($db_path, SQLITE3_OPEN_READONLY);
self::$db = $db;
}
return self::$db;
}
private static function Connect($dsn, $user, $password)
{
self::$db = new PDO($dsn, $user, $password);
self::$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
$q = new Query("set names 'utf8'");
$q->Execute();
$q = new Query("set charset 'utf8'");
$q->Execute();
}
public static function SetConn($host, $username, $password, $db)
{
if (isset(self::$db)) {
return self::$db;
} else {
self::$db = new mysqli($host, $username, $password, $db);
return self::$db;
}
}
public static function get()
{
if (is_null(self::$db)) {
self::$db = Zend_Db::factory('PDO_MYSQL', array('host' => DB_HOST, 'username' => DB_USER, 'password' => DB_PASSWORD, 'dbname' => DB_NAME));
self::$db->query("SET NAMES utf8");
self::$db->setFetchMode(Zend_Db::FETCH_OBJ);
}
return self::$db;
}
public static function mongoDB()
{
if (!isset(self::$db)) {
self::$db = new MongoClient();
return self::$db;
} else {
return self::$db;
}
}
private function connect()
{
if (!isset(self::$db)) {
$server = "localhost";
$user = "******";
$password = "******";
$database = "quest3plusdb";
self::$db = new mysqli($server, $user, $password, $database);
}
}
private function __construct()
{
try {
// assign PDO object to db variable
self::$db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS);
self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
//Output error - would normally log this to error file rather than output to user.
echo "Connection Error: " . $e->getMessage();
}
}
public function connect()
{
$dsn = "mysql:dbname=" . DB_NAME . ";host=" . DB_HOST;
try {
self::$db = new PDO($dsn, DB_USER, DB_PASS, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''));
self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (Exception $e) {
header('Location: ' . BASE_PATH . 'error/db_error/');
exit;
}
}
public static function get_db()
{
if (!self::$db) {
self::$db = new MySQLi(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
if (self::$db->connect_error) {
error_log(sprintf("Unable to connect: reason: %s", self::$db->connect_error));
die;
}
}
return self::$db;
}
public static function query($query)
{
if (empty(self::$db)) {
self::$db = new mysqli('localhost', 'root', '', 'forforce');
}
self::$result = self::$db->query($query);
if (self::$result === false) {
throw new Exception(self::error(), 1);
}
return self::$result;
}
private function __construct()
{
$cfg = Cfg::get('DB');
if ($cfg['driver'] == 'mysql') {
require_once 'SQL.class.php';
self::$db = new SQL($cfg['host'], $cfg['login'], $cfg['password'], $cfg['base']);
}
if ($cfg['driver'] == 'pgsql') {
require_once 'PgSQL.class.php';
self::$db = new SQL($cfg['host'], $cfg['login'], $cfg['password'], $cfg['base']);
}
}
public function connect()
{
if (DB::$db) {
return DB::$db;
}
DB::$db = mysql_connect(DBHOST, DBUSER, DBPASS);
mysql_select_db(DBNAME);
if (!DB::$db || !is_resource(DB::$db)) {
throw new DbException("Db error " . mysql_errno(DB::$db) . ": " . mysql_error(DB::$db));
}
mysql_set_charset('utf8');
}
private function __construct()
{
try {
self::$db = new PDO('mysql:host=' . Config::HOST . ';dbname=' . Config::DATABASE . ';charset=utf8', Config::USERNAME, Config::PASS);
self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// To prevent PDO sql injection
// According to http://stackoverflow.com/a/12202218/2045041
self::$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public static function getInstance()
{
if (!isset(self::$db)) {
try {
self::$db = new \PDO('mysql:host=' . host . ';dbname=' . database, username, password);
self::$db->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
self::$db->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_OBJ);
} catch (PDOException $e) {
die('<div style="text-align: center; margin: 2%; padding: 0.5%; background-color: #009688; color: #ffffff; border-radius: 5px;"><h3>Erro na Conexão: ' . $e->getMessage() . '.</h3></div>');
}
}
return self::$db;
}
public static function connect()
{
if (!isset(self::$db)) {
try {
$pdo_options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => false);
self::$db = new PDO("mysql:host=localhost;dbname=hoods;charset=utf8", 'hoods', 'cs6083php', $pdo_options);
//echo "connected";
} catch (PDOException $ex) {
//echo $ex;
header('Location: /hoods/error/error.php');
}
}
return self::$db;
}
public static function connect()
{
//skusime sa pripojit
self::$db = new mysqli(Settings::$dbHost, Settings::$dbUser, Settings::$dbPassword, Settings::$dbDatabase);
//ak nastala chyba
if (self::$db->connect_error) {
Viewer::addMessage("Nepodarilo sa pripojiť k databáze, prosím kontaktujte administrátora !", Viewer::ERROR);
Utils::log('Connect Error (' . self::$db->connect_errno . ') ' . self::$db->connect_error);
return False;
}
//nastavime charset
self::$db->set_charset("utf8");
return True;
}
public static function Connect($host, $user, $pass, $db)
{
self::$host = $host;
self::$pass = $pass;
self::$user = $user;
self::$db = $db;
self::$conn = @mysql_connect($host, $user, $pass) or self::msg('连接数据库失败!可能是mysql数据库用户名或密码不正确!');
self::selectdb(self::$db);
if (self::version() > '4.1') {
mysql_query("SET NAMES 'GBK'");
}
if (self::version() > '5.0.1') {
mysql_query("SET sql_mode=''");
}
}
/**
* 单列模式获得数据库连接类<br/>
* 如果人为指定连接名称则DB类会按照多库规则处理,不会自动切换数据库连接<br/>
* @param string $conn_name
* 多库并存的情况下指明要获得连接的名称<br/>
* 传入false则锁定到主配数据库<br/>传入null切换主配数据库恢复到主从模式
* <br/>传入true时随机切换到从属数据库
* @return DB
*/
public static function get_db($conn_name = true, $reconnect = false)
{
if ($reconnect) {
self::$db = null;
}
if (empty(Conf::$db_boys)) {
$conn_name = false;
}
if (self::$db === null) {
self::$db = new DB();
self::$db->to_connect($conn_name);
} else {
//特定指定的数据库
if (is_string($conn_name)) {
if ($conn_name === self::$current_db) {
self::$is_main_sub = false;
}
} elseif ($conn_name === true) {
//要切换到从属数据库
if (is_string(self::$current_db)) {
//已经选择了从属数据库就不再选了
self::$is_main_sub = true;
return self::$db;
} else {
self::$db->to_connect($conn_name);
}
} elseif ($conn_name === false) {
//要锁定到主数据库
if (!is_string(self::$current_db)) {
//已经选择了从属数据库就不再选了
self::$is_main_sub = false;
return self::$db;
} else {
self::$db->to_connect($conn_name);
}
} else {
//恢复到默认
if (!is_string(self::$current_db)) {
//已经选择了从属数据库就不再选了
self::$is_main_sub = true;
return self::$db;
} else {
self::$db->to_connect($conn_name);
}
}
}
return self::$db;
}
/**
* initialise database settings and connect to framework database
*/
static function init($name = self::DEFAULT_CONNECT_NAME)
{
if (!self::$db) {
//load the required variables and settings for the db
require_once self::$config_dir . self::$config_file;
self::$db = $db;
}
//set db account info
$hostname = self::$db[$name]['hostname'];
$database = self::$db[$name]['database'];
$username = self::$db[$name]['username'];
$password = self::$db[$name]['password'];
$pdo_options = array();
$string = "mysql:host={$hostname};dbname={$database}";
$pdo_options = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
//connect to the specified db using the setup function
self::setup($string, $username, $password, $name, $pdo_options);
}