Thursday, February 5, 2009

解決 PHP連接 MySQL的問題 以及其他設定

解決 PHP連接 MySQL的問題 以及其他設定 
Fatal error: Call to undefined function mysql_connect()

環境: windows 2003 Apache/2.2.9 (Win32) PHP/5.2.6
  
1. 將PHP的路徑 (eq. C:\Program Files\PHP\ )設定到path  
2. 將libmySQL.dll放到C:\Program Files\PHP\
3. 修改php.ini 檔中的 extension_dir= "C:\Program Files\PHP\ext" (ext資料夾必定有"php_mysql.dll" and "php_mysqli.dll")
doc_root = "C:\Program Files\Apache Software Foundation\Apache2.2\htdocs"
extension=php_mysql.dll
5. 修改apache的設定檔httpd.conf, 使首頁可以辨認php : DirectoryIndex index.html index.php

#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL
PHPIniDir "C:/Program Files/PHP/"
LoadModule php5_module "C:/Program Files/PHP/php5apache2_2.dll"
AddType application/x-httpd-php .php
#END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL

6. 寫index.php測試一下所有參數是否正確 
  phpinfo(); 

No comments: