mysql_connect problem on RedHat Linux 9

rcmehta_14

Im facing a very basic problem when migrating from PHP 4.3 and MySQL 4.0.12 with Apache 2.* on RedHat Linux 9.

My old configuration was PHP 4.0.6 and MySQL 3.23.56 with Apache 1.* on RedHat Linux 7.3.

The problem is with mysql_connect(host, usrname, pwd) return value.

I used the following code for connection to MySQL server.

$conn = @mysql_connect(host, usrname, pwd)
if((int)$conn == 1){
.......
}

Now the problem is that my old configuration returns 1 with (int)$conn and new configuration returns 2 with the same statement. Therefore my old PHP scripts doesn't work with this new configuration. As no. of scripts already developed are in large number, it would take much effort to modify them. Is there any way out?

Also I have checked the same new configuration on windows 98 and it works fine i.e. it returns 1 but not on RedHat Linux 9.

Please help me. Thanx in advance

laserlight

Returns a MySQL link identifier on success, or FALSE on failure.

If you are only checking if the connection was made, dont bother with typecasting to integer etc.

Now, you can either test for not false then display error message else display as normal, or with you current config you can hope that non-zero values are true always works, in which case remove the testing for equality with 1, i.e.

$conn = @mysql_connect(host, usrname, pwd);
if($conn){
.......
}

rcmehta_14

Yes, that's right. Thanx for that.

But as I have mentioned in first place that there is a large no. of files (around 300) that I need to change for this.

Isn't there any other way around that without changing a single php file, I can get out of this problem? like change in PHP configuration or MySQL config or Apache config.

Thanx ....

laserlight

I dont think so, since what you are asking for is to change the way mysql_connect() behaves, which is possible but not worth the trouble since you'll have to re-write then re-compile PHP, or change the way '==' behaves, or the value of '2', but that will cause bugs everywhere.

A possible solution would be to use a search and replace if your scripts always use $conn in relation to mysql_connect, and with the same kind of formatting as you presented.
If you really need to, write a script/program to do the search and replace for you.

rcmehta_14

Thank you for your kind suggestion.

Btw, I have done some research work.

when I tried to print the return value of mysql_connect, it prints like this.

$conn = Resource id#2 on New Configuration

But it prints $conn = Resource id#1 on old one.

Can you please tell me the cause behind this behaviour.

Thanx in advance.

Weedpacket

Those resource ID numbers are only intended for PHP's internal use to keep track of which resource applies to which variable; it's not intended for the programmer to use it because it doesn't mean anything to the program. Different builds of PHP could assign resource IDs in different ways in different orders - there's no guarantee that the same resource ID will apply to the same resource even for the same script running on the same build of PHP at two different times, let alone different versions of PHP.

Details can be found here, here, and here.