Zen Cart 源代码 database.php

下载文件

文件名: database.php
文件类型: PHP文件
文件大小: 2.35 KiB
MD5: 3a1677d0a7e287978809e075afb12b6f

database.php - 打开高亮: <?php /** * @package admin * @copyright Copyright 2003-2009 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: database.php 14139 2009-08-10 13:46:02Z wilt $ */ function zen_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') { global $db; reset($data); if ($action == 'insert') { $query = 'insert into ' . $table . ' ('; while (list($columns, ) = each($data)) { $query .= $columns . ', '; } $query = substr($query, 0, -2) . ') values ('; reset($data); while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= 'now(), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . zen_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= $columns . ' = now(), '; break; case 'null': $query .= $columns .= ' = null, '; break; default: $query .= $columns . ' = \'' . zen_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ' where ' . $parameters; } return $db->Execute($query); } function zen_db_insert_id() { return mysql_insert_id(); } function zen_db_output($string) { return htmlspecialchars($string); } function zen_db_input($string) { return addslashes($string); } function zen_db_prepare_input($string, $trimspace = true) { if (is_string($string)) { if ($trimspace == true) { return trim(stripslashes($string)); } else { return stripslashes($string); } } elseif (is_array($string)) { reset($string); while (list($key, $value) = each($string)) { $string[$key] = zen_db_prepare_input($value); } return $string; } else { return $string; } } ?>