// 錯誤:第二次 connect 會復用第一個連接資源,導致後續操作都在最後一個庫
$conn1 = mysql_connect('localhost', 'root', '111111');
mysql_select_db('db1', $conn1);
$conn2 = mysql_connect('localhost', 'root', '222222'); // 實際復用 conn1
mysql_select_db('db2', $conn2); // db1 也被切換到 db2
mysql_connect 第 4 參數 $new_link = true 強制創建新連接資源:
// 數據庫 1
$conn1 = mysql_connect('localhost:3306', 'root', '111111', true);
mysql_select_db('db1', $conn1);
mysql_query("SET NAMES utf8", $conn1);
// 數據庫 2
$conn2 = mysql_connect('localhost:3306', 'root', '222222', true);
mysql_select_db('db2', $conn2);
mysql_query("SET NAMES utf8", $conn2);
// 後續查詢顯式指定連接
mysql_query("SELECT * FROM t1", $conn1);
mysql_query("SELECT * FROM t2", $conn2);
// 配置數組
$dbs = [
'main' => ['dsn' => 'mysql:host=localhost;dbname=main;charset=utf8mb4', 'user' => 'root', 'pass' => '111111'],
'log' => ['dsn' => 'mysql:host=localhost;dbname=log;charset=utf8mb4', 'user' => 'root', 'pass' => '222222'],
];
// 建立連接池
$pdos = [];
foreach ($dbs as $name => $cfg) {
$pdos[$name] = new PDO($cfg['dsn'], $cfg['user'], $cfg['pass'], [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
]);
}
// 使用
$stmt = $pdos['main']->query('SELECT * FROM users');
$logs = $pdos['log']->query('SELECT * FROM access_log LIMIT 10');
class DbManager {
private static $instances = [];
public static function get(string $name): PDO {
if (!isset(self::$instances[$name])) {
$cfg = Config::get("database.{$name}"); // 從配置讀取
self::$instances[$name] = new PDO($cfg['dsn'], $cfg['user'], $cfg['pass'], [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);
}
return self::$instances[$name];
}
}
// 業務代碼
$mainDb = DbManager::get('main');
$logDb = DbManager::get('log');
mysql_* 必須加 true 參數強制新連接,且每次查詢傳 $conn。