Iis6, Php5, Mysql, Winserver2003

rockroka

Operating system: Windows 2003 Server
PHP version: 5.0.
Problem Type: MySQL/PHP related

mysql_connect won't work on PHP5 + MYSQL5 + IIS6 + WIN 2003 SERVER

Description:

When calling mysql_connect(), running Windows 2003 Server + IIS6 + PHP5 +
MYSQL5, the function is not found.

Reproduce code:

Calling :
<? $connector = mysql_connect("localhost"); ?>

Returns :
Fatal error: Call to undefined function mysql_connect()

Expected result:

$connector should become an mysql-connection instance and not return any
errors.

i dont get it i have everything running! but cant seem to connect to the sql server to install my forum...

i have already added c:\php into my system path,
dropped off mysqli.dll and libmysql.dll into the system folder,
i even went one further and added the ext folder to the system path to no avail...
i understand i need to use --with-mysql[=DIR] somewhere but i dont know where to put it i have read all the manuals but they all omit the mysql/php/iis6 conduit issue.
there seems to be an issue with php5/mysql5 having to be compiled could someone explain how to do this im up for the task it has taken me a month to get this together and i cant quit now... please help!

drew010

PHP.NET wrote:
PHP 5+

MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying libmysql.dll to the Windows system directory also works (because the system directory is by default in the systems PATH), it's not recommended.

As with enabling any PHP extension (such as php_mysql.dll), the PHP directive extension_dir should be set to the directory where the PHP extensions are located. See also the Manual Windows Installation Instructions. An example extension_dir value for PHP 5 is c:\php\ext

also depending on your mysql version, you may want to see http://php.net/manual/en/ref.mysqli.php

rockroka

i have read the manuals for both php and sql but they tech based manuals for programmers not newbies so what i need to know is exactly how to connerct mysql5 to php5 i have all the dlls in the proper places and env variables set for mysql and php to no avail. what am i doing wrong php says its up and so does sql so what in the hell is going on here? :mad:

drew010

if php says mysql_connect is an undefined function, it means php_mysql.dll isnt enabled inside the php.ini file, as explained in the above quote.