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_fetch_field

Description

The cubrid_fetch_field function returns an object containing field information. The function can be used to obtain information about fields in the provided query result. The characteristics of the object are:

  • name : Column name
  • table : Name of the table where the column belongs
  • def : Default value of the column
  • max_length : Maximum length of the column
  • not_null : 1 if the column cannot be NULL
  • unique_key : 1 if the column is a unique key
  • multiple_key : 1 if the column is a non-unique key
  • numeric : 1 if the column is numeric
  • type : The type of the column
Syntax

object cubrid_fetch_field ( resource $result [, int $field_offset= 0 ] )

  • result : Result that comes from a call to cubrid_execute()
  • field_offset : The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is retrieved. The field_offset starts at 0.
Return Value
  • Success: Associative arrays
  • After getting the last row : FALSE
  • 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