用mysql_ping 可以获得状态。 <?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); ?>
<?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);
?>