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_len

Description

The cubrid_field_len function returns the length of the specified field on success, or FALSE on failure.

Syntax

string cubrid_field_len ( 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.
Return Value
  • Success: Maximum length
  • 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