How to get PHP to work with ADOdb and MySQL?

Question

I am trying to get a PHP site running in IIS on Windows Server with MySQL.

I get this error & hellip;

Fatal error: call to undefined function mysql_connect () in C: \ inetpub ... \ adodb \ drivers \ adodb-mysql.inc.php on line 363

---

Update & hellip;

This link describes the steps that I took to install PHP on my server:
How to get PHP and MySQL to work with IIS 7.0? (note in particular steps 6 and 8 regarding php.ini and php_mysql.dll).

Only two lines in phpinfo SQL report report:

<?php phpinfo(); ?> 

Set up a command:
cscript / nologo configure.js "--enable-snapshot-build" "--enable-mysqlnd"

sql.safe_mode:
Local value off, Main value off.

PHP Configure Command http://img79.imageshack.us/img79/2373/configurecommandmw8.gif

PHP sql.safe_mode http://img49.imageshack.us/img49/3066/sqlsafemoderu6.gif

---

Update & hellip;

I found a solution: How to install MySQL modules in PHP?

Answer 1

I found a solution: How to install MySQL modules in PHP?

Answer 2

Phpinfo will open to find out if mysql functions are compiled with your PHP

 <?php phpinfo(); ?> 

Since in some versions of php this is not the default installation.

Edit to update:

You must have the full MySQL category in your phpinfo ();

See this, for example: https://secure18.easycgi.com/phpinfo.php (example for Google)

Answer 3

It looks like the version of PHP you used was not compiled with MySQL support or was not included in php.ini.

Answer 4

It looks like you have no MySQL PHP extensions! You do not need to make any settings other than installing the correct modules (and should not do anything with ADODB).

PHP also comes in two versions - the CGI version and the ISAPI module. It is best to use the ISAPI version with ISS and add all the cropping ...