PHP连接MYSQL数据库类

<?php
include "mysql.php";
$db = new Dirver();
$db->DBLink($dbhost='localhost', $dbuser='root', $password='password', $dbname='name', $pconnect=0);
?>

PHP连接MYSQL数据库类
mysql.php
<?php

Class Dirver{


 //连接数据库
 //link database
 function DBLink($dbhost='localhost', $dbuser='root', $password='', $dbname='', $pconnect=0){
 $this->LinkID[$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 "<html>
 <head>
 <meta http-equiv='Content-Type' content='text/html; charset=$charset'>
 <title>$lang[0]</title>
 </head>
 <body>
 </body>
 </html>
 <table style='BORDER-COLLAPSE: collapse;font-size:9pt;' borderColor='#a8b7c6' cellSpacing='1' width='100%' border='1' cellpadding='3' align='center'>
 <tr>
 <td bgColor='#F9F9F9' height='38' colspan='2'>
 $lang[0]</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[2]</td>
 <td bgColor='#F9F9F9'>$nowdate</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[3]</td>
 <td bgColor='#F9F9F9'>".$_SERVER['HTTP_HOST']."</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[4]</td>
 <td bgColor='#F9F9F9'>".$_SERVER['SERVER_NAME']."</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[5]</td>
 <td bgColor='#F9F9F9'>".$_SERVER['SERVER_SOFTWARE']."</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[6]</td>
 <td bgColor='#F9F9F9'>".$_SERVER['REMOTE_ADDR']."</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[7]</td>
 <td bgColor='#F9F9F9'>".$_SERVER['HTTP_USER_AGENT'].";</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[11]</td>
 <td bgColor='#F9F9F9'>".mysql_errno()."</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[12]</td>
 <td bgColor='#F9F9F9'>$errors</td>
 </tr>
 <tr>
 <td bgColor='#F9F9F9' width='165'>
 $lang[13]</td>
 <td bgColor='#F9F9F9'>$query</td>
 </tr>
 </table>
 </td>
 </tr>
 </table>";
 exit;
 }

}
?>

秒客网

PHP连接MYSQL数据库类

相关文章