Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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



cubrid_column_types

Description

The cubrid_column_types function gets 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 ", "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 ", $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