[Resolved] Apache2, PHP5 and MySQL - obscure error

d_north

I've just set up an Apache2 server on my XP home computer with mysql 4.2.1 and php 5.
PHP loads into apache as a module, but the mysql functions return an error like this:

Fatal error: Call to undefined function mysql_pconnect()

The strange thing is, running the same script from the command line seems to work fine - so it's not the usual problem of PHP not having the mysql extension enabled.

Any ideas anyone?

RossC0

PHP5 uses improved mysql functions:

checkout: http://www.php.net/mysqli

d_north

Thanks, switching to the mysqli functions works fine.

Unfortunately, I'm intending to use this server as a test rig for new pages for a site which is hosted remotely, and my web host is only running PHP4, so there's no mysqli support. This means I'd have to edit all my scripts back to the old functions before upload.

Is there likely to be a simple way to get the old mysql functions to work with PHP5 through apache rather than just the command line, or should i try going back to apache 1.3 and php4?

RossC0

Hi,

Yeah - its a bummer - but what version of mysql does your host have ??

If its over 4.1 it should work with php4 - as long as its compiled. You could do a test page to check.

If not then best bet is to install Apache1.3 and setup php4 with it - then you can have both php4 and php5 (so you can play with the new functions 😃 )- depending on which Apache your running...

d_north

😃 FIXED IT!!!

I did a quick test to see if my host had the mysqli support, but apparently not.

I then wasted all afternoon trying to find what was wrong. Looking at the phpinfo() output on the command line as compared to a straight web page on the server seemed to indicate that the apache module wasn't reading php.ini properly. But despite all my digging and poking, I only succeded in making things worse, and having to hastily backtrack.

Finally, wondering if I'd set it up wrongly in the first place, I found a set of instructions on the PHP website.

Setting up PHP in CGI mode rather than as an Apache module did the trick. It was a complete shot in the dark, and as the instructions warn, this isn't a good idea on live web servers, but that isn't an issue for me as I'm only using this server for testing on my internal network. And if it was a live server, you'd be able to use the mysqli functions and load PHP as a module.

So, thread resolved. Thanks for your suggestions😉