ifx_fieldtypes
(PHP 4, PHP <=5.2.0)
ifx_fieldtypes — List of Informix SQL fields
Description
array ifx_fieldtypes
( resource
$result_id
)
Returns an associative array with fieldnames as key and the SQL
fieldtypes as data for the query associated with
result_id
.
Parameters
-
result_id
-
result_id
is a valid resultid returned by ifx_query() or ifx_prepare() (select type queries only!).
Return Values
Returns an associative array with fieldnames as key and the SQL
fieldtypes as data for query with
result_id
. Returns FALSE
on error.
Examples
Example #1 Fieldnames and SQL fieldtypes
<?php
$types = ifx_fieldtypes($resultid);
if (is_array($types)) {
foreach ($types as $fname => $val) {
echo "$fname:\t type = $val\n";
}
}
?>
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Informix
- ifx_affected_rows
- ifx_blobinfile_mode
- ifx_byteasvarchar
- ifx_close
- ifx_connect
- ifx_copy_blob
- ifx_create_blob
- ifx_create_char
- ifx_do
- ifx_error
- ifx_errormsg
- ifx_fetch_row
- ifx_fieldproperties
- ifx_fieldtypes
- ifx_free_blob
- ifx_free_char
- ifx_free_result
- ifx_get_blob
- ifx_get_char
- ifx_getsqlca
- ifx_htmltbl_result
- ifx_nullformat
- ifx_num_fields
- ifx_num_rows
- ifx_pconnect
- ifx_prepare
- ifx_query
- ifx_textasvarchar
- ifx_update_blob
- ifx_update_char
- ifxus_close_slob
- ifxus_create_slob
- ifxus_free_slob
- ifxus_open_slob
- ifxus_read_slob
- ifxus_seek_slob
- ifxus_tell_slob
- ifxus_write_slob
Коментарии
Alternativly i found you can always do it like this using the foreach() loop...
$types = @ifx_fieldtypes($resultid);
if (isset($types))
{
foreach($types as $field_name => $data_type)
{
echo "{$field_name} {$data_type}";
}
}