ibase_fetch_assoc
(PHP 5)
ibase_fetch_assoc — Fetch a result row from a query as an associative array
Описание
$result
[, int $fetch_flag = 0
] )Fetch a result row from a query as an associative array.
ibase_fetch_assoc() fetches one row of data from the
result. If two or more columns of the result
have the same field names, the last column will take precedence. To
access the other column(s) of the same name, you either need to access
the result with numeric indices by using
ibase_fetch_row() or use alias names in your query.
Список параметров
-
result -
The result handle.
-
fetch_flag -
fetch_flagis a combination of the constantsIBASE_TEXTandIBASE_UNIXTIMEORed together. PassingIBASE_TEXTwill cause this function to return BLOB contents instead of BLOB ids. PassingIBASE_UNIXTIMEwill cause this function to return date/time values as Unix timestamps instead of as formatted strings.
Возвращаемые значения
Returns an associative array that corresponds to the fetched row.
Subsequent calls will return the next row in the result set, or FALSE if
there are no more rows.
Смотрите также
- ibase_fetch_row() - Fetch a row from an InterBase database
- ibase_fetch_object() - Get an object from a InterBase database
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Firebird/InterBase
- ibase_add_user
- ibase_affected_rows
- ibase_backup
- ibase_blob_add
- ibase_blob_cancel
- ibase_blob_close
- ibase_blob_create
- ibase_blob_echo
- ibase_blob_get
- ibase_blob_import
- ibase_blob_info
- ibase_blob_open
- ibase_close
- ibase_commit_ret
- ibase_commit
- ibase_connect
- ibase_db_info
- ibase_delete_user
- ibase_drop_db
- ibase_errcode
- ibase_errmsg
- ibase_execute
- ibase_fetch_assoc
- ibase_fetch_object
- ibase_fetch_row
- ibase_field_info
- ibase_free_event_handler
- ibase_free_query
- ibase_free_result
- ibase_gen_id
- ibase_maintain_db
- ibase_modify_user
- ibase_name_result
- ibase_num_fields
- ibase_num_params
- ibase_param_info
- ibase_pconnect
- ibase_prepare
- ibase_query
- ibase_restore
- ibase_rollback_ret
- ibase_rollback
- ibase_server_info
- ibase_service_attach
- ibase_service_detach
- ibase_set_event_handler
- ibase_trans
- ibase_wait_event
Коментарии
If your php is older than version 4.3.0, you can use the following:
$arr_record = get_object_vars(ibase_fetch_object($sql_result));
which is the same as: $arr_record = ibase_fetch_assoc($sql_result);
Unlike mysql_fetch_assoc, all indexes of associative array are upper-case.
so, use
$row = ibase_fetch_assoc($result);
echo $row["INDEX"];
not
echo $row["index"];