본문 바로가기

프로그램 경험/PHP

[PHP] MsSql 연동 모듈(Sqlsrv) 정보 알아내기

<?

$serverName = "localhost";

$conn = sqlsrv_connect( $serverName);


if( $conn === false )

{

     echo "Could not connect.\n";

     die( print_r( sqlsrv_errors(), true));

}


if( $client_info = sqlsrv_client_info( $conn))

{

       foreach( $client_info as $key => $value)

      {

              echo $key.": ".$value."\n";

      }

}

else

{

       echo "Client info error.\n";

}


/* Close connection resources. */

sqlsrv_close( $conn);