Mysql 數(shù)據(jù)庫(kù)訪問(wèn)類(lèi)
2024-07-24 12:44:05
供稿：網(wǎng)友
/**
* @Purpose: Mysql數(shù)據(jù)庫(kù)訪問(wèn)類(lèi)
* @Package:
* @Author: lisen@sellingclub.cn
* @Modifications:
* @See:
* @Time: 2008.10.10
*/
class DB_MYSQL
{
//============================================================
private $Host = 'localhost';
private $Database = 'db_name';
private $User = 'user';
private $Password = 'password';
//============================================================
private $Link_Id = 0; //數(shù)據(jù)庫(kù)連接
private $Query_Id = 0; //查詢(xún)結(jié)果
private $Row_Result = array(); //結(jié)果集組成的數(shù)組
private $Field_Result = array(); //結(jié)果集字段組成的數(shù)組
private $Affected_Rows; //影響的行數(shù)
private $Rows; //結(jié)果集中記錄的行數(shù)
private $Fields; //結(jié)果集中字段數(shù)
private $Row_Postion = 0; //記錄指針位置索引
public $Insert_Id = 0;
//************************************************************
/**** 構(gòu)造函數(shù) ****/
function __construct()
{
$this->connect();
}
/**** 析構(gòu)函數(shù) ****/
function __destruct()
{
@mysql_free_result($this->Query_Id);
mysql_close($this->Link_Id);
}
/**** 連接服務(wù)器,選擇數(shù)據(jù)庫(kù) ****/
function connect($Database = '',$Host = '',$User = '',$Password = '')
{
$Database = $Database == '' ? $this->Database : $Database;
$Host = $Host == '' ? $this->Host : $Host;
$User = $User == '' ? $this->User : $User;
$Password = $Password == '' ? $this->Password : $Password;
//-----------------------------------------------------------//
if(0 == $this->Link_Id)
{
$this->Link_Id = @mysql_pconnect($Host,$User,$Password);
if(!$this->Link_Id)
{
$this->halt('連接數(shù)據(jù)庫(kù)服務(wù)端失敗!');
}
if(!mysql_select_db($this->Database,$this->Link_Id))
{
$this->halt('不能打開(kāi)指定的數(shù)據(jù)庫(kù)：'.$this->Database);
}
}
return $this->Link_Id;
}
/**** 釋放內(nèi)存 ****/
function free()
{
if(@mysql_free_result($this->Query_Id))
{
unset($this->Row_Result);
}
$this->Query_Id = 0;
}
/**** 執(zhí)行查詢(xún) ****/
function query($Query_String)
{
//釋放上次查詢(xún)內(nèi)存
if($this->Query_Id)
{
$this->free();
}
if(0 == $this->Link_Id)
{
$this->connect();
}
//設(shè)置中文字符集
@mysql_query('set names gb2312');
$this->Query_Id = mysql_query($Query_String,$this->Link_Id);
$this->Insert_Id = mysql_insert_id();
if(!$this->Query_Id)
{
$this->halt('SQL查詢(xún)語(yǔ)句出錯(cuò)：'.$Query_String);
}
@mysql_query('set names gb2312');
return $this->Query_Id;
}
/**** 將結(jié)果集指針指向指定行 ****/
function seek($pos)
{
if(@mysql_data_seek($this->Query_Id,$pos))
{
$this->Row_Position = $pos;
return true;
}
else
{
$this->halt('定位結(jié)果集發(fā)生錯(cuò)誤!');
return false;
}
}
