基于PHP的Free Help Desk php桌面帮助系统.zip

<?php /********************************************************************** * Author: Justin Vincent (jv@vip.ie) * Web...: http://justinvincent.com * Name..: ezSQL * Desc..: ezSQL Core module - database abstraction library to make * it very easy to deal with databases. ezSQLcore can not be used by * itself (it is designed for use by database specific modules). * */ /********************************************************************** * ezSQL Constants */ define('EZSQL_VERSION','2.08'); define('OBJECT','OBJECT',true); define('ARRAY_A','ARRAY_A',true); define('ARRAY_N','ARRAY_N',true); /********************************************************************** * Core class containg common functions to manipulate query result * sets once returned */ class ezSQLcore { var $trace = false; // same as $debug_all var $debug_all = false; // same as $trace var $debug_called = false; var $vardump_called = false; var $show_errors = true; var $num_queries = 0; var $last_query = null; var $last_error = null; var $col_info = null; var $captured_errors = array(); var $cache_dir = false; var $cache_queries = false; var $cache_inserts = false; var $use_disk_cache = false; var $cache_timeout = 24; // hours var $timers = array(); var $total_query_time = 0; var $db_connect_time = 0; var $trace_log = array(); var $use_trace_log = false; var $sql_log_file = false; var $do_profile = false; var $profile_times = array(); // == TJH == default now needed for echo of debug function var $debug_echo_is_on = true; /********************************************************************** * Constructor */ function ezSQLcore() { } /********************************************************************** * Print SQL/DB error - over-ridden by specific DB class */ function register_error($err_str) { // Keep track of last error $this->last_error = $err_str; // Capture all errors to an error array no matter what happens $this->captured_errors[] = array ( 'error_str' => $err_str, 'query' => $this->last_query ); } /********************************************************************** * Turn error handling on or off.. */ function show_errors() { $this->show_errors = true; } function hide_errors() { $this->show_errors = false; } /********************************************************************** * Kill cached query results */ function flush() { // Get rid of these $this->last_result = null; $this->col_info = null; $this->last_query = null; $this->from_disk_cache = false; } /********************************************************************** * Get one variable from the DB - see docs for more detail */ function get_var($query=null,$x=0,$y=0) { // Log how the function was called $this->func_call = "\$db->get_var(\"$query\",$x,$y)"; // If there is a query then perform it if not then use cached results.. if ( $query ) { $this->query($query); } // Extract var out of cached results based x,y vals if ( $this->last_result[$y] ) { $values = array_values(get_object_vars($this->last_result[$y])); } // If there is a value return it else return null return (isset($values[$x]) && $values[$x]!=='')?$values[$x]:null; } /********************************************************************** * Get one row from the DB - see docs for more detail */ function get_row($query=null,$output=OBJECT,$y=0) { // Log how the function was called $this->func_call = "\$db->get_row(\"$query\",$output,$y)"; // If there is a query then perform it if not then use cached results.. if ( $query ) { $this->query($query); } // If the output is an object then return object using the row offset.. if ( $output == OBJECT ) { return $this->last_result[$y]?$this->last_result[$y]:null; } // If the output is an associative array then return row as such.. elseif ( $output == ARRAY_A ) { return $this->last_result[$y]?get_object_vars($this->last_result[$y]):null; } // If the output is an numerical array then return row as such.. elseif ( $output == ARRAY_N ) { return $this->last_result[$y]?array_values(get_object_vars($this->last_result[$y])):null; } // If invalid output type was specified.. else { $this->print_error(" \$db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N"); } } /********************************************************************** * Function to get 1 column from the cached result set based in X index * see docs for usage and info */ function get_col($query=null,$x=0) { $new_array = array(); // If there is a query then perform it if not then use cached results.. if ( $query ) { $this->query($query); } // Extract the column values for ( $i=0; $i < count($this->last_result); $i++ ) { $new_array[$i] = $this->get_var(null,$x,$i); } return $new_array; } /********************************************************************** * Return the the query as a result set - see docs for more details */ function get_results($query=null, $output = OBJECT) { // Log how the function was called $this->func_call = "\$db->get_results(\"$query\", $output)"; // If there is a query then perform it if not then use cached results.. if ( $query ) { $this->query($query); } // Send back array of objects. Each row is an object if ( $output == OBJECT ) { return $this->last_result; } elseif ( $output == ARRAY_A || $output == ARRAY_N ) { if ( $this->last_result ) { $i=0; foreach( $this->last_result as $row ) { $new_array[$i] = get_object_vars($row); if ( $output == ARRAY_N ) { $new_array[$i] = array_values($new_array[$i]); } $i++; } return $new_array; } else { return null; } } } /********************************************************************** * Function to get column meta data info pertaining to the last query * see docs for more info and usage */ function get_col_info($info_type="name",$col_offset=-1) { if ( $this->col_info ) { if ( $col_offset == -1 ) { $i=0; foreach($this->col_info as $col ) { $new_array[$i] = $col->{$info_type}; $i++; } return $new_array; } else { return $this->col_info[$col_offset]->{$info_type}; } } } /********************************************************************** * store_cache */ function store_cache($query,$is_insert) { // The would be cache file for this query $cache_file = $this->cache_dir.'/'.md5($query); // disk caching of queries if ( $this->use_disk_cache && ( $this->cache_queries && ! $is_insert ) || ( $this->cache_inserts && $is_insert )) { if ( ! is_dir($this->cache_dir) ) { $this->register_error("Could not open cache dir: $this->cache_dir"); $this->show_errors ? trigger_error("Could not open cache dir: $this->cache_dir",E_USER_WARNING) : null; } else { // Cache all result values $result_cache = array ( 'col_info' => $this->col_info, 'last_result' => $this->last_result, 'num_rows' => $this->num_rows, 'return_value' => $this->num_rows, ); error_log