public static function bind($database) { // Connects DB and set environment variables // $database array should contain 'server','username','password'. self::$cachedResult = self::$dbProperties = array(); if (!isset($database) || empty($database)) { return false; } if (!isset($database['port']) && strpos($database['server'], ':')) { $port = explode(":", $database['server']); $database['server'] = $port[0]; $database['port'] = $port[1]; } if (!defined('__TEXTCUBE_DATA_DIR__')) { define('__TEXTCUBE_DATA_DIR__', __TEXTCUBE_CACHE_DIR__); } if (!file_exists(__TEXTCUBE_DATA_DIR__)) { @mkdir(__TEXTCUBE_DATA_DIR__); } self::$db = new SQLite3(__TEXTCUBE_DATA_DIR__ . '/' . $database['database'] . '.sqlite', SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE); if (!self::$db) { return false; } return true; }
public static function bind($database) { // Connects DB and set environment variables // $database array should contain 'server','username','password'. self::$cachedResult = self::$dbProperties = array(); if (!isset($database) || empty($database)) { return false; } if (!isset($database['port']) && strpos($database['server'], ':')) { $port = explode(":", $database['server']); $database['server'] = $port[0]; $database['port'] = $port[1]; } if (isset($database['port'])) { self::$db = new mysqli($database['server'], $database['username'], $database['password'], $database['database'], intval($database['port'])); } else { self::$db = new mysqli($database['server'], $database['username'], $database['password'], $database['database']); } if (!self::$db) { return false; } if (!self::$db->select_db($database['database'])) { die("Connection error :" . self::$db->errorno . " - " . self::$db->error); } //self::$db->autocommit(false); // Turns off autocommit. self::$db->autocommit(true); // Turns off autocommit. if (self::$db->set_charset("utf8")) { self::$dbProperties['charset'] = 'utf8'; } else { self::$dbProperties['charset'] = 'default'; } @self::query('SET SESSION collation_connection = \'utf8_general_ci\''); return true; }
public static function bind($database) { self::$cachedResult = self::$dbProperties = array(); // Connects DB and set environment variables // $database array should contain 'server','username','password'. if (!isset($database) || empty($database)) { return false; } self::$db = @mysql_connect($database['server'] . (isset($database['port']) ? ':' . $database['port'] : ''), $database['username'], $database['password']); if (!self::$db) { return false; } self::$db = @mysql_select_db($database['database']); if (!self::$db) { return false; } if (self::query('SET CHARACTER SET utf8')) { self::$dbProperties['charset'] = 'utf8'; } else { self::$dbProperties['charset'] = 'default'; } @self::query('SET SESSION collation_connection = \'utf8_general_ci\''); return true; }