©
This document uses PHP Chinese website manual Release
(PECL CUBRID >= 8.3.0)
cubrid_field_table — Return the name of the table of the specified field
$result
, int $field_offset
)This function returns the name of the table of the specified field. This is useful when using large select queries with JOINS.
result
Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH.
field_offset
The numerical field offset. The field_offset
starts at 0. If field_offset
does not exist, an
error of level E_WARNING
is also issued.
Name of the table of the specified field, on success.
FALSE
when invalid field_offset value.
-1 if SQL sentence is not SELECT.
Example #1 cubrid_field_table() example
<?php
$conn = cubrid_connect ( "localhost" , 33000 , "demodb" );
$result = cubrid_execute ( $conn , "SELECT * FROM code" );
$col_num = cubrid_num_cols ( $result );
printf ( "%-15s %-15s %s\n" , "Field Table" , "Field Name" , "Field Type" );
for( $i = 0 ; $i < $col_num ; $i ++) {
printf ( "%-15s %-15s %s\n" ,
cubrid_field_table ( $result , $i ), cubrid_field_name ( $result , $i ), cubrid_field_type ( $result , $i ));
}
cubrid_disconnect ( $conn );
?>
以上例程会输出:
Field Table Field Name Field Type code s_name char code f_name varchar