实用简单的mysql 数据库连接类

实用简单的mysql教程 数据库教程连接类
class DB
{
//database connection
var $con = FALSE;

function DB($MYSQL_HOST=MYSQL_HOST, $MYSQL_USER=MYSQL_USER, $MYSQL_PASS=MYSQL_PASS,$MYSQL_DB=MYSQL_DB)
{
$this->con = @mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) or die("Could not connect to database");

if ($this->con)
{
@mysql_select_db($MYSQL_DB, $this->con) or die ("Could not select database");
}

return $this->con;
}

function Query($sql, $tran = false)
{
// if (!file_exists(MYSQL_LOG))
// {
// @umask(0);
// @mkdir(MYSQL_LOG, 0777);
// }

// ¼־
//$fp = @fopen(MYSQL_LOG.date("Ymd").".txt", "a");

// д־
// @fwrite($fp, date("Y-m-d H:i:s")."|$sqlrn");
// @fclose($fp);

$this->sql = $sql;

if ($tran)
{
$this->result = @mysql_query($this->sql) OR $this->RollBack();
return $this->result;
}
else
{
mysql_query("SET NAMES 'utf8'");
//mysql_query("SET NAMES 'gbk'");
$this->result = @mysql_query($this->sql);
return $this->result;
}
}

function RollBack()
{
$this->Query("ROLLBACK;");
die("MySQL ROLLBACK;");
}

function NumRows($result)
{
$this->result = $result;
return @mysql_num_rows($this->result);
}

function FetchRow($result)
{
$this->result = $result;
return @mysql_fetch_row($this->result);
}

function FetchArray($result)
{
$this->result = $result;
return @mysql_fetch_array($this->result, MYSQL_ASSOC);
}
function FetchArray2($result)
{
$this->result = $result;
return @mysql_fetch_array($this->result, MYSQL_BOTH);
}

function FetchObject($result)
{
$this->result = $result;
return @mysql_fetch_object($this->result);
}

function FreeResult($result)
{
$this->result = $result;
return @mysql_free_result($this->result);
}

function DataSeek($result)
{
//复位记录集指针
$this->result = $result;
return mysql_data_seek($this->result,0);
}

function InsertID()
{
//$this->con = $con;
return @mysql_insert_id($this->con);
}

function Close()
{
if($this->con)
{
@mysql_close($this->con);
}
}
}