[Resolved] Call to undefined function

piersk

Ok, I have a very wierd problem. I am running PHP 4.3.4 and MySQL 4.0.16, and I am getting Call to undefined function errors whenever I try to run any function that involves MySQL (i.e. [man]mysql_connect()[/man]).

The strange part comes about because I am running phpMyAdmin with no problems whatsoever.

Anyone come across this before? Cos I'm dead confused.

😕 <-- me being dead confused

tserbis

LXIII. MySQL Functions

Requirements
In order to have these functions available, you must compile PHP with MySQL support.

phpinfo(INFO_MODULES);

See MySQL Support.

piersk

Yeah, that would explain why it's not working, but how come phpMyAdmin works with no probs?

Oh, and I do have MySQL support installed (according to [man]phpinfo()[/man])

tserbis

And how much MySQLserver did you run? :-))

piersk

What do you mean how much?

What I am trying to get at is: surely phpMyAdmin needs to run [man]mysql_connect()[/man] to connect to the database. So how come I can't?

tserbis

Oh, I'm sorry.
So phpMyAdmin and your script run under the same PHP installation? (sorry for my English)
Hm...
Me being dead confused too...

piersk

Yes, they are. Thats the wierd thing about it all.

tsinka

Hi,

please post the code just to make sure ...

Additionally post the output of phpinfo().

Thomas

tsinka

Another idea ...

could it be that mysql support was compiled in as shared module ?
phpMyAdmin checks if mysql support is available as shared module and in that case loads the module with dl(...).

Thomas

piersk

Erm... dunno if it was compiled like that. I've been using Debian and just let apt do it for me (yes I know that's the easy way to do it, but I'm lazy). However, I've used apt before with no probs and I'm not sure if this explains why phpMyAdmin works but my other code doesn't. The only function I called is [man]mysql_connect()[/man].

Anyway, attached is my phpinfo output (its a text format cos you can't attach a .php file here)

Also, here is the following code that I'm using (just in case I'm being really stupid; it's been known to happen 😃 ):

<?php

$host = "localhost";
$user = "username";
$password = "password";
$db = "database";

$dbconnect = mysql_connect($host,$user,$password);
mysql_select_db($db);

?>

tsinka

Looks like a shared module ...

Looking at the configure options on top of the page:

'--with-mysql=shared'

Try to change your code to this using dl("mysql.so").
I'm not sure if it is "mysql" or something else but it should be mysql.

<?php 
dl("mysql.so");
$host = "localhost"; 
$user = "username"; 
$password = "password"; 
$db = "database"; 

$dbconnect = mysql_connect($host,$user,$password); 
mysql_select_db($db); 

?>

Additionally you can activate mysql support permanently by modifying php.ini. Somewhere in the php.ini there should be the following option that needs to be On:

enable_dl=On

somewhere below should be a section called Dynamic extensions:

Add

extension = mysql.so

and restart apache. MySQL should now be enabled globally.

Thomas

piersk

Thanks Thomas. Both your methods worked independantly of each other. I went with the second method so that I didn't have to remember to add the line all the time.

Thanks again.

shacker

FWIW, you can't use the dl() function on multithreaded webservers, which includes Apache 2. You have to use the extensions method.

In addition, I found that RedHat's RPM system was somewhat confused (as it often is). I did not have mysql.so in my extensions dir. And yet when I tried to install php-mysql, which is the RPM that includes mysql.so, it said it was already installed. By RPM'ing it in with --force and --nodeps the mysql.so module was properly installed. I was then able to use the extensions technique, restart httpd, and get mysql_connect() to work properly.

Argh.

AlChuck

Hi, I stumbled on this today, I'm new to PHP (been using Perl and MySQL for about 4 years).

I am getting the same behavior that piersk reported -- when I attempt a mysql_connect(), I get

Fatal error: Call to undefined function: mysql_connect()

I looked at php.ini, and it has both

enable_dl=On

and

extension = mysql.so

as tsinka suggested.

I'm using PHP 4.2.2 on RedHat 8 running Apache 2.0.40

shacker

AlChuck, see my post directly above. I'll bet that if you run

locate mysql.so

you come up with nothing. You need to get mysql.so installed in your PHP library somehow (I had to RPM it in with --force).

AlChuck

I saw your post, shacker... but in my case I do have mysql.so in my extensions dir. When I do locate mysql.so, I get

/usr/lib/php4/mysql.so

along with those for python, perl, and DBD-mysql in their various directories...

shacker

Ah, sorry. I guess the next step would be to verify (with phpinfo(); ) that PHP is actually looking in that location for libraries.

AlChuck

OK, let's see what that shows...

under Configuration/PHP Core

extension_dir is /usr/lib/php4 for both local and master values.

Are there any other relevant settings? None jump out at me.

piersk

What distribution are you running?

AlChuck

I installed it off the RedHat 8 CD-ROMs, it was one of the packages I selected.

I'm getting close to re-installing it fresh but if it's just something fairly simple I'd rather figure it out...