cubrid_column_types

Description

The cubrid_colulmn_types() function is used to get column types in the query results by using req_identifier.

Syntax

array cubrid_column_types (resource $req_identifier)

• req_identifier : Request identifier

Return Value

• Success : An array that contains the column types
• Failure : FALSE

Example

<?php

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

$result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");

$column_names = cubrid_column_names($result);

$column_types = cubrid_column_types($result);

printf("%-30s %-30s %-15s\n", "Column Names", "Column Types", "Column Maxlen");

for($i = 0, $size = count($column_names); $i < $size; $i++) {

    $column_len = cubrid_field_len($result, $i);

    printf("%-30s %-30s %-15s\n", $column_names[$i], $column_types[$i], $column_len); }

cubrid_disconnect($conn);

?>

The above example will output:

Column Names                 Column Types                 Column Maxlen

host_year                    integer                      11

event_code                   integer                      11

athlete_code                 integer                      11

stadium_code                 integer                      11

nation_code                  char(3)                      3

medal                        char(1)                      1

game_date                    date                         10

See Also

• cubrid_execute
• cubrid_prepare
• cubrid_column_names