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