Global function for querying the database

[misc/kostenrechnung] / lib / general.php

diff --git a/lib/general.php b/lib/general.php
index c296728..fa250f8 100644 (file)
--- a/lib/general.php
+++ b/lib/general.php
@@ -42,6 +42,19 @@ function connect_db()
   pg_connect($dsn);
 }
 
+function query_db($sql)
+{
+  $sth = pg_query($sql);
+
+  if ($sth === false) return false;
+
+  $result = array();
+  while ($row = pg_fetch_assoc($sth))
+    $result[] = $row;
+
+  return $result;
+}
+
 function load_js($jsfiles, $jscode)
 {
   $ret = '';