[RESOLVED] Check to see if mysql connection closed

[Beffic]

Okay so I was curious if there was any way of check whether or not a mysql_connection is still open or not... like with a program or anything?

This is for debugging purposes.

[coldwerturkey]

select a database and see if it can or not. if it returns false; there's no connection.

[NogDog]

If you know the variable name that would store the connection resource, I suppose you could get anal about it and so something like:

if(
   isset($connx)
   and is_resource($connx)
   and strpos(strtolower(get_resource_type($connx)), 'mysql') !== false
) {
   echo "You are connected to MySQL";
}
else
{
   echo "Oops, not connected.";
}