sybase_fetch_field
(PHP 4, PHP 5)
sybase_fetch_field — Get field information from a result
Описание
object sybase_fetch_field
( resource
$result
[, int $field_offset = -1
] )sybase_fetch_field() can be used in order to obtain information about fields in a certain query result.
Список параметров
-
result -
-
field_offset -
If the field offset isn't specified, the next field that wasn't yet retrieved by sybase_fetch_field() is retrieved.
Возвращаемые значения
Returns an object containing field information.
The properties of the object are:
- name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.
- column_source - the table from which the column was taken
- max_length - maximum length of the column
- numeric - 1 if the column is numeric
- type - datatype of the column
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Sybase
- sybase_affected_rows
- sybase_close
- sybase_connect
- sybase_data_seek
- sybase_deadlock_retry_count
- sybase_fetch_array
- sybase_fetch_assoc
- sybase_fetch_field
- sybase_fetch_object
- sybase_fetch_row
- sybase_field_seek
- sybase_free_result
- sybase_get_last_message
- sybase_min_client_severity
- sybase_min_error_severity
- sybase_min_message_severity
- sybase_min_server_severity
- sybase_num_fields
- sybase_num_rows
- sybase_pconnect
- sybase_query
- sybase_result
- sybase_select_db
- sybase_set_message_handler
- sybase_unbuffered_query
Коментарии
The 'type' field contains (roughly) the datatype of the source column. Types returned are:
'type' Sybase Type
------- --------------------------
string CHAR, VARCHAR, TEXT
image IMAGE
blob BINARY, VARBINARY
bit BIT
int TINYINT, SMALLINT, INT
real REAL, FLOAT, NUMERIC, DECIMAL
money MONEY
datetime DATETIME, SMALLDATETIME
Bit short on comments and tips bout this one so head down to mysql_fetch_fields where the concept is the same. I seemed to get an infinite loop over there using the $i counter tho, so I used a for loop instead.
The list of properties you can get from what I've called $info is in the example to the mysql equivalent.
//start of an example to print out column headings
echo "<table><tr>";
$numfields=sybase_num_fields($query);
for ($f=0;$f<=$numfields;$f++){
$info = sybase_fetch_field($query);
echo "<td> $info->name </td>";
}
echo "</tr><tr>";