--- a/include/common-db.inc.php +++ b/include/common-db.inc.php @@ -1,21 +1,23 @@ <?php - if (php_uname('n') == "actbus-www") { - $conn = pg_connect("dbname=transitdata user=transitdata password=transitdata host=bus-main.lambdacomplex.org"); - } else if (isDebugServer()) { - $conn = pg_connect("dbname=transitdata user=postgres password=snmc"); - } else { - $conn = pg_connect("dbname=transitdata user=transitdata password=transitdata "); - } - if (!$conn) { - die("A database error occurred.\n"); - } - - function databaseError($errMsg) { - die($errMsg); - } - - include('db/route-dao.inc.php'); - include('db/trip-dao.inc.php'); - include('db/stop-dao.inc.php'); - ?> +if (php_uname('n') == "actbus-www") { + $conn = new PDO("pgsql:dbname=transitdata;user=transitdata;password=transitdata;host=bus-main.lambdacomplex.org"); +} +else if (isDebugServer()) { + $conn = new PDO("pgsql:dbname=transitdata;user=postgres;password=snmc;host=localhost"); +} +else { + $conn = new PDO("pgsql:dbname=transitdata;user=transitdata;password=transitdata;host=localhost"); +} +if (!$conn) { + die("A database error occurred.\n"); +} +function databaseError($errMsg) +{ + die($errMsg); +} +include ('db/route-dao.inc.php'); +include ('db/trip-dao.inc.php'); +include ('db/stop-dao.inc.php'); +include ('db/servicealert-dao.inc.php'); +?>