Ping MySQL Server?

[Tracer]

I have a report that is generated (via PHP and ODBC) on a company intrAnet. After the report is compiled, the user has the option to send selected results to a server outside of the intrAnet via the intErnet.

My question is this. Before even asking the user to save the results to the Server via the intErnet, is there a way to make sure that the server's IP is online and accepting connections?

I may just be brain dead today......

Can I just use

mysql_connect(10.10.10.10.......) or echo "Not Connected Try Again Later";

[stolzyboy]

$conn = mysql_connect("ipaddress", "user", "pass") or die ("Connection Not Found, Try Again Later!");

[martyn]

The only problem with die is it litterally kills the script (stops it) so anything afterwards will not work.

Maybe somming like this would be better:

$conn = mysql_connect("ipaddress", "user", "pass")

If($conn){

MYSQL
STUFF
HERE

}else{

ERRORMESSAGE

}

Rest of code

I assume this should work cause unless you can connect to the DB $conn will be false.

But which method you use depends on what you want to do.

[stolzyboy]

of course you are right, but you can make it GRACEFULLY die if you want, you don't just have to put that simple "Connection Not Found, Try Again Later!", you can do many more things as well

[martyn]

yup

😉