Port DB calls to PHP PDO
[busui.git] / include / common-db.inc.php
blob:a/include/common-db.inc.php -> blob:b/include/common-db.inc.php
--- 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');
+?>