Installing PHP on Windows

By Michael J. Ross
2008-03-05


Adding MySQL

This final section of the tutorial is for those readers who have installed the MySQL database server. For detailed instructions on how to add MySQL to your development environment, please see my tutorial titled "Installing MySQL on Windows".

In order for MySQL to be able to communicate with PHP, you need to add some dynamic link library (DLL) files to your Apache setup. First verify that the extensions directory for PHP — in this tutorial, "C:\_a\PHP\ext" — contains the two needed DLL files: php_mysql.dll and php_mysqli.dll. Then confirm that the following lines have been added to your PHP configuration file, C:\_a\PHP\php.ini (probably at the very bottom), by the PHP Setup Wizard:

extension=php_mysql.dll  extension=php_mysqli.dll

Next, copy the DLL file libmySQL.dll from C:\_a\MySQL\bin to C:\WINDOWS\system32. Restart your Apache service.

To verify that everything works, in your Web browser go to http://localhost/phpinfo.php, which should now contain two new sections, labeled "mysql" and "mysqli". With the heading "MySQL".

Tutorial Pages:
» Introduction
» PHP Already Installed?
» Downloading PHP
» Testing PHP
» Adding MySQL
» MySQL Versions of DLLs
» XAMPP

Related Tutorials: » Port Scanning and Service Status Checking in PHP » Web Database Access from Desktop Applications » CubeCart 3.0 Installation and Configuration » PHP Site Search Made Easy » Installing and Configuring Drupal 6.1 » Desktop Application Development with PHP-GTK