SQLSRV_SERVER_INFO(3) SQLSRV_SERVER_INFO(3)
sqlsrv_server_info - Returns information about the server
SYNOPSIS
array sqlsrv_server_info (resource $conn)
DESCRIPTION
Returns information about the server.
PARAMETERS
o $conn
- The connection resource that connects the client and the server.
RETURN VALUES
Returns an array as described in the following table:
Returned Array
+-----------------+----------------------------+
|CurrentDatabase | |
| | |
| | The connected-to database. |
| | |
+-----------------+----------------------------+
|SQLServerVersion | |
| | |
| | The SQL Server version. |
| | |
| SQLServerName | |
| | |
| | The name of the server. |
| | |
+-----------------+----------------------------+
EXAMPLES
Example #1
sqlsrv_server_info(3) example
<?php
$serverName = "serverNamesqlexpress";
$conn = sqlsrv_connect( $serverName);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$server_info = sqlsrv_server_info( $conn);
if( $server_info )
{
foreach( $server_info as $key => $value) {
echo $key.": ".$value."<br />";
}
} else {
die( print_r( sqlsrv_errors(), true));
}
?>
SEE ALSO
sqlsrv_client_info(3).
PHP Documentation Group SQLSRV_SERVER_INFO(3)
