Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 



cubrid_field_seek

Description

The cubrid_field_seek function sets a field offset value to be used in cubrid_fetch_field() function. If the cubrid_fetch_field() function that does not include a field offset is called, the field offset specified in this function is returned.

Syntax

bool cubrid_field_seek ( resource $result , int $field_offset )

  • result : Result that 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 occurs.
Return Value
  • Success : TRUE
  • Failure : FALSE
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(" --- Field Properties --- ");

printf("%-30s %s ", "name:", $field->name);

printf("%-30s %s ", "table:", $field->table);

printf("%-30s "%s" ", "default value:", $field->def);

printf("%-30s %d ", "max lenght:", $field->max_length);

printf("%-30s %d ", "not null:", $field->not_null);

printf("%-30s %d ", "unique key:", $field->unique_key);

printf("%-30s %d ", "multiple key:", $field->multiple_key);

printf("%-30s %d ", "numeric:", $field->numeric);

printf("%-30s %s ", "type:", $field->type);

 

cubrid_close_request($req);

 

cubrid_disconnect($conn);

?>

 

The above example will output:

 

array(4) {

  [0]=>

  string(5) "20001"

  [1]=>

  string(5) "16681"

  [2]=>

  string(3) "KOR"

  [3]=>

  string(9) "1988-9-30"

}

 

--- Field Properties ---

name:                          athlete_code

table:                         game

default value:                 ""

max lenght:                    5

not null:                      1

unique key:                    1

multiple key:                  0

numeric:                       1

type:                          integer