Moved API-files to a separate API directory.

[hermes] / api / lib / db_functions.php

diff --git a/api/lib/db_functions.php b/api/lib/db_functions.php
new file mode 100644 (file)
index 0000000..6ec0f53
--- /dev/null
+++ b/api/lib/db_functions.php
@@ -0,0 +1,49 @@
+<?php
+require_once('config.php');
+require_once('lib/common_functions.php');
+
+function sql_dbquery( $db, $query )
+{
+       if ( ! mysql_select_db( $db ) ) return false;
+       $result = mysql_query( $query );
+       if ( !$result ) return false;
+       if (mysql_num_rows($result) == 0) return false;
+       return $result;
+}
+function sql_dbexec ( $db, $query )
+{
+       if ( ! mysql_select_db( $db ) ) return false;
+       $result = mysql_query( $query );
+       if ( !$result ) return false;
+       return $result;
+}
+function sql_dbquery_single( $db, $query )
+{
+       $result = sql_dbquery( $db, $query );
+       if ( ! $result ) return false;
+       if ( mysql_num_rows($result) != 1) return false;
+       $data = mysql_fetch_assoc( $result );
+       return $data;
+}
+function sql_dbtest_numrows ( $db, $query, $numrows )
+{
+       $result = sql_dbquery( $db, $query );
+
+       if ( ! $result ) return false;
+       if ( mysql_num_rows($result) == $numrows ) return true;
+       return false;
+}
+function sql_dbexec_rows ( $db, $query )
+{
+       if ( ! mysql_select_db( $db ) ) return false;
+       $result = mysql_query( $query );
+       if ( !$result ) return -1;
+       return mysql_affected_rows();
+}
+function sql_clean( $string )
+{
+       return addslashes( $string );
+}
+
+
+?>