weird PHP problem: Call to undefined function mysql_connect()

Shioni · 12-04-2006, 02:50 PM

Hi!
I installed apache 2.2.3 and PHP 5.2.0. The PHP at first didn't work, so I configured httpd.conf and it still didn't work!

The weirdest thing, is when I removed php.ini from /etc/apache2/
PHP started to work. When I put it back, it doesn't and I get completely no output on Firefox and Konqueror, even not the source code, but when I view pages source, then I can see my PHP.

Another weird thing is when I try to connect to mysql, I get:

Code:

Call to undefined function mysql_connect()

but in phpinfo(); I got:

Code:

'--with-mysql=shared,/usr' '--with-mysqli=shared' '--with-ncurses' '--with-unixODBC=shared,/usr' '--enable-pcntl' '--with-pdo-firebird=shared' '--with-pdo-mysql=shared'

but there is no more output about mysql. I guess it means, it was compiled, without mysql support.. or am I missing something? Thank you!

sheryco · 12-21-2006, 04:46 AM

What is your output of php modules

Quote:

#php -m

or you can check if you install it via source and see if it was installed with mysql

Quote:

#php -i | egrep configure

Or if you have one of those OS's with package installers check if you have php-mysql package is installed.

nnadithya · 12-21-2006, 08:46 AM

hi

this is the default syntax mysql_connect("hostname","root","");

the last part is your root password for mysql if not set just use as given above mostly this is your problem

bye

Shioni · 12-21-2006, 08:23 PM

Thanks! OK, I compiled from source and everything now works!

Quote:

Originally Posted by nnadithya

hi

this is the default syntax mysql_connect("hostname","root","");

the last part is your root password for mysql if not set just use as given above mostly this is your problem

bye

Actualy then PHP would give me error message about arguments, and I'm sure that it wasn't syntax fault..

nnadithya · 12-22-2006, 05:26 AM

i actually encountered the same problem some time back and it was because i missed the password field and for my surprise there was no syntax error message but said
Call to undefined function mysql_connect()

ok any way urs may be not that case