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
] )
Used in order to obtain information about fields in a certain query result.
Список параметров
- result
-
A result identifier returned by fbsql_query() or fbsql_db_query().
- field_offset
-
The numerical offset of the field. The field index starts at 0. If not specified, the next field that wasn't yet retrieved by fbsql_fetch_field() is retrieved.
Возвращаемые значения
Returns an object containing field information, or FALSE on errors.
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);
?>
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- FrontBase
- fbsql_affected_rows
- fbsql_autocommit
- fbsql_blob_size
- fbsql_change_user
- fbsql_clob_size
- fbsql_close
- fbsql_commit
- fbsql_connect
- fbsql_create_blob
- fbsql_create_clob
- fbsql_create_db
- fbsql_data_seek
- fbsql_database_password
- fbsql_database
- fbsql_db_query
- fbsql_db_status
- fbsql_drop_db
- fbsql_errno
- fbsql_error
- fbsql_fetch_array
- fbsql_fetch_assoc
- fbsql_fetch_field
- fbsql_fetch_lengths
- fbsql_fetch_object
- fbsql_fetch_row
- fbsql_field_flags
- fbsql_field_len
- fbsql_field_name
- fbsql_field_seek
- fbsql_field_table
- fbsql_field_type
- fbsql_free_result
- fbsql_get_autostart_info
- fbsql_hostname
- fbsql_insert_id
- fbsql_list_dbs
- fbsql_list_fields
- fbsql_list_tables
- fbsql_next_result
- fbsql_num_fields
- fbsql_num_rows
- fbsql_password
- fbsql_pconnect
- fbsql_query
- fbsql_read_blob
- fbsql_read_clob
- fbsql_result
- fbsql_rollback
- fbsql_rows_fetched
- fbsql_select_db
- fbsql_set_characterset
- fbsql_set_lob_mode
- fbsql_set_password
- fbsql_set_transaction
- fbsql_start_db
- fbsql_stop_db
- fbsql_table_name
- fbsql_tablename
- fbsql_username
- fbsql_warnings
Коментарии
404 Not Found