PHP mysqli: get_client_version() function

Last update on August 19 2022 21:50:40 (UTC/GMT +8 hours)

mysqli_get_client_version function / mysqli::$client_version

The mysqli_get_client_version function / mysqli::$client_version — returns the MySQL client version as an integer.

Syntax:

Object oriented style

int $mysqli->client_version;

Procedural style

int mysqli_get_client_version ( mysqli $link )

Usage: Procedural style

mysqli_get_client_version(connection);

Parameter:

Name	Description	Required/Optional
connection	Specifies the MySQL connection to use.	Optional

Return value:

A number that represents the MySQL client library version in format: main_version*10000 + minor_version *100 + sub_version. For example, 4.1.0 is returned as 40100.

This is useful to quickly determine the version of the client library to know if some capability exits.

Version: PHP 5, PHP 7

Example of procedural style:

<?php
/* We don't need a connection to determine
   the version of mysql client library */

printf("Client library version: %d\n", mysqli_get_client_version());

?>

Output:

Client library version: 50005

Example:

<?php
echo mysqli_get_client_version();
?>

Output:

See also

PHP Function Reference

Previous: get_client_stats
Next: get_connection_stats

PHP: Tips of the Day

To use the constant simply use its name:

Example:

if (EARTH_IS_FLAT) {
 print "Earth is flat";
}
print APP_ENV_UPPERCASE;

Output:

or if you don't know the name of the constant in advance, use the constant function:

// this code is equivalent to the above code
$const1 = "EARTH_IS_FLAT";
$const2 = "APP_ENV_UPPERCASE";
if (constant($const1)) {
 print "Earth is flat";
}
print constant($const2);

Output:

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook