PHP Warning: PHP Startup: Unable to load dynamic library 'D:\myserver\php\ext\php_mysql.dll' - 找不到指定模組。 PHP Fatal error: Call to undefined function mysql_connect()
; 確保 extension_dir 指向正確的 ext 目錄
extension_dir = "D:/myserver/php/ext"
; 啟用擴展(去掉分號)
extension=mysqli
extension=pdo_mysql
; extension=php_mysql.dll <-- PHP 7+ 刪除此行!
將 PHP 目錄下的以下 DLL **複製到系統目錄** 或 **添加 PHP 目錄到系統 PATH 環境變量**:
推薦做法:將 PHP 安裝目錄添加到**系統環境變量 PATH**,重啟 Apache/Nginx + PHP-FPM。
php -m | findstr /i mysql
# 或創建 info.php
<?php phpinfo(); ?>
// 在瀏覽器查看 "mysqli" "pdo_mysql" 區塊
代碼層面必須重寫,因為函數不存在了:
<?php
// 舊代碼 (PHP 5)
$conn = mysql_connect("localhost", "user", "pass");
mysql_select_db("dbname");
mysql_query("SET NAMES utf8");
// 新代碼 (PHP 7+ 推薦 PDO)
$dsn = "mysql:host=localhost;dbname=dbname;charset=utf8mb4";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$pdo = new PDO($dsn, "user", "pass", $options);
echo "連接成功";
} catch (PDOException $e) {
die("連接失敗: " . $e->getMessage());
}
// 或 mysqli 面向對象
$mysqli = new mysqli("localhost", "user", "pass", "dbname");
if ($mysqli->connect_errno) die("連接失敗: " . $mysqli->connect_error);
$mysqli->set_charset("utf8mb4");