sqlsrv_field_metadata

(No version information available, might only be in Git)

sqlsrv_field_metadata — Retrieves metadata for the fields of a statement prepared by sqlsrv_prepare() or sqlsrv_query()

说明

sqlsrv_field_metadata ( resource $stmt ) : mixed

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

参数

stmt

The 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:

Array returned by sqlsrv_field_metadata
Key Description
Name The name of the field.
Type The numeric value for the SQL type.
Size The number of characters for fields of character type, the number of bytes for fields of binary type, or NULL for other types.
Precision The precision for types of variable precision, NULL for other types.
Scale The scale for types of variable scale, NULL for other types.
Nullable An enumeration indicating whether the column is nullable, not nullable, or if it is not known.
For more information, see » sqlsrv_field_metadata in the Microsoft SQLSRV documentation.

范例

Example #1 sqlsrv_field_metadata() 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 />";
}
?>

参见

相关文章
php cubrid 函数 execute a prepared sql statementphp cubrid 函数 bind a lob object or a string as a lob object to a prepared statement as parametersphp firebird/interbase 函数 execute a previously prepared queryphp firebird/interbase 函数 prepare a query for later binding of parameter placeholders and executionphp maxdb 函数 prepare next result from multi queryphp maxdb 函数 closes a prepared statementphp maxdb 函数 executes a prepared queryphp maxdb 函数 fetch results from a prepared statement into the bound variablesphp maxdb 函数 returns result set metadata from a prepared statementphp odbc 函数 prepare and execute an sql statementphp odbc 函数 execute a prepared statementphp postgresql 函数 sends a request to execute a prepared statement with given parameters without waiting for the result s php postgresql 函数 sends a request to create a prepared statement with the given parameters without waiting for completionphp sqlsrv 函数 executes a statement prepared with sqlsrv preparephp sqlsrv 函数 retrieves the next row of data in a result set as an objectphp sqlsrv 函数 retrieves metadata for the fields of a statement prepared by sqlsrv prepare or sqlsrv queryphp sqlsrv 函数 frees all resources for the specified statementphp sqlsrv 函数 retrieves the number of fields columns on a statementphp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp sdo das relational 函数 executes an sql query passed as a prepared statement with a list of values to substitute for placeholders and return the results as a normalised data graph
关注编程学问公众号