当前位置:Gxlcms > PHP教程 > 实用简单的mysql数据库连接类_PHP教程

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

时间:2021-07-01 10:21:17 帮助过:3人阅读

实用简单的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);
}
}
}

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/630886.htmlTechArticle实用简单的mysql教程 数据库教程连接类 class DB { //database connection var $con = FALSE; function DB($MYSQL_HOST=MYSQL_HOST, $MYSQL_USER=MYSQL_USER, $MYSQL_PASS=MYSQL...

人气教程排行