Beispiel #1
0
 public static function open($config)
 {
     self::$db = @mysql_connect($config['hostname'], $config['username'], $config['password']);
     if (self::$db) {
         @mysql_select_db($config['database']);
     }
 }
Beispiel #2
0
 /**
  * Abre la conexión.
  * La configuración debería contener los siguientes campos:
  *    hostname = equipo a cual conectarse
  *    username = usuario
  *    password = clave de acceso
  *    database = nombre de la base de datos
  *
  * @param array $config
  */
 public static function connect($config)
 {
     self::$db = @new mysqli($config['hostname'], $config['username'], $config['password'], $config['database']);
     if (self::$db->connect_errno) {
         throw new Exception(self::$db->connect_error, self::$db->connect_errno);
     }
 }
Beispiel #3
0
 public static function getInstance($option = null)
 {
     if (self::$db == null) {
         self::$db = new Db($option);
     }
     return self::$db;
 }
Beispiel #4
0
 public static function getInstance()
 {
     if (!self::$db) {
         self::$db = new PDO('mysql:host=' . self::$host . ';dbname=' . self::$dbName . ';port=' . self::$port, self::$user, self::$pass);
     }
     return self::$db;
 }
Beispiel #5
0
 /**
  * A Singleton pattern
  * to prevent multiple use of db
  * @return object 
  */
 public static function __d()
 {
     if (!isset($db)) {
         self::$db = new Db();
     }
     return self::$db;
 }
Beispiel #6
0
 public static function init()
 {
     $mongo = new Mongo();
     self::$db = $db = $mongo->poggin;
     self::$songs = $db->songs;
     self::$users = $db->users;
 }
Beispiel #7
0
 private function __construct()
 {
     try {
         self::$db = new \PDO("mysql:host=" . DbConfig::DB_HOST . ";dbname=" . DbConfig::DB_NAME, DbConfig::DB_USER, DbConfig::DB_PASS);
         self::$db->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
     } catch (\PDOException $e) {
         echo "Connection Error: " . $e->getMessage();
     }
 }
Beispiel #8
0
 /**
  * 切换使用的DB连接
  * @param string $sign
  */
 public static function switchDb($sign = 'default')
 {
     if (isset(self::$connectList[$sign])) {
         self::$db = self::$connectList[$sign];
         return self::_db();
     } else {
         return false;
     }
 }
 public static function getInstance()
 {
     //static = geen object nodig om aan te roepen
     if (self::$db != null) {
         return self::$db;
     } else {
         self::$db = new PDO('mysql:host=localhost; dbname=kangu-product', 'root', 'root');
         return self::$db;
     }
 }
Beispiel #10
0
 /**
  * singleton pattern to return single db handle
  * 
  * @param string db host
  * @param string db name
  * @param string db user
  * @param string db password
  * @return handle database handle
  */
 protected static function dbConnect($dbHost, $dbName, $dbUser, $dbPassword)
 {
     if (!self::$db) {
         try {
             self::$db = new PDO('mysql:host=' . $dbHost . ';dbname=' . $dbName, $dbUser, $dbPassword);
             self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
             return self::$db;
         } catch (PDOException $e) {
             echo '<br />' . __FUNCTION__ . ' in ' . __FILE__ . ' at ' . __LINE__ . ': ' . $e->getMessage() . '<br /><br />';
         }
     }
 }
Beispiel #11
0
 public static function change_db($db)
 {
     global $dbdata;
     if ($db != '') {
         Db::$dbconn = $db;
         Db::$db = $dbdata[$db]['dbtype'];
         $conn = Db::conn_db($dbdata);
         Db::$conn = $conn;
     } else {
         echo "Sila semak pilihan pangkalan data";
     }
 }
 /**
  * Database connector
  */
 private function dbConnect()
 {
     try {
         // open connection to MongoDB server
         $connect = new \Mongo();
         // access database
         Db::$db = $connect->{Db::DB_NAME};
     } catch (\MongoConnectionException $e) {
         die('Error connecting to MongoDB server');
     } catch (\MongoException $e) {
         die('Error: ' . $e->getMessage());
     }
 }
Beispiel #13
0
Datei: Db.php Projekt: pirey/YMVC
 public static function init()
 {
     if (!self::$db) {
         try {
             $dsn = "mysql:host=" . Config::$db_host . ";dbname=" . Config::$db_name . ";charset=utf8";
             self::$db = new PDO($dsn, Config::$db_user, Config::$db_pass);
             self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
             self::$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
         } catch (PDOException $e) {
             exit("Connection error: " . $e->getMessage());
         }
     }
     return self::$db;
 }
Beispiel #14
0
 public static function init()
 {
     if (!self::$db) {
         try {
             $dsn = 'mysql:host=' . DB_HOST . ';dbname=' . DB_NAME;
             self::$db = new PDO($dsn, DB_USER, DB_PASS);
             self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
             self::$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
         } catch (PDOException $e) {
             die('Connection error: ' . $e->getMessage());
         }
     }
     return self::$db;
 }
Beispiel #15
0
 public static function init()
 {
     if (!self::$db) {
         try {
             $cfg = Configuracion::getConfiguracion('basedatos');
             $dsn = $cfg['dsn'];
             self::$db = new PDO($dsn, $cfg['usuario'], $cfg['clave']);
             //Crea un nuevo objeto PDO (PHP Data Object)
             self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
             //Indica que lanza una excepción si existe algún error.
             self::$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
             //Establece la propiedad de asociacion para los resultados
             // de consulta
         } catch (PDOException $exc) {
             die('Error de conexion a la base de datos! ' . $exc->getMessage());
         }
     }
     return self::$db;
 }
Beispiel #16
0
 protected function getColumns($tableName = '')
 {
     if ($tableName == '') {
         $tableName = $this->getTable();
     }
     $this->_criteria['sql'] = 'SHOW FULL COLUMNS FROM `' . $tableName . '`';
     $dbName = $this->getDb();
     Db::db()->{$dbName}->prepare($this->_criteria['sql']);
     $column = Db::db()->{$dbName}->fetchAll();
     $this->reset();
     unset($value);
     foreach ($column as &$value) {
         $value['dataType'] = $this->_extractType($value['Type']);
     }
     return $column;
 }
Beispiel #17
0
 public function write($session_id, $session_data)
 {
     $dbName = $this->_config['dbName'];
     $db = Db::db()->{$dbName};
     $sql = 'REPLACE INTO `' . $this->_config['tableName'] . '` (`id`, `data`, `expire`) VALUES (:0,:1,:2)';
     Db::db()->{$dbName}->prepare($sql);
     Db::db()->{$dbName}->bindValues(array(array(':0', $session_id), array(':1', $session_data), array(':2', NOW + $this->_gc_maxlifetime)));
     Db::db()->{$dbName}->execute();
     return true;
 }