PHP/MySQL problems

[Maniaman]

I'm having some problems with my Install of PHP and MySQL.

On a PHP sciprt I made I need it to connect to MySQL.
I keep getting this error:
Fatal error: Call to undefined function: mysql_connect() in /var/www/html/register1.php on line 21

Here's Line 21 of that file

mysql_connect("localhost", "root", "*");

*Password Removed

It works on other builds of PHP...

Also, where does MySQL keep all of it's configuration? (Stupid question)

[voidmain]

What distro please?  If it's Red Hat you'll need to install the "php-mysql" RPM from your CD. The equivalent of that will need to be installed on any other Linux distro. And of course MySQL has to be installed but I am sure you know that. It would depend on what distro you are using as the where it's configuration files are.

[ December 18, 2002: Message edited by: void main ]

[Maniaman]

Distro = Linux Mandrake 9.0

I also have installed the php-mysql rpm

[ December 19, 2002: Message edited by: Maniaman ]

[KernelPanic]

quote:Originally posted by Maniaman:
I'm having some problems with my Install of PHP and MySQL.

On a PHP sciprt I made I need it to connect to MySQL.
I keep getting this error:
Fatal error: Call to undefined function: mysql_connect() in /var/www/html/register1.php on line 21

Here's Line 21 of that file

mysql_connect("localhost", "root", "*");

*Password Removed

It works on other builds of PHP...

Also, where does MySQL keep all of it's configuration? (Stupid question)

Haa it connected before on another page, have you made a simple sql connection test?

[voidmain]

And you have MySQL and MySQL-client RPMs installed? And the MySQL server is up and running? And you have php and php-common RPMs installed?

I don't have Mandrake 9.0, this stuff just works when installed on Red Hat. I haven't found anything on the web to indicate it should be any harder than this on Mandrake. Sorry if I haven't been much help.

P.S. You never would want to use "root" and root's real Linux password in a PHP script.

P.S.S. I notice Mandrake breaks out Apache into more RPMS. I don't know if these are needed but other RPMs you might want to make sure are installed are:

apache-common
apache-conf
apache-modules

[ December 19, 2002: Message edited by: void main ]

[Maniaman]

This is the first script that I've used with MySQL...

I'm a n00b when it comes to stuff like this so what's a connection test? If it's a script that just tries to connect to MySQL, then no. That doesn't work

[KernelPanic]

Try this one:

Code: [Select]

delete the (REMOVEME)

[KernelPanic]

Also, is mysql actually running?

can you do
$ mysqladmin ping
for me?

[voidmain]

The thing that leads me to believe he doesn't have all the necessary RPMs installed is it says mysql_connect() is an undefined function. That should be part of php-mysql. I would think he would get a different error if it recognized the function but was improperly used.

[KernelPanic]

quote:Originally posted by void main:
The thing that leads me to believe he doesn't have all the necessary RPMs installed is it says mysql_connect() is an undefined function. That should be part of php-mysql. I would think he would get a different error if it recognized the function but was improperly used.

Hmm, good point.
Maniaman I would install Mandrake98.0 and take a look at this for you, but my mandrake 9 CD's don't work so I said fsck it...

[KernelPanic]

and if anybody say's you can't fsck a CD I will kill you because that would be a poor attempt at comedy.

[KernelPanic]

Maniaman, download and install this or get it off your CD.

ftp://ftp.mirror.ac.uk/sites/sunsite.uio.no/pub/unix/Linux/Mandrake/Mandrake/9.0/i586/Mandrake/RPMS/php-mysql-4.2.3-1mdk.i586.rpm

[Maniaman]

I already have that package installed Tux... It still wont work.

[voidmain]

Do me a huge favor and tell me what is the output of this command:

$ rpm -qa | grep -i mysql

[Maniaman]

libmysql10-3.23.52-1mdk
perl-Mysql-1.22_19-5mdk
php-mysql-4.2.3-1mdk
MySQL-3.23.54a-1