public static function setParameters($dbHost, $dbUser, $dbPassword, $dbName) { self::$dbHost = $dbHost; self::$dbUser = $dbUser; self::$dbPassword = $dbPassword; self::$dbName = $dbName; }
private function _handleDb() { Database::$dbType = $this->_conf->get('database_type'); Database::$dbHost = $this->_conf->get('database_host'); Database::$dbName = $this->_conf->get('database_name'); Database::$dbUsername = $this->_conf->get('database_username'); Database::$dbPassword = $this->_conf->get('database_password'); }
public static function getDB($dbName = 'adAudit') { if (!isset(self::$db) || self::$db == null) { try { $username = "******"; $password = "******"; self::$dbName = $dbName; $dbspec = self::$dsn . self::$dbName . ";charset=utf8"; self::$db = new PDO($dbspec, $username, $password, self::$options); } catch (PDOException $e) { self::$db = null; echo "Failed to open connection to " . self::$dbName . $e->getMessage(); } } return self::$db; }
public static function getDB($dbName = 'classbash', $configPath = ".." . DIRECTORY_SEPARATOR . ".." . DIRECTORY_SEPARATOR . ".." . DIRECTORY_SEPARATOR . "myConfig.ini") { if (!isset(self::$db)) { try { $thePath = dirname(__FILE__) . DIRECTORY_SEPARATOR . $configPath; $passArray = parse_ini_file($configPath); $username = $passArray["username"]; $password = $passArray["password"]; self::$dbName = $dbName; $dbspec = self::$dsn . self::$dbName . ";charset=utf8"; self::$db = new PDO($dbspec, $username, $password, self::$options); } catch (PDOException $e) { echo "Failed to open connection to " . self::$dbName . $e->getMessage(); } } return self::$db; }
public static function getDB($dbName = 'cs4773', $configFile = 'myConfig.ini') { Database::$dbName = $dbName; if (!isset(Database::$db)) { try { // read database config info from file $configArray = parse_ini_file(dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . $configFile); if ($configArray === false) { throw new RuntimeException("Database configuration file not found"); } $userName = $configArray["username"]; $pass = $configArray["password"]; // open the connection Database::$db = new PDO("mysql:host=localhost;dbname={$dbName};charset=utf8", $userName, $pass); Database::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo "Failed to connect to database {$dbName}: " . $e->getMessage(); } } return Database::$db; }
/** * Return table name. * * @return string */ public function fullName() { return sprintf("%s.%s", parent::dbName(), $this->tableName); }
public static function connect($dbsortName = 'default') { global $db; if (self::$hasConnected == 'no') { if (!is_array($db[$dbsortName])) { return false; } self::$dbinfo = $db[$dbsortName]; self::$dbType = $db[$dbsortName]['dbtype']; switch ($db[$dbsortName]['dbtype']) { case "mysqli": $conn = new mysqli($db[$dbsortName]['dbhost'], $db[$dbsortName]['dbuser'], $db[$dbsortName]['dbpassword'], $db[$dbsortName]['dbname'], $db[$dbsortName]['dbport']); // if (!$conn) Alert::make('Cant connect to your database.'); self::$dbConnect = $conn; self::$hasConnected = 'yes'; self::$dbName = $db[$dbsortName]['dbname']; if (isset($conn->connect_error[5])) { Log::error('Can not connect to your database. You must to edit file config.php now!'); } return $conn; break; case "sqlserver": $conn = DatabaseSqlserver::connect(); self::$error = DatabaseSqlserver::$error; self::$dbConnect = $conn; self::$hasConnected = 'yes'; return $conn; break; case "mssql": $conn = DatabaseMSSQL::connect(); // self::$error = DatabaseMSSQL::$error; self::$dbConnect = $conn; self::$hasConnected = 'yes'; return $conn; break; case "pdo": $conn = DatabasePDO::connect(); self::$dbConnect = $conn; self::$hasConnected = 'yes'; return $conn; break; // case "mysql": // // $conn = mysql_connect($db['dbhost'], $db['dbuser'], $db['dbpassword']); // // mysql_select_db($db['dbname']); // // self::$dbConnect = $conn; // // self::$hasConnected = 'yes'; // // break; } } }