git.defcon.no Git - hermes/blob - api/lib/db_functions.php

   1 <?php
   2 /*
   3 #  Copyright (c) 2012, Gjøvik University College
   4 #  All rights reserved.
   5
   6 #  Redistribution and use in source and binary forms, with or without
   7 #  modification, are permitted provided that the following conditions are met:
   8 #      * Redistributions of source code must retain the above copyright
   9 #        notice, this list of conditions and the following disclaimer.
  10 #      * Redistributions in binary form must reproduce the above copyright
  11 #        notice, this list of conditions and the following disclaimer in the
  12 #        documentation and/or other materials provided with the distribution.
  13 #      * Neither the name of the Gjøvik University College nor the
  14 #        names of its contributors may be used to endorse or promote products
  15 #        derived from this software without specific prior written permission.
  16 #
  17 #  THIS SOFTWARE IS PROVIDED BY Gjøvik University College ''AS IS'' AND ANY
  18 #  EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  19 #  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  20 #  DISCLAIMED. IN NO EVENT SHALL Gjøvik University College BE LIABLE FOR ANY
  21 #  DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  22 #  (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  23 #  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  24 #  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  25 #  (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  26 #  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  27 */
  28 require_once('config.php');
  29 require_once('lib/common_functions.php');
  30
  31 function sql_dbquery( $db, $query )
  32 {
  33         if ( ! mysql_select_db( $db ) ) return false;
  34         $result = mysql_query( $query );
  35         if ( !$result ) return false;
  36         return $result;
  37 }
  38 function sql_dbexec ( $db, $query )
  39 {
  40         if ( ! mysql_select_db( $db ) ) return false;
  41         $result = mysql_query( $query );
  42         if ( !$result ) return false;
  43         return $result;
  44 }
  45 function sql_dbquery_single( $db, $query )
  46 {
  47         $result = sql_dbquery( $db, $query );
  48         if ( ! $result ) return false;
  49         if ( mysql_num_rows($result) != 1) return false;
  50         $data = mysql_fetch_assoc( $result );
  51         return $data;
  52 }
  53 function sql_dbtest_numrows ( $db, $query, $numrows )
  54 {
  55         $result = sql_dbquery( $db, $query );
  56
  57         if ( ! $result ) return false;
  58         if ( mysql_num_rows($result) == $numrows ) return true;
  59         return false;
  60 }
  61 function sql_dbexec_rows ( $db, $query )
  62 {
  63         if ( ! mysql_select_db( $db ) ) return false;
  64         $result = mysql_query( $query );
  65         if ( !$result ) return -1;
  66         return mysql_affected_rows();
  67 }
  68 function sql_clean( $string )
  69 {
  70         return addslashes( $string );
  71 }
  72
  73
  74 ?>