On Windows XP, after installing Apache HTTP Server 2.2.4, PHP 5.2.2, and MySQL Community Edition 5.0.37, I downloaded Zen Cart – an open-source PHP e-commerce web application as my friend is asking whether I can develop one for her. I encountered a database not supported error when installing it. After searching through Internet, eventually I solved the problem by using the following steps:

1. Download mysqli and mysql connector for PHP from http://dev.mysql.com/downloads/connector/php/

2. Extract both zip files and copy to C:\Program Files\PHP\extension (create “extension” folder if it’s not there). “extension” folder should contain “libmysql.dll”, “php_mysqli.dll”, and “php_mysql.dll”.

3. Open “php.ini” from C:\Program File\PHP.

4. Change extension_dir to extension_dir = “c:\program files\php\extension”

5. Ensure the following statements is in php.ini:

extension=php_mysql.dll
extension=php_mysqli.dll

6. Restart Apache.

7. Re-run Zen Cart installation wizard. Zen Cart should be installed without any error by now.

Related posts:

1. Passing value after pressing “Add to Cart” button in DataList