PHP mysqli_get_host_info() Function

The PHP mysqli_get_host_info() function returns information about the server host to which a MySQLi connection is made. This function might be useful for debugging or troubleshooting database connectivity difficulties.

The mysqli get host info function has the following syntax:

string mysqli_get_host_info ( mysqli $link )

Where $link is a MySQLi link identifier, returned by mysqli_connect() or mysqli_init().

Here is an example of how to use the mysqli_get_host_info function:

$link = mysqli_connect("localhost", "username", "password", "database");

if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

echo "Connection info: " . mysqli_get_host_info($link) . PHP_EOL;

In this example, the script connects to a MySQL database using the mysqli connect() function, and then uses the mysqli get host info() method to gather information about the server host. The host’s information is then shown on the screen.

There are more applications for the mysqli get host info function. It may be used to log host information in your application’s error logs, or to display it to users in an informational message.

It is critical to note that the mysqli_get_host_info function returns a string that only contains information about the server host’s version and not the MySQL protocol version.