文字

mysqli_result::$field_count

mysqli_num_fields

(PHP 5)

mysqli_result::$field_count -- mysqli_num_fieldsGet the number of fields in a result

说明

面向对象风格

int $mysqli_result->field_count ;

过程化风格

int mysqli_num_fields ( mysqli_result $result )

Returns the number of fields from specified result set.

参数

result

仅以过程化样式:由 mysqli_query() mysqli_store_result() mysqli_use_result() 返回的结果集标识。

返回值

The number of fields from a result set.

范例

Example #1 面向对象风格

<?php
$mysqli 
= new  mysqli ( "localhost" "my_user" "my_password" "world" );


if ( mysqli_connect_errno ()) {
    
printf ( "Connect failed: %s\n" mysqli_connect_error ());
    exit();
}

if (
$result  $mysqli -> query ( "SELECT * FROM City ORDER BY ID LIMIT 1" )) {

    

    
$field_cnt  $result -> field_count ;

    
printf ( "Result set has %d fields.\n" $field_cnt );

    

    
$result -> close ();
}


$mysqli -> close ();
?>

Example #2 过程化风格

<?php
$link 
mysqli_connect ( "localhost" "my_user" "my_password" "world" );


if ( mysqli_connect_errno ()) {
    
printf ( "Connect failed: %s\n" mysqli_connect_error ());
    exit();
}

if (
$result  mysqli_query ( $link "SELECT * FROM City ORDER BY ID LIMIT 1" )) {

    

    
$field_cnt  mysqli_num_fields ( $result );

    
printf ( "Result set has %d fields.\n" $field_cnt );

    

    
mysqli_free_result ( $result );
}


mysqli_close ( $link );
?>

以上例程会输出:

Result set has 5 fields.

参见

  • mysqli_fetch_field() - Returns the next field in the result set
上一篇: 下一篇: