PHP串連MYSQL資料庫通用類_PHP教程

DBLink($dbhost='localhost', $dbuser='root', $password='password', $dbname='name', $pconnect=0);?> PHP串連MYSQL資料庫類 mysql.phpLinkID[$this->Line] = ($pconnect == 1)? @mysql_pconnect($dbhost, $dbuser, $password) : @mysql_connect($dbhost, $dbuser, $password) or die("Connect to MySQL ($dbhost,$dbuser) failed"); //選擇串連資料庫 //choose to link database @mysql_select_db($dbname, $this->LinkID[$this->Line]) or die('Cannot use database '.$dbname); return $this->LinkID[$this->Line]; } //查詢語句 //view qurry function query($query,$limit='') { $this -> nums ++; //檢測如果有限制資料集則處理 //test if there is finite data,then function if($limit>0){ $query = $query.' LIMIT '.$limit; } $this-> Lists[$this->Line][] = $query; $querys = mysql_query($query,$this->LinkID[$this->Line]); if(!$querys){ $this->DB_Error($query); } return $querys; } //返回數組資料 //back to array info function fetch_array($query) { return @mysql_fetch_array($query, MYSQL_ASSOC); } //返回數組資料 //back to array info function result($query) { return @mysql_result($query,$this->LinkID[$this->Line]); } //返回數組資料行 //back to row info function rows($query) { return $this->fetch_array($this->query($query)); } //返回數組行 //back to numrows function nums($query) { return $this->num_rows($this->query($query)); } //取得返回列的數目 //fetch the numbers backing out function num_rows($query){ return @mysql_num_rows($query); } //返回單列的各欄位 //return to every field of single row function fetch_row($query) { return @mysql_fetch_row($query); } //返回最後一次使用 INSERT 指令的 ID //return to inserted ID used last time function insert_id(){ return @mysql_insert_id($this->LinkID[$this->Line]); } //關閉當前資料庫連接 //close current database link function close(){ return @mysql_close($this->LinkID[$this->Line]); } //檢測mysql版本 //test mysql version function version(){ $query = @mysql_query("SELECT VERSION()",$this->LinkID[$this->Line]); return @mysql_result($query, 0); } //返回友情提示資訊 更多http://www.52mvc.com //return to kindly note function DB_Error_t($query=''){ } function DB_Error($query=''){ global $PHP_SELF; //出錯語句提示 //error sentence $errors = preg_replace("/'(.+?)'/is"," ' //1' ",mysql_error()); $charset =''; //提示言 //language noted $lang = Array('This SQL Error Info!', 'Error Script:', 'Present time:', 'Http Host:', 'Server Name:', 'Server Software:', 'Host IP Address:', 'Remote User Agent:', 'Current File:', 'Current Line:', 'Line.', 'The Error number:', 'The specific Error was:', 'SQL Query :', 'Not discover whateverly SQL Sentence ！'); //時間處理 //time $nowdate = date('Y-m-d H:i A'); $errors = preg_replace("/'(.+?)'/is","' //1'",mysql_error()); //檢測是否有語句 //test if there is any sentence. if($query==''){ $query = $lang[14]; } echo " $lang[0]

$lang[0]
$lang[2]	$nowdate
$lang[3]	".$_SERVER['HTTP_HOST']."
$lang[4]	".$_SERVER['SERVER_NAME']."
$lang[5]	".$_SERVER['SERVER_SOFTWARE']."
$lang[6]	".$_SERVER['REMOTE_ADDR']."
$lang[7]	".$_SERVER['HTTP_USER_AGENT'].";
$lang[11]	".mysql_errno()."
$lang[12]	$errors
$lang[13]	$query

"; exit; } }?> PHP串連MYSQL資料庫類DBLink($dbhost='localhost', $dbuser='root', $password='password', $dbname='name', $pconnect=0);?> PHP串連MYSQL資料庫類 mysql.phpLinkID[$this->Line] = ($pconnect == 1)? @mysql_pconnect($dbhost, $dbuser, $password) : @mysql_connect($dbhost, $dbuser, $password) or die("Connect to MySQL ($dbhost,$dbuser) failed"); //選擇串連資料庫 //choose to link database @mysql_select_db($dbname, $this->LinkID[$this->Line]) or die('Cannot use database '.$dbname); return $this->LinkID[$this->Line]; } //查詢語句 //view qurry function query($query,$limit='') { $this -> nums ++; //檢測如果有限制資料集則處理 //test if there is finite data,then function if($limit>0){ $query = $query.' LIMIT '.$limit; } $this-> Lists[$this->Line][] = $query; $querys = mysql_query($query,$this->LinkID[$this->Line]); if(!$querys){ $this->DB_Error($query); } return $querys; } //返回數組資料 //back to array info function fetch_array($query) { return @mysql_fetch_array($query, MYSQL_ASSOC); } //返回數組資料 //back to array info function result($query) { return @mysql_result($query,$this->LinkID[$this->Line]); } //返回數組資料行 //back to row info function rows($query) { return $this->fetch_array($this->query($query)); } //返回數組行 //back to numrows function nums($query) { return $this->num_rows($this->query($query)); } //取得返回列的數目 //fetch the numbers backing out function num_rows($query){ return @mysql_num_rows($query); } //返回單列的各欄位 //return to every field of single row function fetch_row($query) { return @mysql_fetch_row($query); } //返回最後一次使用 INSERT 指令的 ID //return to inserted ID used last time function insert_id(){ return @mysql_insert_id($this->LinkID[$this->Line]); } //關閉當前資料庫連接 //close current database link function close(){ return @mysql_close($this->LinkID[$this->Line]); } //檢測mysql版本 //test mysql version function version(){ $query = @mysql_query("SELECT VERSION()",$this->LinkID[$this->Line]); return @mysql_result($query, 0); } //返回友情提示資訊 //return to kindly note function DB_Error_t($query=''){ } function DB_Error($query=''){ global $PHP_SELF; //出錯語句提示 //error sentence $errors = preg_replace("/'(.+?)'/is"," ' //1' ",mysql_error()); $charset =''; //提示言 //language noted $lang = Array('This SQL Error Info!', 'Error Script:', 'Present time:', 'Http Host:', 'Server Name:', 'Server Software:', 'Host IP Address:', 'Remote User Agent:', 'Current File:', 'Current Line:', 'Line.', 'The Error number:', 'The specific Error was:', 'SQL Query :', 'Not discover whateverly SQL Sentence ！'); //時間處理 //time $nowdate = date('Y-m-d H:i A'); $errors = preg_replace("/'(.+?)'/is","' //1'",mysql_error()); //檢測是否有語句 //test if there is any sentence. if($query==''){ $query = $lang[14]; } echo " $lang[0]

$lang[0]
$lang[2]	$nowdate
$lang[3]	".$_SERVER['HTTP_HOST']."
$lang[4]	".$_SERVER['SERVER_NAME']."
$lang[5]	".$_SERVER['SERVER_SOFTWARE']."
$lang[6]	".$_SERVER['REMOTE_ADDR']."
$lang[7]	".$_SERVER['HTTP_USER_AGENT'].";
$lang[11]	".mysql_errno()."
$lang[12]	$errors
$lang[13]	$query

"; exit; } }?>

http://www.bkjia.com/PHPjc/477775.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/477775.htmlTechArticle?php include mysql.php; $db = new Dirver(); $db-DBLink($dbhost=localhost, $dbuser=root, $password=password, $dbname=name, $pconnect=0); ? PHP串連MYSQL資料庫類 mysql.php ?php...

