Example #1
0
 public static function db_pg()
 {
     if (self::$_db_pg) {
         return self::$_db_pg;
     }
     $dir = dirname(__FILE__);
     include_once $dir . '/PDO/DB.php';
     include $dir . '/../config/config.db.php';
     $cfg = $db['zmoss'];
     $dsn = 'pgsql:host=' . $cfg['hostname'] . ';dbname=' . $cfg['database'];
     if (isset($cfg['port'])) {
         $dsn .= ';port=' . $cfg['port'];
     }
     self::$_db_pg = new PDO_DB($dsn, $cfg['username'], $cfg['password']);
     if (in_array(substr($dsn, 0, 6), array('mysql:', 'pgsql:'))) {
         self::$_db_pg->query("SET NAMES 'utf8'");
     }
     return self::$_db_pg;
 }