Undefined function mysqli_connect()

jonmc21

OK, I know this has been brought up a few times here but couldn't find any thing on my exact problem.

Windows XP
PHP5
mySql 4.0

<html>
<body>

<?php
if (!class_exists('mysql')) {
if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
dl('php_mysql.dll');
else
dl('php_mysql.so');
}
?>

<?php
$link = mysqli_connect("localhost", "user", "password", "mydb");

/* check connection */
if (!$link) {
   printf("Connect failed: %s\n", mysqli_connect_error());
   exit();
}

printf("Host information: %s\n", mysqli_get_host_info($link));

/* close connection */
mysqli_close($link);
?>

</body>
</html>

Here is the errors that I get

Warning: dl() [function.dl]: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found. in c:\Inetpub\wwwroot\php\mysql.php on line 7

Fatal error: Call to undefined function mysqli_connect() in c:\Inetpub\wwwroot\php\mysql.php on line 14

I have enabled the extension=php_mysql.dll in the php.ini-recomended file. Should I also enable it in the php.ini-dist file. How does php know which ini file to use?

Thanks
Jon

tsinka

Hi,

first of all, copy one of the two example php.ini file to your windows directory (windows/winnt) and rename it to php.ini.
Inside that file modify
extension_dir = "./"
to e.g.
extension_dir = "c:\php5\ext"

(assuming that you have installed php5 to c:\php5.

The extensions are only available with the zip package, not the installer.

Then enable the extension(s) you need as you already did. But this only works with a valid php.ini in your windows directory.

Create a phpinfo script to check where php expects the php.ini file to be.

If you want to use mysql function use php_mysql.dll, if you want to use mysqli choose php_mysqli.dll.

Loading php_mysql.dll and using mysqli_connect doesn't work.

Thomas

jonmc21

Hey that work.

Thank you,
Jon