Advertisement
Guest User

Untitled

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