欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

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

程序员文章站 2022-04-26 18:28:03
...
实用简单的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);
}
}
}