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'");
     }
 }
Exemple #2
0
 public static function getDB()
 {
     if (null === self::$db) {
         self::$db = new self();
     }
     return self::$db;
 }
Exemple #3
0
 /**
  * @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;
 }
Exemple #4
0
 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;
 }
Exemple #5
0
 private static function init()
 {
     if (DB::$db == null) {
         include "config.php";
         DB::$db = new SQLite3($config["temperature_DB"]);
     }
 }
Exemple #6
0
Fichier : DB.php Projet : Rgss/imp
 /**
  * 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);
 }
Exemple #7
0
 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;
 }
Exemple #8
0
 public function connect($dbName)
 {
     self::$db = mysqli_connect('localhost', $this->username, $this->password, $dbName);
     if (!self::$db) {
         return mysqli_connect_error();
     }
     return true;
 }
Exemple #9
0
 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);
 }
Exemple #10
0
 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);
 }
Exemple #12
0
 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;
 }
Exemple #13
0
 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();
 }
Exemple #14
0
 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;
     }
 }
Exemple #15
0
 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;
 }
Exemple #16
0
 public static function mongoDB()
 {
     if (!isset(self::$db)) {
         self::$db = new MongoClient();
         return self::$db;
     } else {
         return self::$db;
     }
 }
Exemple #17
0
 private function connect()
 {
     if (!isset(self::$db)) {
         $server = "localhost";
         $user = "******";
         $password = "******";
         $database = "quest3plusdb";
         self::$db = new mysqli($server, $user, $password, $database);
     }
 }
Exemple #18
0
 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();
     }
 }
Exemple #19
0
 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;
 }
Exemple #21
0
 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;
 }
Exemple #22
0
 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']);
     }
 }
Exemple #23
0
 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');
 }
Exemple #24
0
 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();
     }
 }
Exemple #25
0
 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;
 }
Exemple #26
0
 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;
 }
Exemple #27
0
 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;
 }
Exemple #28
0
 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=''");
     }
 }
Exemple #29
0
 /**
  * 单列模式获得数据库连接类<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;
 }
Exemple #30
0
 /**
  * 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);
 }