maxdb_field_tell

maxdb_result::current_field

(PECL maxdb >= 1.0)

maxdb_field_tell -- maxdb_result::current_field — Get current field offset of a result pointer

说明

过程化风格

int maxdb_field_tell ( resource $result )

面向对象风格

int $maxdb_result->current_field;

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

返回值

Returns current offset of field cursor.

范例

Example #1 面向对象风格

  <?php
$maxdb  = new  maxdb ( "localhost" ,  "MONA" ,  "RED" ,  "DEMODB" );

 
 if ( maxdb_connect_errno ()) {
    printf ( "Connect failed: %s\n" ,  maxdb_connect_error ());
   exit();
}

 $query  =  "SELECT name, cno from hotel.customer ORDER BY cno" ;

if ( $result  =  $maxdb -> 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 ();
}

 
 $maxdb -> close ();
 ?>

Example #2 过程化风格

  <?php
$link  =  maxdb_connect ( "localhost" ,  "MONA" ,  "RED" ,  "DEMODB" );

 
 if ( maxdb_connect_errno ()) {
    printf ( "Connect failed: %s\n" ,  maxdb_connect_error ());
   exit();
}

 $query  =  "SELECT name, cno from hotel.customer ORDER BY cno" ;

if ( $result  =  maxdb_query ( $link ,  $query )) {

    
    while ( $finfo  =  maxdb_fetch_field ( $result )) {

        
        $currentfield  =  maxdb_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 );
   }
    maxdb_free_result ( $result );
}

 
 maxdb_close ( $link );
 ?>

以上例程的输出类似于：

Column    1:
Name:     NAME
Table:
max. Len: 10
Flags:    -1
Type:     2Column    2:
Name:     CNO
Table:
max. Len: 4
Flags:    -1
Type:     0

参见

maxdb_fetch_field() - Returns the next field in the result set
maxdb_field_seek() - Set result pointer to a specified field offset