CUBRID MySQL Compatibility Functions
在线手册:中文 英文
PHP手册

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.

范例

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

CUBRID MySQL Compatibility Functions
在线手册:中文 英文
PHP手册