sqlsrv_num_fields

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

sqlsrv_num_fields — Retrieves the number of fields (columns) on a statement

说明

mixed sqlsrv_num_fields ( resource $stmt )

Retrieves the number of fields (columns) on a statement.

参数

stmt: The statment for which the number of fields is returned. sqlsrv_num_fields() can be called on a statement before or after statement execution.

返回值

Returns the number of fields on success. Returns FALSE otherwise.

范例

Example #1 sqlsrv_num_fields() example

  <?php
$serverName  =  "serverName\sqlexpress" ;
 $connectionInfo  = array(  "Database" => "dbName" ,  "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_query ( $conn ,  $sql );
if(  $stmt  ===  false ) {
   die(  print_r (  sqlsrv_errors (),  true ));
}

 $numFields  =  sqlsrv_num_fields (  $stmt  );

while(  sqlsrv_fetch (  $stmt  )) {
    // Iterate through the fields of each row.
    for( $i  =  0 ;  $i  <  $numFields ;  $i ++) { 
      echo  sqlsrv_get_field ( $stmt ,  $i ). " " ;
   }
   echo  "<br />" ;
}
 ?>

参见

sqlsrv_field_metadata() - Retrieves metadata for the fields of a statement prepared by sqlsrv_prepare or sqlsrv_query
sqlsrv_fetch() - Makes the next row in a result set available for reading
sqlsrv_get_field() - Gets field data from the currently selected row