文字

mysqli_result::$current_field

mysqli_field_tell

(PHP 5)

mysqli_result::$current_field -- mysqli_field_tellGet current field offset of a result pointer

说明

面向对象风格

int $mysqli_result->current_field ;

过程化风格

int mysqli_field_tell ( mysqli_result $result )

Returns the position of the field cursor used for the last mysqli_fetch_field() call. This value can be used as an argument to mysqli_field_seek() .

参数

result

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

返回值

Returns current offset of field cursor.

范例

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();
}

$query  "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5" ;

if (
$result  $mysqli -> query ( $query )) {

    

    
while ( $finfo  $result -> fetch_field ()) {

        

        
$currentfield  $result -> current_field ;

        
printf ( "Column %d:\n" $currentfield );
        
printf ( "Name:     %s\n" $finfo -> name );
        
printf ( "Table:    %s\n" $finfo -> table );
        
printf ( "max. Len: %d\n" $finfo -> max_length );
        
printf ( "Flags:    %d\n" $finfo -> flags );
        
printf ( "Type:     %d\n\n" $finfo -> type );
    }
    
$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();
}

$query  "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5" ;

if (
$result  mysqli_query ( $link $query )) {

    

    
while ( $finfo  mysqli_fetch_field ( $result )) {

        

        
$currentfield  mysqli_field_tell ( $result );

        
printf ( "Column %d:\n" $currentfield );
        
printf ( "Name:     %s\n" $finfo -> name );
        
printf ( "Table:    %s\n" $finfo -> table );
        
printf ( "max. Len: %d\n" $finfo -> max_length );
        
printf ( "Flags:    %d\n" $finfo -> flags );
        
printf ( "Type:     %d\n\n" $finfo -> type );
    }
    
mysqli_free_result ( $result );
}


mysqli_close ( $link );
?>

以上例程会输出:

Column 1:
Name:     Name
Table:    Country
max. Len: 11
Flags:    1
Type:     254Column 2:
Name:     SurfaceArea
Table:    Country
max. Len: 10
Flags:    32769
Type:     4

参见

  • mysqli_fetch_field() - Returns the next field in the result set
  • mysqli_field_seek() - Set result pointer to a specified field offset
上一篇: 下一篇: