+ try {
+ $pdo = new PDO(DB_TYPE . ':dbname=' . DB_NAME . $db_host . $db_port,
+ DB_USER,
+ DB_PASS);
+ } catch (Exception $e) {
+ print "<pre>Exception while creating PDO object:" . $e->getMessage() . "</pre>";
+ exit(101);
+ }
+
+ $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+ if (DB_TYPE == "pgsql") {
+
+ $pdo->query("set client_encoding = 'UTF-8'");
+ $pdo->query("set datestyle = 'ISO, european'");
+ $pdo->query("set TIME ZONE 0");
+ $pdo->query("set cpu_tuple_cost = 0.5");
+
+ } else if (DB_TYPE == "mysql") {
+ $pdo->query("SET time_zone = '+0:0'");
+
+ if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {
+ $pdo->query("SET NAMES " . MYSQL_CHARSET);
+ }
+ }
+
+ return $pdo;