PHP串連MYSQL資料庫類

最後更新：2017-01-13 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

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;
}

}
?>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More