cubrid_field_seek

(PECL CUBRID >= 8.3.0)

cubrid_field_seek — Move the result set cursor to the specified field offset

说明

bool cubrid_field_seek ( resource $result [, int $field_offset = 0 ] )

This function moves the result set cursor to the specified field offset. This offset is used by cubrid_fetch_field() if it doesn't include a field offset. It returns TRUE on success or FALSE on failure.

参数

result: result comes from a call to cubrid_execute()
field_offset: The numerical field offset. The field_offset starts at 0. If field_offset does not exist, an error of level E_WARNING is also issued.

返回值

TRUE on success.

FALSE on failure.

范例

Example #1 cubrid_field_seek() example

  <?php
$conn  =  cubrid_connect ( "localhost" ,  33000 ,  "demodb" );
 $req  =  cubrid_execute ( $conn ,  "SELECT event_code,athlete_code,nation_code,game_date FROM game WHERE host_year=1988 and event_code=20001;" );

 var_dump ( cubrid_fetch_row ( $req ));

 cubrid_field_seek ( $req ,  1 );
 $field  =  cubrid_fetch_field ( $req );

 printf ( "\n--- Field Properties ---\n" );
 printf ( "%-30s %s\n" ,  "name:" ,  $field -> name );
 printf ( "%-30s %s\n" ,  "table:" ,  $field -> table );
 printf ( "%-30s \"%s\"\n" ,  "default value:" ,  $field -> def );
 printf ( "%-30s %d\n" ,  "max length:" ,  $field -> max_length );
 printf ( "%-30s %d\n" ,  "not null:" ,  $field -> not_null );
 printf ( "%-30s %d\n" ,  "unique key:" ,  $field -> unique_key );
 printf ( "%-30s %d\n" ,  "multiple key:" ,  $field -> multiple_key );
 printf ( "%-30s %d\n" ,  "numeric:" ,  $field -> numeric );
 printf ( "%-30s %s\n" ,  "type:" ,  $field -> type );

 cubrid_close_request ( $req );

 cubrid_disconnect ( $conn );
 ?>

以上例程会输出：

array(4) {
  [0]=>
  string(5) "20001"
  [1]=>
  string(5) "16132"
  [2]=>
  string(3) "KOR"
  [3]=>
  string(9) "1988-09-30"
}--- Field Properties ---
name:                          athlete_code
table:                         game
default value:                 ""
max length:                    0
not null:                      1
unique key:                    1
multiple key:                  0
numeric:                       1
type:                          integer