PHP：如何确定数据库连接是否打开[重复]

Question

This question already has an answer here:

• Check if db connection is closed - php 4 answers

I have the following class method -

class Someclass
{
    /* Other properties and methods */

    public function close_connection($connection=NULL)
    {
        return mysql_close($connection)
    }
}

Now, before calling the mysql_close function in the above code, I want to check if the $connection points to a open database connection. That is, I want to be sure that the connection I am closing is open and has not already been closed.

How can I do that?

</div>

Answer 1

If you have other code that could be closing the connection, have them set the connection to null so you can test for that.

If you are unsure wether the connection has been closed from the other end, due to a timeout or a network error, the only way to test it is to actually send data through using something like mysql_ping. However, this would be a terrible waste of resources if you are just trying to avoid closing a connection that might already be closed.

Note: as mentioned by evord, using mysql_ping will attempt to reopen the connection if it is no longer open.