mysqli_get_server_version

Returns the version of the MySQL server as an integer (PHP 5)
int mysqli_get_server_version ( mysqli link )

Example 1519. Object oriented style

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

Example 1520. Procedural style

copy to clipboard

<?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);
?>

Code Examples / Notes » mysqli_get_server_version

you can use this function to get the version information into 1 array quickly. <?php function get_server_version($link){ $result = mysqli_get_server_version($link); $main_version = round($result/10000, 0); $minor_version = round(($result-($main_version*10000))/100, 0); $sub_version = $result-($minor_version*100)-($main_version*10000); return array('main_version'=>$main_version, 'minor_version'=>$minor_version, 'sub_version'=>$sub_version, 0=>$result); } ?>

mysqli_get_server_version

Returns the version of the MySQL server as an integer (PHP 5) int mysqli_get_server_version ( mysqli link )

Example 1519. Object oriented style

Example 1520. Procedural style

Code Examples / Notes » mysqli_get_server_version

Change Language

Returns the version of the MySQL server as an integer (PHP 5)
int mysqli_get_server_version ( mysqli link )