昨天幫一朋友設定管理員結果發現apache日誌中有PHP Warning: PHP Startup: Unable to load dynamic library 提示了,然後調試資料庫連接發現提示Call to undefined function mysql_connect()錯誤,這樣就想到了是mysql沒有載入成功了,下面我們一起來看看問題解決辦法。
-
-
串連代碼
echo 'a';
$cn = mysql_connect("localhost",'www.bKjia.c0m','你的mysql使用者密碼') or die(mysql_error());
if( $cn )
{
echo phpinfo();
}
else
{
echo 'mysql connect fail';
}
?>
因為伺服器使用的是安全php.ini所在沒有錯誤顯示,於時相看了apache安裝目錄的logs的errors.log日誌文
件發現如下錯誤
PHP Warning: PHP Startup: Unable to load dynamic library
'D:\myserver\php\ext\php_mysql.dll' - xd5xd2xb2xbbxb5xbdxd6xb8xb6xa8xb5xc4xc4
xa3xbfxe9xa1xa3rn in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'D:\myserver\php\ext\php_mysqli.dll' - xd5xd2xb2xbbxb5xbdxd6xb8xb6xa8xb5xc4
xc4xa3xbfxe9xa1xa3rn in Unknown on line 0
[Tue Dec 31 09:05:15 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 2, referer: www.bKjia.c0m[Tue Dec 31 09:05:16 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 2, referer: http://localhost/
[Tue Dec 31 09:05:17 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 2, referer: http://localhost/
[Tue Dec 31 09:06:04 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 3, referer: http://localhost/
[Tue Dec 31 09:06:05 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 3, referer: http://localhost/
[Tue Dec 31 09:06:05 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 3, referer: http://localhost/
[Tue Dec 31 09:06:05 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 3, referer: http://localhost/
[Tue Dec 31 09:06:06 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 3, referer: www.bKjia.c0m
[Tue Dec 31 09:06:06 2013] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined
function mysql_connect() in E:\www\a.php on line 3, referer: http://localhost/
日誌中有這麼一句
PHP Startup: Unable to load dynamic library 'D:\myserver\php\ext\php_mysql.dll' 這個意思是
沒有載入成功php_mysql檔案了,還有一點是提示 PHP Fatal error: Call to undefined function
mysql_connect(),,這個是mysql沒有串連成功也就是載入mysql庫失敗了,根據分析有兩種可能一是檔案不
存在,這個問題不存因為我以前用的是這個php解壓包,2是伺服器環境變數問題,如果是環境變數有兩種解
決辦法
1,是直接在windows增加環境變數
2,直接把在d:PHP裡找到php5ts.dll,libmysql.dll將其複製到c:/winnt/system32下(winNT/2000的機器),
而winXP/2003是複製到c:/windows/system32下即可
記住複製到system目錄之後必須重記apache環境,如我再測試http://localhost/a.php 就可以看到
輸出的phpinfo相關資訊了,本站原創文章轉載註明來源www.bKjia.c0m
更多詳細內容請查看:http://www.bKjia.c0m/phper/linux-php/56512.htm
http://www.bkjia.com/PHPjc/633810.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/633810.htmlTechArticle昨天幫一朋友設定管理員結果發現apache日誌中有PHP Warning: PHP Startup: Unable to load dynamic library 提示了,然後調試資料庫連接發現提示Call to u...