cubrid_column_names

설명

cubrid_column_names 함수는 req_identifier를 이용해 질의 결과에 대한 열 이름들을 얻는데 사용된다.

구문

array cubrid_column_names (resource $req_identifier)

리턴 값
예제

<?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   

관련 항목