php8.5
Home/ Manual/ mysqli / mysqli/ mysqli::$server_version

mysqli::$server_version

PHP function Edit on GitHub ✎

Returns the version of the MySQL server as an integer

Description

Oop

intmysqli->server_version

Procedural

mysqli_get_server_version(mysqli $mysql): int

The mysqli_get_server_version() function returns the version of the server connected to (represented by the mysql parameter) as an integer.

Parameters

Return Values

An integer representing the server version.

The form of this version number is main_version * 10000 + minor_version * 100 + sub_version (i.e. version 4.1.0 is 40100).

Examples

$mysqli->server_version example

Oop

php
<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password");

/* print server version */
printf("Server version: %d\n", $mysqli->server_version);

Procedural

php
<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "my_user", "my_password");

/* print server version */
printf("Server version: %d\n", mysqli_get_server_version($link));

Similar

output
Server version: 80021

See Also

Source: reference/mysqli/mysqli/get-server-version.xml · from the official PHP manual (php/doc-en)