Call to undefined function mysql_connect()

bierpul

I run Apache/2.0.52 (Win32) / PHP 5.0.3 / MySQL 4.1.7 on Win XP SP2.

I'm pretty sure php/MySQL is working allright, since it's mentioned in the phpinfo() (see below)
and other php/MySQL applications, like phpBB work fine.

My code is: $conn = mysql_connect ('localhost', 'time', 'somepw');

I've read dozens of threads about this error 😕
but they what if php / MySQL is working properly?

I hope that someone can point me in the right direction.

Marc

phpinfo();
...
PHP Version 5.0.3
...
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.7
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout -1 -1
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

Deany

<?php
$db = mysql_connect ('localhost', 'enterusername', 'enterpassword')
      or die ("Unable to connect to Database Server");

mysql_select_db ('enterdatabasename', $db)
      or die ("Could not select database");
?>

Your script should now be connected to your database. Works for me.

Good luck !

tomhath

First, read the Sticky post at the top of this forum.

The next thing I'd do is check Apache's error log. Delete logs\error.log, restart Apache, and run your script. Whatever went wrong is likely to be there.

There's some good discussion of the error here:

http://www.php.net/manual/en/ref.mysql.php

babyloniantg

I'm guessing you didn't build PHP with the mysql module included. PHP5 doesn't include this module because it can sometimes cause errors. One way to solve this is to be sure that libmysql.dll and php_mysql.dll are in whatever folder all you PHP files are in (eg. C:\php), and include that folder in your system's path. Go here for instructions on how to do that.

For more informations go to the PHP manual's section on database issues.

Hope it helps.

bierpul

Thanks for the help.

Copying libmysql.dll to c:\windows and c:\windows\system32 solved the problem.
I followed instructions on http://www.php.net/manual/en/ref.mysql.php

deany: i tried your code, same error: Call to undefined function mysql_connect()

tomhath: i tried the code from the sticky thread:

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

Tis code-piece gives in the browser:
Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=php_mysql.dll in your php.ini
..and it gives in Zend IDE:
dl() is deprecated - use extension=php_mysql.dll in your php.ini

the Apache logs show no error info.

Deany

Nice one - great when it works eh?

😃 , thankfully I have an IT consultant who does most of my voluntary web development / programing for nothing (it's a charity website). I pick up a few tips from him and have quite a bit of code that I can look at, he he.

Glad u got it sorted. But hey, problems are normal.

Deany