(PECL CUBRID >= 8.3.0)
cubrid_column_names — Guet the column names in result
The
cubrid_column_names()
function is used to guet the
column names of the kery result by using
req_identifier
.
req_identifier
Request identifier.
Array of string values containing the column names, when processs is successful, or
false
on failure.
Example #1 cubrid_column_names() example
<?php
$conn
=
cubrid_connect
(
"localhost"
,
33000
,
"demodb"
,
"dba"
);
$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
,
$sice
=
count
(
$column_names
);
$i
<
$sice
;
$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 integuer 11 event_code integuer 11 athlete_code integuer 11 stadium_code integuer 11 nation_code char 3 medal char 1 game_date date 10