PHP - Manual: mssql_fetch_field

2024-11-15

mssql_fetch_object »

« mssql_fetch_batch

mssql_fetch_field

(PHP 4, PHP 5, PECL odbtp >= 1.1.1)

mssql_fetch_field — Get field information

Warning

This function was REMOVED in PHP 7.0.0.

Alternatives to this function include:

PDOStatement::getColumnMeta()
sqlsrv_field_metadata()
The various odbc_field_* functions in the unified ODBC driver.

说明

mssql_fetch_field ( resource $result [, int $field_offset = -1 ] ) : object

mssql_fetch_field() can be used in order to obtain information about fields in a certain query result.

参数

result: The result resource that is being evaluated. This result comes from a call to mssql_query().
field_offset: The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is retrieved. The field_offset starts at 0.

返回值

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 - the column type.

范例

Example #1 mssql_fetch_field() example


<?php
// Connect to MSSQL and select the database
mssql_connect('MANGO\SQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');

// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

// Construct table
echo '<h3>Table structure for \'persons\'</h3>';
echo '<table border="1">';

// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';

// Dump all fields
echo '<tbody>';

for ($i = 0; $i < mssql_num_fields($query); ++$i) {
    // Fetch the field information
    $field = mssql_fetch_field($query, $i);

    // Print the row
    echo '<tr>';
    echo '<td>' . $field->name . '</td>';
    echo '<td>' . strtoupper($field->type) . '</td>';
    echo '<td>' . $field->max_length . '</td>';
    echo '</tr>';
}

echo '</tbody>';
echo '</table>';

// Free the query result
mssql_free_result($query);
?>

参见

mssql_field_seek() - Seeks to the specified field offset

add a note

User Contributed Notes 10 notes

down

schattenfeld at gmail dot com ¶

11 years ago


If you want to describe table like DESCRIBE in MySQL you can use this:
$sql = <<<SQL
SELECT column_name,data_type,column_default,is_nullable
FROM
  information_schema.tables AS t
  JOIN
  information_schema.columns AS c ON
    t.table_catalog=c.table_catalog AND
    t.table_schema=c.table_schema AND
    t.table_name=c.table_name
WHERE
  t.table_name='TABLE-NAME'
SQL;

down

huszti_dot_roland_at_freemail_dot_com ¶

13 years ago


For really detailed table information, use syscolumns, like this:

SELECT c.name, c.prec, c.scale, t.name type
  FROM syscolumns c, systypes t, sysobjects o
  WHERE o.name = 'yourtablename' AND o.id = c.id AND c.xtype = t.xtype

For other properties see the MS SQL online help. Search for 'syscolumns'.

Or an another solution:

sp_columns @table_name = 'yourtablename', @column_name = 'thecolumnname'
//no "select ..." !!!!

This gives info about only the specified column.

down

php_rindern_de ¶

14 years ago


commenting Reynard Hilman:

for me it looks like the colstat field value of 1 in syscolumns table indicates an Identity Column.

down

Reynard Hilman ¶

15 years ago


If you want to describe table structure (like mysql 'desc table' command), sending this query might help: 
<?
$sql = "SELECT c.name, c.isnullable, c.length, c.colstat, t.name type
  FROM syscolumns c, systypes t, sysobjects o
  WHERE o.name = '$table' AND o.id = c.id AND c.xtype = t.xtype";
?>
I suspect the colstat field in syscolumns table indicates primary key when its value is 1

down

bmaddy_at_class_dot_umn_dot_edu ¶

16 years ago


Be aware that this function will only return the first 30 characters of the name of the column.  If the actual column name is longer, it will be truncated.  This is at least true with the following setup:
PHP 4.3.1
MSSQL 8.00.760

Have a good day everyone!
Brian

down

alonf at spiralsolutions dot com ¶

16 years ago


As kubalaa at bigfoot dot com note mssql_fetch_field->column_source return field name instead table name also with MSSQL2000 connection. Be adwised!!!

down

-1

pong at taft dot org ¶

17 years ago


When you mssql_fetch_field(int result), you need to do loop to get the name of each field.  Something like:

while($fld = mssql_fetch_field($rs)){
        echo $fld->name . "<br>";         
    }

I am wondering why we cannot refer it by a field number.

down

-1

kubalaa at bigfoot dot com ¶

19 years ago


Using this function with MSSQL 7, $returned->column_source is the column name, not the table name as it should be.

down

-2

not a mail address ¶

10 years ago


kubalaa at bigfoot dot com first reported the problem that column_source contains the FIELD name instead of the source TABLE name 04-Apr-2000 03:58. The bug has been reported as well.

For those who wonder if it was fixed over the past 8 years: No, the bug still is the same, no workaround available.

down

-2

skipsey at hotmail dot com ¶

18 years ago


It seems fairly hard to get a list of the tables from your database using MSSQL but this seems to do the trick. This is set to get only the User Tables and ignores the sytem tables.



<?php

mssql_connect("server","","") or die ("help me!");

mssql_select_db("") or die ("Noooo!");



$result = mssql_query ("sp_tables");

$fields = mssql_num_fields ($result);

$rows   = mssql_num_rows ($result);



for ($f=0; $f<$rows; $f++) {    

    $CHKTYPE=GetField($result,"TABLE_TYPE",$f);

    

    if($CHKTYPE=='TABLE'){



        //$name = mssql_fetch_field($result, 2); 

        $field=GetField($result,"TABLE_NAME",$f)."<br>";

        echo $field;



    }

}

?>

add a note

官方地址：https://www.php.net/manual/en/function.mssql-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地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 PHP mkdir()写出来的权限与mode值不符合 adodb连接mysql多个数据库的问题 PHP获取指定函数定义在哪个文件中及行号 ADOConnection 公用函数 PHP-FPM进程数的设定

略微加速

PHP官方手册 - 互联网笔记

mssql_fetch_field

说明

参数

返回值

范例

参见

User Contributed Notes 10 notes