public static function getDBCredentials($environment) { $environment = 'local'; //TODO: get nickname from environment->nickname mapping (maybe assoc array)? $numericalArr = explode(':', DatabaseConnectionStrings::getDBCS("MySQL_local")); $optionsArr = array(); return array("host" => $numericalArr[0], "username" => $numericalArr[1], "password" => $numericalArr[2], "schema" => $numericalArr[3], "dsn" => 'mysql:host=' . $numericalArr[0] . ';dbname=' . $numericalArr[3] . '', "options" => $optionsArr); }
public function getNewDBO() { $arrReturn = array(); $success = false; $db = null; // TODO: accessing db credentials=> connection string, username and password?? $arrCredentials = DatabaseConnectionStrings::getDBCredentials("local"); $dsn = $arrCredentials['dsn']; $user = $arrCredentials['username']; $password = $arrCredentials['password']; $options = $arrCredentials['options']; try { $db = new PDO($dsn, $user, $password); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // make PDO throw exceptions $success = true; } catch (Exception $e) { $success = false; $arrReturn['error'] = $e->getMessage(); } $arrReturn['success'] = $success; $arrReturn['DBO'] = $db; return $arrReturn; }