host, $this->user, $this->pass) == false){ die('could not connect to mysql server'); } else if (mysql_select_db($this->db) == false){ die('could not select mysql database'); } } public function raw_query($query){ $start_time = time()+microtime(); $data = mysql_query($query); $log = array(); $log['time'] = time()+microtime() - $start_time; $log['query'] = $query; if ($log['error_no'] = mysql_errno() != 0) $log['error'] = mysql_error(); else $log['error'] = ''; $log['affected'] = mysql_affected_rows(); $log['trace'] = debug_backtrace(); $this->query_log[] = $log; return $data; } public function sql_select($table, $where = NULL, $fields = '*'){ $query = 'SELECT '.$fields.' FROM '.$table; if (!empty($where)) $query .= ' WHERE '.$where; return $this->raw_query($query); } public function get_log(){ return $this->query_log; } public function print_log(){ ?>
query_log as $val){ print(''); } ?>
timequeryaffectedtrace
'.$val['time'].''.$val['query']); if ($val['error_no'] != 0) print('
Error: '.$val['error_no'].' -- '.$val['error'].''); print('		'.$val['affected'].''.util::str_backtrace($val['trace']).'