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_type

Description

The cubrid_field_type function returns the type of specified field and the field type returned is one of the types (example : "int", "float", or "string") that are supported by CUBRID.

Syntax

string cubrid_field_type (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.
Result Values
  • Success : Type of the column
  • Invalid field_offset value : FALSE
  • SQL sentence is not SELECT : -1
Example

<?php

$conn = cubrid_connect("localhost", 33000, "demodb");

$result = cubrid_execute($conn, "SELECT * FROM code");

 

$col_num = cubrid_num_cols($result);

 

printf("%-15s %-15s %s ", "Field Table", "Field Name", "Field Type");

for($i = 0; $i < $col_num; $i++) {

    printf("%-15s %-15s %s ",

        cubrid_field_table($result, $i), cubrid_field_name($result, $i), cubrid_field_type($result, $i));

}

 

cubrid_disconnect($conn);

?>

 

The above example will output:

 

Field Table     Field Name      Field Type

code            s_name          char(1)

code            f_name          varchar(6)

 

Output:

Your 'func' table has 4 fields and 1 record(s)

The table has the following fields:

string name 64 not_null primary_key binary

int ret 1 not_null

string dl 128 not_null

string type 9 not_null enum