Tools

PHP drivers for MySQL (Windows)

Author: Edward Hardin Reference Number: AA-00716 Views: 13018 Last Updated: 05/30/2012 05:03 PM

0 Rating/ Voters

You can use either mysqli or pdo_mysql PHP extension for connecting to the MySQL server. The instructions are simple, as follows.

Recommendation

We strongly recommend to use mysqli extension because pdo_mysql has some unresolved issues at the moment.

mysqli

The php_mysqli.dll DLL must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in c:\php), and make sure you remove the comment (semi-colon) from the start of the line:

extension=php_mysqli.dll

Then you need to save the php.ini and restart the web server.

pdo_mysql

The php_pdo_mysql.dll DLL must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in c:\php), and make sure you remove the comment (semi-colon) from the start of the line:

extension=php_pdo_mysql.dll

Then you need to save the php.ini and restart the web server.