【www.gdgbn.com--mysql教程】

PHP连接MYSQL数据库类
mysql.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 "
 
 
 
 
 
 
 
 
         
           
            $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.gdgbn.com/shujuku/22388/