MSQL_FETCH_FIELD(3)MSQL_FETCH_FIELD(3)msql_fetch_field - Get field informationSYNOPSIS
object msql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION msql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
o $field_offset
- The field offset. If not specified, the next field that wasn't yet retrieved by msql_fetch_field(3) is retrieved.
RETURN VALUES
Returns an object containing field information. The properties of the object are:
oname - column name
otable - name of the table the column belongs to
onot_null - 1 if the column cannot be
NULL
ounique - 1 if the column is a unique key
o type - the type of the column
SEE ALSO msql_field_seek(3).
PHP Documentation Group MSQL_FETCH_FIELD(3)
Check Out this Related Man Page
CUBRID_FIELD_TYPE(3) 1 CUBRID_FIELD_TYPE(3)cubrid_field_type - Return the type of the column corresponding to the given field offsetSYNOPSIS
string cubrid_field_type (resource $result, int $field_offset)
DESCRIPTION
This function returns the type of the column corresponding to the given field offset. The returned field type could be one of the follow-
ing: "int", "real", "string", etc.
PARAMETERS
o $result
-Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH.
o $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.
RETURN VALUES
Type of the column, on success.
FALSE when invalid field_offset value.
-1 if SQL sentence is not SELECT.
EXAMPLES
Example #1
cubrid_field_type(3) 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
", "Field Table", "Field Name", "Field Type");
for($i = 0; $i < $col_num; $i++) {
printf("%-15s %-15s %s
",
cubrid_field_table($result, $i), cubrid_field_name($result, $i), cubrid_field_type($result, $i));
}
cubrid_disconnect($conn);
?>
The above example will output:
Field Table Field Name Field Type
code s_name char
code f_name varchar
PHP Documentation Group CUBRID_FIELD_TYPE(3)