PHP Mysql Tutorials, Function, mysql

Topic

What is mysql_ping() function in PHP?
How does mysql_ping() works?

Explanation

The mysql_ping() function pings a server connection or reconnects to it if there is no connection.

Syntax

bool mysql_ping ( [resource link_identifier])

Returns TRUE if there is a connection, or FALSE on failure.

mysql_ping() function is used to check whether the connection to the server is working or not. If the connection to the server gone down, an automatic reconnection to the server is attempted by this function. This function can be used by scripts that remain idle for a long while, to check whether the server has closed the connection and reconnect to server if necessary.

Example

<?php
set_time_limit(0);

//Attempt to connect to the default database server

$conn = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");

//select database

$db = mysql_select_db('my_database');

// Assuming this query will take a long time

$result = mysql_query($sql);
if (!$result) {
echo 'Query #1 failed, exiting.';
exit;
}

// Make sure the connection is still alive, if not, try to reconnect

if (!mysql_ping($conn)) {
echo 'Lost connection';
exit;
}

mysql_free_result($result);

// So the connection is still alive, let's run another query

$result2 = mysql_query($sql2);
?>

See also: mysql_thread_id() and mysql_list_processes().