[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3  

   4    osCommerce, Open Source E-Commerce Solutions

   5    http://www.oscommerce.com

   6  

   7    Copyright (c) 2003 osCommerce

   8    

   9    osCommRes, Services Online

  10    http://www.oscommres.com

  11  

  12    Copyright (c) 2005 osCommRes

  13  

  14    Released under the GNU General Public License

  15  */
  16    function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {
  17      global $$link;
  18  
  19      if (USE_PCONNECT == 'true') {
  20        $$link = mysql_pconnect($server, $username, $password);
  21      } else {
  22        $$link = mysql_connect($server, $username, $password);
  23      }
  24  
  25      if ($$link) mysql_select_db($database);
  26  
  27      return $$link;
  28    }
  29  
  30    function tep_db_close($link = 'db_link') {
  31      global $$link;
  32  
  33      return mysql_close($$link);
  34    }
  35  
  36    function tep_db_error($query, $errno, $error) { 
  37      die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');
  38    }
  39  
  40    function tep_db_query($query, $link = 'db_link') {
  41      global $$link;
  42  
  43      if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {
  44        error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
  45      }
  46  
  47      $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());
  48  
  49      if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {
  50         $result_error = mysql_error();
  51         error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
  52      }
  53  
  54      return $result;
  55    }
  56  
  57    function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {
  58      reset($data);
  59      if ($action == 'insert') {
  60        $query = 'insert into ' . $table . ' (';
  61        while (list($columns, ) = each($data)) {
  62          $query .= $columns . ', ';
  63        }
  64        $query = substr($query, 0, -2) . ') values (';
  65        reset($data);
  66        while (list(, $value) = each($data)) {
  67          switch ((string)$value) {
  68            case 'now()':
  69              $query .= 'now(), ';
  70              break;
  71            case 'null':
  72              $query .= 'null, ';
  73              break;
  74            default:
  75              $query .= '\'' . tep_db_input($value) . '\', ';
  76              break;
  77          }
  78        }
  79        $query = substr($query, 0, -2) . ')';
  80      } elseif ($action == 'update') {
  81        $query = 'update ' . $table . ' set ';
  82        while (list($columns, $value) = each($data)) {
  83          switch ((string)$value) {
  84            case 'now()':
  85              $query .= $columns . ' = now(), ';
  86              break;
  87            case 'null':
  88              $query .= $columns .= ' = null, ';
  89              break;
  90            default:
  91              $query .= $columns . ' = \'' . tep_db_input($value) . '\', ';
  92              break;
  93          }
  94        }
  95        $query = substr($query, 0, -2) . ' where ' . $parameters;
  96      }
  97  
  98      return tep_db_query($query, $link);
  99    }
 100  
 101    function tep_db_fetch_array($db_query) {
 102      return mysql_fetch_array($db_query, MYSQL_ASSOC);
 103    }
 104  
 105    function tep_db_num_rows($db_query) {
 106      return mysql_num_rows($db_query);
 107    }
 108  
 109    function tep_db_data_seek($db_query, $row_number) {
 110      return mysql_data_seek($db_query, $row_number);
 111    }
 112  
 113    function tep_db_insert_id() {
 114      return mysql_insert_id();
 115    }
 116  
 117    function tep_db_free_result($db_query) {
 118      return mysql_free_result($db_query);
 119    }
 120  
 121    function tep_db_fetch_fields($db_query) {
 122      return mysql_fetch_field($db_query);
 123    }
 124  
 125    function tep_db_output($string) {
 126      return htmlspecialchars($string);
 127    }
 128  
 129   //function tep_db_input($string) {

 130    //  return addslashes($string);

 131   // }

 132   function tep_db_input($string, $link = 'db_link') {
 133    global $$link;
 134   
 135  if (function_exists('mysql_real_escape_string')) {
 136      return mysql_real_escape_string($string, $$link);
 137    } elseif (function_exists('mysql_escape_string')) {
 138      return mysql_escape_string($string);
 139    }
 140   
 141    return addslashes($string);
 142  }
 143  
 144  
 145    function tep_db_prepare_input($string) {
 146      if (is_string($string)) {
 147        return trim(tep_sanitize_string(stripslashes($string)));
 148      } elseif (is_array($string)) {
 149        reset($string);
 150        while (list($key, $value) = each($string)) {
 151          $string[$key] = tep_db_prepare_input($value);
 152        }
 153        return $string;
 154      } else {
 155        return $string;
 156      }
 157    }
 158  ?>