sybase_fetch_field

(PHP 4, PHP 5)

sybase_fetch_field — Get 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

参见

sybase_field_seek() - Sets field offset

add a note

User Contributed Notes 2 notes

down

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>";

down

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

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络数据库 JAVA 面试 NoSQL C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 PHP 8.1 ADORecordSet对象 adodb手册 opcache预加载 Composer的Packagist资源 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet PHP json解析（json_decode）页面工具 php中几种注释规范 mysql面试题 [原创]诡异的php-fpm超时问题纯php实现DES以及TripleDES加密算法两千行PHP学习笔记 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 php上周一、本周一、下周一日期

略微加速

PHP官方手册 - 互联网笔记

sybase_fetch_field

说明

参数

返回值

参见

User Contributed Notes 2 notes