PHP | mysqli_ping() Function

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 faliure.



    Below program illustrate the ping() function in object-oriented style:

    filter_none

    edit
    close

    play_arrow

    link
    brightness_4
    code

    <?php
    $servername = "localhost";
    $username = "username";
    $password = "password";
      
    // Creating a connection
    $conn = new mysqli($servername, $username, $password);
      
    // Check connection
    if ($conn->connect_error) {
        die("Connection to the server failed: " . $conn->connect_error);
      
    /* check if server is alive */
    if ($conn->ping()) {
        printf ("Successful Coonection!\n");
    } else {
        printf ("Error: %s\n", $conn->error);
    }
      
    /* close connection */
    $conn->close();
    ?>

    chevron_right

    
    

  • 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 faliure.

    Below program illustrate the mysqli_ping() in the procedural style:

    filter_none

    edit
    close

    play_arrow

    link
    brightness_4
    code

    <?php
    $$servername = "localhost";
    $username = "username";
    $password = "password";
      
    // Creating connection
    $conn = mysqli_connect($servername, $username, $password);
      
    // Checking connection
    if (!$conn) {
        die("Connection to the server failed: " . mysqli_connect_error());
    }
      
    /* check if server is alive */
    if (mysqli_ping($conn)) {
        printf ("Successful Coonection!\n");
    } else {
        printf ("Error: %s\n", mysqli_error($conn));
    }
      
    /* close connection */
    mysqli_close($conn);
    ?>

    chevron_right

    
    

Reference: http://php.net/manual/en/mysqli.ping.php




My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.