<newbie>mySQL_connect function question

ludwig

I have about a years worth of experience doing basic things with PHP like database connectivity. I wrote a very simple script to access a mySQL database and I am getting the following error:

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/myscript.php on line 12

I have no idea why this is happening. I am using Linux porky.devel.redhat.com 2.2.17-8smp #1 SMP Fri Nov 17 16:12:17 EST 2000

I am also using PHP Version 4.0.4pl1.

I do not have telnet access to the box to determine the version of mySQL being used.

I assumed that with most builds of Linux that you get pretty much all of the libraries
covered in the documentation. Could this error have come from:

a) The function library containing mysql_connect being missing or
b) bad information (like an improper username) being fed to the function.

Any help on this matter would be highly appreciated.

amcgrath

Just outta curiosity, can you check the php config (use the phpinfo() function) to see if mysql support is there?

ludwig

Where would that information be in the PHPINFO screen?

There is no mySQL section in this screen, unlike other installations of PHP that I have used this on...hmmm...

amcgrath

phpinfo();

will display a bunch of info regarding the server set up. (call it php.php in the root dir and hit it with a browser). The confi info is one of the first things displayed....

ludwig

Yup, that's what I did...

here is the page:

http://www.myuoo.com/Admin/phpinfo.php

ludwig

I checked in the /usr/lib/php4/ directory on the linux box and only two .so files were there:

imap.so
ldap.so

I looked in these threads and found a reference to uncommenting lines that said

extensions = mysql.so

We uncommented out those lines and restarted the server. PHP stillw orks ok, but the librairies were still missing. Is it possible to get the mysql65.so, mysql70.so and mysql.so files from somewhere and just copy them over and restart the box or will that work?

amcgrath

From your config: '--without-mysql' a translation of this config option literally means "without mysql". You need to compile php "--with-mysql' if you want to use mysql...

ludwig

Thanks man! We are getting in a Linux/PHP installation dude to fix that right now!