sybase_fetch_field

(PHP 4, PHP 5)

sybase_fetch_fieldGet field information from a result

Warning

This 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

参见

add a note add a note

User Contributed Notes 2 notes

up
0
anthony dot leung at virgin dot net
17 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
0
gray at voicenet dot com
20 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
To Top 重庆肘时彩官网 内蒙古快三规律 内蒙古快3走势全图 陕西11选5复式怎么玩 浙江6+1开奖软件 新宝配资 快乐十分开奖查询 什么是股票怎么玩 快乐8中奖规则 宁夏11选5预测 现在能做基金配资业务的银行 平特一尾公式 11月森马服饰股票分析 河北快三基本走势图 手机幸运农场下载不了 手机股票网上开户 刘伯温高手论坛资料