PHP: mysqli_get_server_version - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

mysqli_info mysqli_get_server_info

Last updated: Sat, 27 Jan 2007

view this page in

# mysqli_get_server_version

(PHP 5)

mysqli_get_server_version -- Returns the version of the MySQL server as an integer

## Description

Procedural style:

int mysqli_get_server_version ( mysqli link )

Object oriented style (property):

class mysqli {
int server_version
}

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

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

## Возвращаемые значения

An integer representing the server version.

## Смотрите также

mysqli_get_client_info(), mysqli_get_client_version() и mysqli_get_server_info().

## Примеры

Пример 1. 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();
?>`

Пример 2. Procedural style

`<?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

add a note User Contributed Notes
mysqli_get_server_version
tularis at php dot net
29-Aug-2003 04:18
`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);
}
?>`
add a note
mysqli_info mysqli_get_server_info

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST