sqlsrv_field_metadata

sqlsrv_field_metadata

Retrieves metadata for the fields of a statement prepared by sqlsrv_prepare or sqlsrv_query

mixed **sqlsrv_field_metadata** resource $stmt

Retrieves metadata for the fields of a statement prepared by or . can be called on a statement before or after statement execution. sqlsrv_prepare``sqlsrv_query``sqlsrv_field_metadata

stmtThe statement resource for which metadata is returned.

Returns an array of arrays on success. Otherwise, false is returned. Each returned array is described by the following table:

For more information, see in the Microsoft SQLSRV documentation. sqlsrv_field_metadata

Voorbeeld: example

<?php
$serverName = "serverName\sqlexpress";
$connectionInfo = array( "Database"=>"AdventureWorks", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
   die( print_r( sqlsrv_errors(), true));
}

$sql = "SELECT * FROM Table_1";
$stmt = sqlsrv_prepare( $conn, $sql );

foreach( sqlsrv_field_metadata( $stmt ) as $fieldMetadata ) {
    foreach( $fieldMetadata as $name => $value) {
       echo "$name: $value<br />";
    }
      echo "<br />";
}
?>

sqlsrv_client_info