PDO串連MySQL出錯解決方案

來源:互聯網
上載者:User
PDO串連MySQL出錯

$dbms = 'mysql';
$dbName = 'db_mrbook';
$user = 'root';
$pwd = '111';
$host = 'localhost';
$dsn = "$dbms:host = $host;dbname = $dbName";
try{
$pdo = new PDO($dsn,$user,$pwd);
echo "PDO連結資料庫成功";
}catch(Exception $e){
echo $e->getMessage()."
";
}
?>
運行時顯示could not find driver
修改了php.ini.dist和php.ini.recommended中的擴充,去掉了extension=php_mysql.dll、extension=php_pdo.dll和extension=php_pdo_mysql.dll前面的分號,重啟了Apache,還是同樣的錯誤,請大大幫幫忙阿

------解決方案--------------------
phpinfo() 看看是否載入成功
------解決方案--------------------
看看phpinfo()中的load configure file ,看看載入的是那個php.ini檔案
------解決方案--------------------
這樣就可以了
PHP code
PDOPDO support enabled PDO drivers  mysql, odbc, sqlite  pdo_mysqlPDO Driver for MySQL enabled Client API version  mysqlnd 5.0.8-dev - 20102224 - $Revision: 308673 $  PDO_ODBCPDO Driver for ODBC (Win32) enabled ODBC Connection Pooling  Enabled, strict matching  pdo_sqlitePDO Driver for SQLite 3.x enabled SQLite Library  3.7.4
------解決方案--------------------
你改的php.ini 是否是 Loaded Configuration File 對應的php.ini
  • 聯繫我們

    該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

    如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: 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

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

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

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.