mssql_field_name

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

mssql_field_name — Get the name of a field

Warning

This function was REMOVED in PHP 7.0.0.

Alternatives to this function include:

说明

mssql_field_name ( resource $result [, int $offset = -1 ] ) : string

Returns the name of field no. offset in result.

参数

result: The result resource that is being evaluated. This result comes from a call to mssql_query().
offset: The field offset, starts at 0. If omitted, the current field is used.

返回值

The name of the specified field index on success 或者在失败时返回 FALSE.

范例

Example #1 mssql_field_name() example


<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name], [email] FROM [php].[dbo].[userlist]');

echo 'Result set contains the following field(s):', PHP_EOL;

// Dump all field names in result
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
    echo ' - ' . mssql_field_name($query, $i), PHP_EOL;
}

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

以上例程的输出类似于：

Result set contains the following field(s):
 - username
 - name
 - email

参见

mssql_field_length() - Get the length of a field
mssql_field_type() - Gets the type of a field

add a note

User Contributed Notes 3 notes

down

ian_channing at hotmail dot com ¶

5 years ago


There is a limitation of 30 characters for the field name. So if your query has  `fieldname AS really_long_overly_descriptive_name`, you will only get `really_long_overly_descriptiv` back

<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] AS [really_long_overly_descriptive_name], [name], [email] FROM [php].[dbo].[userlist]');

echo 'Result set contains the following field(s):', PHP_EOL;

// Dump all field names in result
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
    echo ' - ' . mssql_field_name($query, $i), PHP_EOL;
}

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

Outputs the following:

Result set contains the following field(s):
 - really_long_overly_descriptiv
 - name
 - email

down

harold at worby dot dns2go dot com ¶

17 years ago


A simple script to walk through an MSSQL server.
I'm using PHP 4.06 and Freetds 5.1 on Solaris 2.7 and Apache 1.3
Several of the msql_ functions seem to be broken/missing.
This is what I found to work.

<?php
// --------------------------------------------------------
// URL http://server/mssqltest.php?DB=Database&table=TableName
// --------------------------------------------------------
// Default settings: edit to meet your needs
if (!($user)) $user=sa;
if (!($pass)) $pass="password";
if (!($host)) $host="acer900";
// --------------------------------------------------
// connect to mssql server
$connect = mssql_connect($host,$user,$pass) or die ($host." not accessible.");
// select the database
if ($DB) mssql_select_db($DB)or die('USE '.$DB.' failed!');
if (!($table)) {
    $query="EXEC sp_tables \"%\",\"%\",\"".$DB."\",\"'TABLE'\"";
    $linkcol=2;
    $linkcol="TABLE_NAME";
$linkformat=" <a href=\"%s?DB=".$DB."&table=%s\">%s</a> ";
}else{ // tables and DB - Get DATA
    $query="SELECT * FROM ".$table;
    $linkformat=" <a href=\"%s\">%s</a> ";
}
if (!($DB))    {
    $query="EXEC sp_databases";
    $linkcol=0;
    $linkcol="DATABASE_NAME";
    $linkformat="<a href=\"%s?DB=%s\">%s</a>";
}

// run query
echo $query."<br>";
$result = mssql_query( $query) or die('Query failed!');
$fields = mssql_num_fields ($result) or die("Num Fields Failed");
$rows   = mssql_num_rows ($result);

echo "<br>Rows ".$rows." Fields ".$fields."<br>";
echo "<TABLE border=1><tr>";
// get field names
for ( $f = 0 ; $f < $fields ; $f++ ){
    $name = mssql_fetch_field($result, $f);
    echo "<td>".$f.$name->name."</td>";
// Strange here.. without the "X"'s the () is always TRUE??
    if ($name->name."X" == $linkcol."X") $linkcol = $f;
}
echo "</tr>";
//Display Data
for ($i = 0; $i < $rows ; $i =$i +1){
    for ($f = 0; $f<$fields ; $f++){
        $name=mssql_result($result,$i,$f);
        if ($f == $linkcol){
printf("<td>".$linkformat."</td>\n",$PHP_SELF,
 $name , $name );
        }
        else{
            echo "<td>". $name . "</td>";
        }
    }
echo "</tr>";
}
echo "</TABLE><br>";

// close connection 
mssql_close ($connect);
?>

down

tengel at sonic dot net ¶

18 years ago


This function isn't supported (PHP 4.0.2) if using Sybase/FreeTDS to access SQLServer (linux/solaris/bsd/etc).  Instead, use "mssql_fetch_field()" like so:



$field_name = mssql_fetch_field($query_result, $field_number);

print $field_name->name;

add a note

官方地址：https://www.php.net/manual/en/function.mssql-field-name.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获取指定函数定义在哪个文件中及行号 PHP mkdir()写出来的权限与mode值不符合 adodb连接mysql多个数据库的问题利用php soap实现web service ADOConnection 公用函数

略微加速

PHP官方手册 - 互联网笔记

mssql_field_name

说明

参数

返回值

范例

参见

User Contributed Notes 3 notes