diff options
author | Dimitry Bradt <diox@gentoo.org> | 2007-02-21 01:26:11 +0000 |
---|---|---|
committer | Dimitry Bradt <diox@gentoo.org> | 2007-02-21 01:26:11 +0000 |
commit | 359697a716a42e9ba82b601ec6ae5f5db9dd0a14 (patch) | |
tree | 2b1baea5e23d4817ba2230271861e22882090855 /site/source/functions/databases/postgres.inc | |
download | adopt-a-dev-master.tar.gz adopt-a-dev-master.tar.bz2 adopt-a-dev-master.zip |
svn path=/; revision=1
Diffstat (limited to 'site/source/functions/databases/postgres.inc')
-rw-r--r-- | site/source/functions/databases/postgres.inc | 85 |
1 files changed, 85 insertions, 0 deletions
diff --git a/site/source/functions/databases/postgres.inc b/site/source/functions/databases/postgres.inc new file mode 100644 index 0000000..f50fdca --- /dev/null +++ b/site/source/functions/databases/postgres.inc @@ -0,0 +1,85 @@ +<?php + +# CATS Online Registration System +# Copyright (C) 2004 Adam Beaumont, Thomas Cort, Patrick McLean, Scott Stoddard +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 2 of the License, or +# (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +function db_get_max_rows($rs) +{ + return pg_num_rows($rs); +} + +function db_fetch_array($rs) +{ + return pg_fetch_array($rs); +} + +function db_query($query) +{ + global $db_conn; + db_connect(); + #print "---------IN----------"; + #print "<p>$query<p>"; + $result = pg_query($db_conn, $query); + #print "<p>$query<p>"; + #print "----------OUT---------"; + return new DBResult($result,$query); +} + +function db_exec($query) +{ + global $db_conn; + db_connect(); + #print "*********IN**********"; + #print "<p>$query<p>"; + $result = pg_query($db_conn, $query); + #print "*********OUT*********"; + if ($result == FALSE) + print "<p>db_exec() failed, query: $query<p>"; + if (pg_affected_rows($result) > 0) + { + return TRUE; + } + else + { + return FALSE; + } +} + +function db_connect() +{ + global $db_conn, $db_name, $db_user, $db_pass; + if ($db_conn == NULL || $db_conn == FALSE) + { + $db_conn = pg_connect("dbname=$db_name user=$db_user"); + + # For debugging purposes only + #print "<p>Formed a new connection<p>"; + } +} + +function db_data_seek($rs, $pos) +{ + @pg_fetch_row($rs, $pos); +} + +function db_close() +{ + global $db_conn; + pg_close($db_conn); +} + +?> |