PHP mysqli ping() Function

PHP MySQLi Reference : Ping a server connection

Definition and Usage

The ping() / mysqli_ping() function pings a server connection, to check if the server is alive. It also tries to reconnect - if the connection has gone down.

Syntax

Object oriented style:

$mysqli -> ping()

Procedural style:

mysqli_ping(connection)

Parameter Values

Parameter Description
connection Required. Specifies the MySQL connection to use

Technical Details

Return Value: TRUE on success. FALSE on failure
PHP Version: 5+

Example - Procedural style

Ping a server connection:

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  exit();
}

// Check if server is alive
if (mysqli_ping($con)) {
  echo "Connection is ok!";
} else {
  echo "Error: ". mysqli_error($con);
}

mysqli_close($con);
?>

❮ PHP MySQLi Reference