www.gusucode.com > 08CMS空白站群系统 3.3 繁体 UTF-8 > upload/include/mysql.cls.php
<?php !defined('M_COM') && exit('No Permisson'); class cls_mysql{ var $querynum = 0; var $link; function connect($dbhost,$dbuser,$dbpw,$dbname = '',$pconnect = 0,$halt = TRUE,$ncharset = ''){ $func = !$pconnect ? 'mysql_connect' : 'mysql_pconnect'; if(!$this->link = @$func($dbhost,$dbuser,$dbpw,1)){ if($halt){ $this->halt('Can not connect to MySQL server'); }else return false; }else{ if($this->version() > '4.1'){ global $dbcharset,$mcharset; $ncharset = empty($ncharset) ? (empty($dbcharset) ? str_replace('-','',strtolower($mcharset)) : $dbcharset) : $ncharset; $serverset = $ncharset ? 'character_set_connection='.$ncharset.', character_set_results='.$ncharset.', character_set_client=binary' : ''; $serverset .= $this->version() > '5.0.1' ? ((!$serverset ? '' : ',').'sql_mode=\'\'') : ''; $serverset && mysql_query("SET $serverset", $this->link); } if($dbname && !@mysql_select_db($dbname, $this->link)){ if($halt){ $this->halt("Can not select database $dbname"); }else return false; } } return true; } function select_db($dbname){ return mysql_select_db($dbname, $this->link); } function fetch_array($query, $result_type = MYSQL_ASSOC){ return mysql_fetch_array($query, $result_type); } function fetch_one($sql){ return $this->fetch_array($this->query($sql)); } function query($sql, $type = ''){ $func = ($type == 'UNBUFFERED' && @function_exists('mysql_unbuffered_query')) ? 'mysql_unbuffered_query' : 'mysql_query'; if(!($query = $func($sql, $this->link))){ if(in_array($this->errno(), array(2006, 2013)) && substr($type, 0, 5) != 'RETRY'){ $this->close(); require M_ROOT.'./base.inc.php'; $this->connect($dbhost,$dbuser,$dbpw,$dbname,$pconnect,true,$dbcharset); $this->query($sql,'RETRY'.$type); } elseif($type != 'SILENT' && substr($type, 5) != 'SILENT'){ $this->halt('MySQL Query Error', $sql); } } $this->querynum++; return $query; } function affected_rows(){ return mysql_affected_rows($this->link); } function error(){ return (($this->link) ? mysql_error($this->link) : mysql_error()); } function errno(){ return intval(($this->link) ? mysql_errno($this->link) : mysql_errno()); } function result($query, $row){ $query = @mysql_result($query, $row); return $query; } function result_one($sql) { return $this->result($this->query($sql), 0); } function num_rows($query){ $query = mysql_num_rows($query); return $query; } function num_fields($query){ return mysql_num_fields($query); } function free_result($query){ return mysql_free_result($query); } function insert_id(){ return ($id = mysql_insert_id($this->link)) >= 0 ? $id : $this->result($this->query("SELECT last_insert_id()"), 0); } function fetch_row($query){ $query = mysql_fetch_row($query); return $query; } function fetch_fields($query){ return mysql_fetch_field($query); } function version(){ return mysql_get_server_info($this->link); } function close(){ return mysql_close($this->link); } function halt($message = '', $sql = ''){ global $timestamp,$dbname,$tblprefix; include_once M_ROOT.'./include/mysql.err.php'; } } ?>