cubrid_field_type

Description

The cubrid_field_type() function is similar to the cubrid_field_name() function. The arguments are identical, but the field type is returned instead. The returned field type will be one of "int", "real", "string", etc.

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 Value

• Success : Type of the column
• When 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\n", "Field Table", "Field Name", "Field Type");

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

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

        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)