PHP 5 + MySQL Problem

Mr. Brightside · 15 May 2006 at 22:26

Not sure this is the right forum but it was my best gues...

I upgraded my server (Windows XP

) to the latest version of PHP 5 from PHP 4 today. Reason for doing so is I need some of the functionality for a script I'm making. However I now face the problem that no MySQL based stuff works; so that's two forums and a gallery down. Now of course I've enabled the MySQL extension and set the path right, and I know extensions are working because I've also enabled GD2 and it works perfectly.

The errors I get when trying to use any MySQL functionality basically say function not defined eg.

Code:

Fatal error: Call to undefined function mysql_connect()

What am I doing wrong? MySQL version is 4.1 if that's of any relevence. It always used to work fine with PHP4.

Thanks, null

zetec452 · 15 May 2006 at 23:52

I think its because php5 doesn't have native mysql support.

You need to manually add mysql to your php.ini (again i think).

Mr. Brightside · 16 May 2006 at 08:20

JonRohan said:
You need to manually add mysql to your php.ini (again i think).

What do you mean, again?

zetec452 · 16 May 2006 at 08:39

http://dbforums.com/showthread.php?t=1044828

Dj_Jestar · 16 May 2006 at 09:41

Everything is there, it's just not "on" by default.

You'll need to uncomment the php_mysql.lib file, and the other one (summin like libmysql.so or summat) in your php.ini.

yoda · 16 May 2006 at 10:01

libmysql.dll should be.... libmysql.so is for linux versions.....

Mr. Brightside · 16 May 2006 at 11:26

Thanks I've copied libmysql.dll to system32 now. Unfortunately I'm at school and so can't restart Apache 'till I'm home though. Also I did already have extension=php_mysql.dll uncommented.

Thanks, null

yoda · 16 May 2006 at 13:17

hang on.... on what PC have u installed PHP....?
It's supposed to go on the same PC as apache....

Mr. Brightside · 16 May 2006 at 13:43

It is on the same PC but I thought it shouldn't matter anyway

Reason I can move files around is I have a web based file manager running on it, so I used that to do what I could earlier

Problem is the school proxy server is fine with that but of course kills things like remote desktop. Which I would need to restart Apache.

edit - PHP install does need to be on same PC I know, and it is, misread your post and thought you said MySQL. Both PHP and MySQL are on same server.

Mr. Brightside · 16 May 2006 at 18:05

Just got back, restarted Apache and it's all working perfectly. Thanks all

Mr. Brightside · 16 May 2006 at 19:23

And now I've got the script that needed it working; my signature. Reason that PHP4 couldn't cut it is that no matter what I did, I could not access files with a URL; only from disk.

This was a problem because I have to use a URL to get the OcUK FAH stats file from the Stanford server for updates.

/ Randomness