Oracle 5.0, Reference Manual

Page: 2314 / 3232

Original MySQL API (
Mysql
)
2294
Return Values
Returns
TRUE
if the connection to the server MySQL server is working, otherwise
FALSE
.
Examples
Example 20.66. A
mysql_ping
example
<?php
set_time_limit(0);
$conn = mysql_connect('localhost', 'mysqluser', 'mypass');
$db = mysql_select_db('mydb');
/* 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, exiting after query #1';
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
mysql_list_processes
20.7.2.5.40.
mysql_query
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysql_query
Send a MySQL query
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the
future. Instead, the
MySQLi or PDO_MySQL extension should be used. See
also MySQL: choosing an API guide and related FAQ for more information.
Alternatives to this function include:
mysqli_query
PDO::query
Description
resource mysql_query(
string query,
resource link_identifier
= =NULL);
mysql_query
sends a unique query (multiple queries are not supported) to the currently active
database on the server that's associated with the specified
link_identifier
.