php连接mysql数据库类
mysql.php
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[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;
  }}
?>