(PHP 5, PHP 7)
mysqli::$server_version -- mysqli_get_server_version — Returns the version of the MySQL server as an integer
객체 기반 형식
절차식 형식
The mysqli_get_server_version() function returns the
version of the server connected to (represented by the
link
parameter) as an integer.
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).
Example #1 $mysqli->server_version example
객체 기반 형식
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* print server version */
printf("Server version: %d\n", $mysqli->server_version);
/* close connection */
$mysqli->close();
?>
절차식 형식
<?php
$link = mysqli_connect("localhost", "my_user", "my_password");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* print server version */
printf("Server version: %d\n", mysqli_get_server_version($link));
/* close connection */
mysqli_close($link);
?>
위 예제들의 출력:
Server version: 40102