- PHP 手册
- 函数参考
- 数据库扩展
- 针对各数据库系统对应的扩展
- Sybase
- Sybase 函数
sybase_fetch_field
(PHP 4, PHP 5)
sybase_fetch_field — Get field information from a result
WarningThis function was REMOVED in PHP 7.0.0.
说明
sybase_fetch_field ( resource$result
[, int $field_offset = -1
] ) : object
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
参见
- sybase_field_seek() - Sets field offset
User Contributed Notes 2 notes
up down 0 anthony dot leung at virgin dot net ¶15 years ago
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>";
up
down
0
gray at voicenet dot com ¶19 years ago
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
add a note
官方地址：https://www.php.net/manual/en/function.sybase-fetch-field.php