PHP MySQLi mysqli_get_client_info()

mysqli_get_client_info()

The mysqli_get_client_info() function returns the MySQL client library version as a text string. This is useful for checking compatibility between your PHP code and the database.

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 the MySQL client (driver) version
// NOTE: This command does not output the MySQL server version, but the 
// version of the built-in PHP driver (mysqlnd) that handles packing and 
// sending data over the network. The output returns simple text, e.g., "mysqlnd 8.2.12".
echo mysqli_get_client_info($connection);

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: Instead of guessing about system settings, use this function to quickly check the version of the installed MySQL driver on the server. Take a look at the simple output below:

It returns a text string with the driver version (e.g., mysqlnd 8.5.6).

It does not require an active connection if the function is called without parameters.

It helps in resolving issues regarding system support for specific commands.