(PECL CUBRID >= 8.3.0)
cubrid_field_table — Returns the name of the table of the specified field
This function returns the name of the table of the specified field. This is useful when using large select queries with JOINS.
This is the request identifier .
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.
Beispiel #1 cubrid_field_table() example
<?php
$link = cubrid_connect("localhost", 30000, "demodb2", "dba", "");
if (!$link)
{
die('Could not connect.');
}
$query = 'SELECT id, name, address, salary FROM employees';
$result = cubrid_execute($link, $query);
if ($result)
{
echo "Field 0 (<b>". cubrid_field_name($result, 0) . "</b>) is from table <i>" . cubrid_field_table($result, 0) . "</i><br>";
echo "Field 1 (<b>". cubrid_field_name($result, 1) . "</b>) is from table <i>" . cubrid_field_table($result, 1) . "</i><br>";
cubrid_close_request($result);
}
?>
Das oben gezeigte Beispiel erzeugt folgende Ausgabe:
Result: Field 0 (id) is from table employees Field 1 (name) is from table employees