此類別封裝 mysql_* 函數 (註:PHP 7.0+ 已移除,建議遷移至 PDO/MySQLi),提供:
halt() 機制、錯誤代碼/訊息封裝function connect($host, $user, $pw, $dbname='', $pconnect=0, $halt=true, $charset='') {
$func = $pconnect ? 'mysql_pconnect' : 'mysql_connect';
if (!$this->link = @$func($host, $user, $pw, true)) {
$halt && $this->halt('Can not connect to MySQL server');
return;
}
// MySQL 4.1+ 字元集與 SQL 模式自動配置
if ($this->version() > '4.1') {
$charset = $charset ?: $GLOBALS['dbcharset'];
$set = $charset ? "character_set_connection=$charset, character_set_results=$charset, character_set_client=binary" : '';
$set .= $this->version() > '5.0.1' ? (($set ? ',' : '') . "sql_mode=''") : '';
$set && mysql_query("SET $set", $this->link);
}
$dbname && @mysql_select_db($dbname, $this->link);
}
function query($sql, $type='') {
global $debug, $discuz_starttime, $sqldebug, $sqlspenttimes;
if (defined('SYS_DEBUG') && SYS_DEBUG) {
include_once DISCUZ_ROOT.'./include/debug.func.php';
sqldebug();
}
$func = ($type=='UNBUFFERED' && function_exists('mysql_unbuffered_query'))
? 'mysql_unbuffered_query' : 'mysql_query';
if (!($query = $func($sql, $this->link))) {
// 自動重連機制
if (in_array($this->errno(), [2006, 2013]) && strpos($type, 'RETRY') !== 0) {
$this->close();
require DISCUZ_ROOT.'./config.inc.php';
$this->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);
return $this->query($sql, 'RETRY'.$type);
}
if ($type != 'SILENT' && strpos($type, 'SILENT') === false) {
$this->halt('MySQL Query Error', $sql);
}
}
$this->querynum++;
return $query;
}
fetch_array($query, MYSQL_ASSOC) // 關聯陣列
fetch_first($sql) // 單行關聯陣列
result_first($sql) // 單一欄位值
num_rows($query) // 列數
affected_rows() // 影響行數
insert_id() // 自增 ID (支援 last_insert_id())
free_result($query) // 釋放資源
此類別基於已移除的 mysql 擴展,建議重構為 PDO 版本:
class Database {
private PDO $pdo;
public function __construct(string $dsn, string $user, string $pass, array $options=[]) {
$this->pdo = new PDO($dsn, $user, $pass, $options + [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
]);
}
public function query(string $sql, array $params=[]): PDOStatement {
$stmt = $this->pdo->prepare($sql);
$stmt->execute($params);
return $stmt;
}
// 其餘方法對應 PDOStatement::fetchAll(), rowCount(), lastInsertId() 等
}
beginTransaction()/commit()/rollBack()PDO::ATTR_PERSISTENTPDO::ATTR_ERRMODE + 自訂事件監聽