|
Последние активные темы форума |
|
fbsql_fetch_field
(PHP 4 >= 4.0.6, PHP 5) fbsql_fetch_field --
Get column information from a result and return as an object
Описаниеobject fbsql_fetch_field ( resource result [, int field_offset] ) Returns an object containing field information.
fbsql_fetch_field() can be used in order to
obtain information about fields in a certain query result. If
the field offset isn't specified, the next field that wasn't yet
retrieved by fbsql_fetch_field() is retrieved.
The properties of the object are:
name - column name
table - name of the table the column belongs to
max_length - maximum length of the column
not_null - 1 if the column cannot be NULL
type - the type of the column
Пример 1. fbsql_fetch_field() example
<?php
fbsql_connect
(
$host
,
$user
,
$password
)
or die(
"Could not connect"
);
$result
=
fbsql_db_query
(
"database"
,
"select * from table"
)
or die(
"Query failed"
);
# get column metadata
$i
=
0
;
while (
$i
<
fbsql_num_fields
(
$result
)) {
echo
"Information for column $i:<br />
\n
"
;
$meta
=
fbsql_fetch_field
(
$result
);
if (!
$meta
) {
echo
"No information available<br />\n"
;
}
echo
"<pre>
max_length: $meta
->
max_length
name: $meta
->
name
not_null: $meta
->
not_null
table: $meta
->
table
type: $meta
->
type
</pre>"
;
$i
++;
}
fbsql_free_result
(
$result
);
?>
|
|
Смотрите также fbsql_field_seek().
|