[php]<?php
CLASS MYSQL
{
var $QueryS = 0;
var $Conn;
var $Prefix = "qinggan_";

Function MYSQL($dbSet)
{
$this->Prefix = $dbSet["prefix"];
$this->Connect($dbSet);
}

Function Connect($dbSet)
{
if($dbSet["conn"] == 1)
{
$this->Conn = mysql_pconnect($dbSet["host"],$dbSet["user"],$dbSet["pass"]) OR die(mysql_error());
}
else
{
$this->Conn = mysql_connect($dbSet["host"],$dbSet["user"],$dbSet["pass"]) OR die(mysql_error());
}
//-----检查版本
if(mysql_get_server_info()>"4.1") mysql_query("SET NAMES 'gbk'");
if(mysql_get_server_info()>"5.0.1") mysql_query("SET sql_mode=''");

mysql_select_db($dbSet["data"]) or die(mysql_error());
}

Function Close()
{
Return @mysql_close();
}

Function Query($sql)
{
$sql = ($this->Prefix == "qinggan_" ? $sql : str_replace("qinggan_",$this->Prefix,$sql));
$query = mysql_query($sql,$this->Conn);
$this->QueryS++;
if($query) Return $query;
Return False;
}

Function FetchArray($query)
{
if(empty($query)) Return False;
$array = mysql_fetch_array($query);
Return $array;
}

Function FetchQuery($sql)
{
$query = $this->Query($sql);
$rows = $this->FetchArray($query);
Return $rows;
}

Function FetchRow($query)
{
$rows = mysql_fetch_row($query);
RETURN $rows;
}

Function InsertID()
{
$id = mysql_insert_id();
Return $id;
}

Function NumRows($query)
{
$rows = mysql_num_rows($query);
Return $rows;
}

Function AffectedRows()
{
$rows = mysql_affected_rows();
Return $rows;
}

Function MysqlResult($query,$row=0)
{
$rows = mysql_result($query,$row);
Return $rows;
}
}
?>[/php]