CUBRID MySQL Compatibility Functions
PHP Manual

cubrid_field_table

(PECL CUBRID >= 8.3.0)

cubrid_field_tableReturn the name of the table of the specified field

説明

string cubrid_field_table ( resource $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.

例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(1)
code            f_name          varchar(6)

CUBRID MySQL Compatibility Functions
PHP Manual