The mysqli_ping() function is used to ping a server connection. That is it is used to check if a host is reachable on an IP network or not. This function also tries to reconnect if an existing server connection is lost. To use this function, it is mandatory to first set up the connection with the MySQL database.
This function can be used in both Object Oriented and Procedural styles as described below:Â
- Object oriented style:
Syntax:
ping();
- Parameters: This function does not accepts any parameter, it is used with a connection instance.
Return Value: This function returns True on success and False on failure.
Below program illustrate the ping() function in object-oriented style:
PHP
<?php$servername = "localhost";$username = "username";$password = "password";Â
// Creating a connection$conn = new mysqli($servername, $username, $password);Â
// Check connectionif ($conn->connect_error) {Â Â Â Â die("Connection to the server failed: " . $conn->connect_error);} Â
/* check if server is alive */if ($conn->ping()) {Â Â Â Â printf ("Successful Connection!\n");} else {Â Â Â Â printf ("Error: %s\n", $conn->error);}Â
/* close connection */$conn->close();?> |
- Procedural style:
Syntax:
mysqli_ping($conn);
- Parameters: This function accepts a single parameter $conn which represents the connection to use.
Return Value: This function returns True on success and False on failure.
Below program illustrate the mysqli_ping() in the procedural style:
PHP
<?php$$servername = "localhost";$username = "username";$password = "password";Â
// Creating connection$conn = mysqli_connect($servername, $username, $password);Â
// Checking connectionif (!$conn) {Â Â Â Â die("Connection to the server failed: " . mysqli_connect_error());}Â
/* check if server is alive */if (mysqli_ping($conn)) {Â Â Â Â printf ("Successful Connection!\n");} else {Â Â Â Â printf ("Error: %s\n", mysqli_error($conn));}Â
/* close connection */mysqli_close($conn);?> |
Reference: http://php.net/manual/en/mysqli.ping.php
