PHP MySQLi mysqli_get_client_version()

mysqli_get_client_version()

The mysqli_get_client_version() function returns the MySQL client version as an integer. The format is major_version * 10000 + minor_version * 100 + sub_version. This means that version 8.2.12 would be returned as the number 80212.

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();
}

// Output the numeric MySQL client version
// NOTE: This function returns the version as a clean integer (e.g., 50011).
// In practice, we use this number for automatic checks in our code, e.g.:
// if (mysqli_get_client_version() >= 50000) { // perform advanced logic }
echo mysqli_get_client_version();

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This format is ideal for automated condition checking in your code. Look below to see the output on the current server:

It returns an integer, allowing mathematical comparison of versions.

Calculation: Version 8.0.25 becomes 80025.

Useful when we want to adapt the code to the specific capabilities of a certain driver version.