private function __construct()
{
//for Oracle
$tns = "\r\n\t (DESCRIPTION =\r\n\t (ADDRESS_LIST = (\r\n\t ADDRESS =\r\n\t (PROTOCOL = TCP)\r\n\t (HOST = " . Constants::$databaseHost . ")\r\n\t (PORT = 1521)\r\n\t )\r\n\t )\r\n\t (CONNECT_DATA = (\r\n\t SERVICE_NAME = " . Constants::$databaseName . ")\r\n\t )\r\n\t )";
try {
switch (Constants::$databaseDriver) {
case "SqlLite":
$connectionTyp = "sqlite:" . $_SERVER["DOCUMENT_ROOT"] . "/db/database.db";
break;
case "MySql":
$connectionTyp = "mysql:host=" . Constants::$databaseHost . ";dbname=" . Constants::$databaseName . ";charset=utf8";
break;
case "MSSql":
$connectionTyp = "sqlsrv:Server=" . Constants::$databaseHost . ";Database=" . Constants::$databaseName . ";charset=utf8";
break;
case "PgSql":
$connectionTyp = "pgsql:host=" . Constants::$databaseHost . ";dbname=" . Constants::$databaseName . ";charset=utf8";
break;
case "Oracle":
$connectionTyp = "oci:dbname=" . $this->{$tns};
break;
default:
echo "Unsuportted DB Driver! Check the configuration in Constants.php";
exit(1);
}
self::$connection = new PDO($connectionTyp, Constants::$databaseUser, Constants::$databasePass, $this->SQLoverSSL());
self::$connection->setAttribute = array(PDO::ATTR_PERSISTENT => ture, PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
die;
}
}
public static function getConnection()
{
$hostname = "localhost";
$user = "******";
$password = "";
$database = "user_data";
if (self::$connection == null) {
try {
self::$connection = new PDO('mysql:host=' . $hostname . ';dbname=' . $database, $user, $password);
} catch (Exception $ex) {
print $ex;
}
}
return self::$connection;
}
