mysqli_result::field_seek

mysqli_field_seek

(PHP 5)

mysqli_result::field_seek -- mysqli_field_seek — Set result pointer to a specified field offset

说明

面向对象风格

bool mysqli_result::field_seek ( int $fieldnr )

过程化风格

bool mysqli_field_seek ( mysqli_result $result , int $fieldnr )

Sets the field cursor to the given offset. The next call to mysqli_fetch_field() will retrieve the field definition of the column associated with that offset.

Note:

To seek to the beginning of a row, pass an offset value of zero.

参数

result: 仅以过程化样式：由 mysqli_query() ， mysqli_store_result() 或 mysqli_use_result() 返回的结果集标识。
fieldnr: The field number. This value must be in the range from 0 to number of fields - 1.

返回值

成功时返回 TRUE ，或者在失败时返回 FALSE 。

范例

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 )) {

     
     $result -> field_seek ( 1 );
     $finfo  =  $result -> fetch_field ();

     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 )) {

     
     mysqli_field_seek ( $result ,  1 );
     $finfo  =  mysqli_fetch_field ( $result );

     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 );
 ?>

以上例程会输出：

Name:     SurfaceArea
Table:    Country
max. Len: 10
Flags:    32769
Type:     4

参见

mysqli_fetch_field() - Returns the next field in the result set