©
This document uses PHP Chinese website manual Release
(PHP 5)
mysqli_result::$current_field -- mysqli_field_tell — Get current field offset of a result pointer
面向对象风格
过程化风格
$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