Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- MySQL_connect() working in PHP4 not in PHP5?
May 30, 2006, 10:17 pm
rate this thread
I upgraded my development machine to PHP5. My pages with the subject
function no longer work. I am able to do an ODBC connect to the data
files from other programs.
I get the error:
Fatal error: Call to undefined function mysql_connect() in
<file.php> on line 190.
This is a W2K machine running IIS4, if that makes a difference...
Still works on server running PHP4.
Clues for me?
Many TIA - - --
Re: MySQL_connect() working in PHP4 not in PHP5?
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 system's PATH), it's not
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