©
This document uses PHP Chinese website manual Release
(PHP 4, PHP 5, PECL odbtp >= 1.1.1)
mssql_num_fields — Gets the number of fields in result
$result
)mssql_num_fields() returns the number of fields in a result set.
result
The result resource that is being evaluated. This result comes from a call to mssql_query() .
Returns the number of fields, as an integer.
Example #1 mssql_num_fields() example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect ( 'KALLESPC\SQLEXPRESS' , 'sa' , 'phpfi' );
mssql_select_db ( 'php' , $link );
// Select some data from our database
$data = mssql_query ( 'SELECT [name], [age] FROM [php].[dbo].[persons]' );
// Construct a table
echo '<table border="1">' ;
$header = false ;
// Iterate through returned results
while ( $row = mssql_fetch_array ( $data )) {
// Build the table header
if (! $header ) {
echo '<thead>' ;
echo '<tr>' ;
for ( $i = 1 ; ( $i + 1 ) <= mssql_num_fields ( $data ); ++ $i ) {
echo '<td>' . ucfirst ( $row [ $i ]) . '</td>' ;
}
echo '</tr>' ;
echo '</thead>' ;
echo '<tbody>' ;
$header = true ;
}
// Build the row
echo '<tr>' ;
foreach( $row as $value ) {
echo '<td>' . $value . '</td>' ;
}
echo '</tr>' ;
}
// Close table
echo '</tbody>' ;
echo '</table>' ;
// Clean up
mssql_free_result ( $data );
mssql_close ( $link );
?>