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