PHP MySQLi mysqli_get_host_info()

mysqli_get_host_info()

The mysqli_get_host_info() function returns a text string containing the host name of the MySQL server and the type of connection used (e.g., Localhost via UNIX socket or localhost via TCP/IP).

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

if (mysqli_connect_errno()) {
    printf("Connection failed: %s<br>", mysqli_connect_error());
    exit();
}

// Display information about the host and connection method
// NOTE: This function reveals the technical method of communication between PHP and the 
// MySQL server. In most local environments, it will output the text "Localhost via TCP/IP", 
// meaning data transfer occurs via the local network protocol.
echo mysqli_get_host_info($connection);

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: With this function, you can quickly find out how your PHP script is connected to the database, which is crucial for optimizing connection speed and security. Look at the example output below:

It returns the server name and the connection protocol.

Useful for distinguishing between local and remote connections.

It returns information directly from the active connection.