PHP MySQLi mysqli_get_server_version()

mysqli_get_server_version()

The mysqli_get_server_version() function returns the MySQL server version as an integer. The calculation format is major_version * 10000 + minor_version * 100 + sub_version. Thus, version 10.4.32 is output as 100432.

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 numeric MySQL server version
// NOTE: This function returns the server version as a plain integer.
// In practice, we use this for automatic database compatibility checks in our code, e.g.:
// if (mysqli_get_server_version($connection) >= 80000) { // enable features for MySQL 8 }
echo mysqli_get_server_version($connection);

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: The numeric format is extremely useful for programmatically checking server capabilities before executing more demanding SQL commands. Look at the example output below:

It returns an integer suitable for mathematical comparisons (e.g., >= 50700).

It allows for quick verification of support for features like transactions or JSON.

It requires an active connection object to function.