php 한글 메뉴얼 도움말 검색 사이트 Returns information about the server [function.sqlsrv-server-info]

설명

array sqlsrv_server_info ( resource $conn )

Returns information about the server.

인수

conn: The connection resource that connects the client and the server.

반환값

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.

예제

Example #1 sqlsrv_server_info() example


<?php
$serverName = "serverName\sqlexpress";
$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));
}
?>

참고

sqlsrv_client_info() - Returns information about the client and specified connection