[quote]
WARNING:
PHP 4.3.4 introduced a BUG.
if the DB has: '' (empty string)
this function will return: ' ' (string with 1 space)
see: http://bugs.php.net/bug.php?id=26315
[/quote]
the same version PHP 5.2.0
PHP - Manual: mssql_fetch_assoc
2024-12-21
mssql_fetch_assoc
(PHP 4 >= 4.2.0, PHP 5, PECL odbtp >= 1.1.1)
mssql_fetch_assoc — Returns an associative array of the current row in the result
Warning
This function was REMOVED in PHP 7.0.0.
Alternatives to this function include:
说明
mssql_fetch_assoc
( resource
$result_id
) : array
Returns an associative array that corresponds to the fetched row and moves
the internal data pointer ahead. mssql_fetch_assoc() is
equivalent to calling mssql_fetch_array() with
MSSQL_ASSOC for the optional second parameter.
参数
-
result_id -
The result resource that is being evaluated. This result comes from a call to mssql_query().
返回值
Returns an associative array that corresponds to the fetched row, or
FALSE if there are no more rows.
范例
Example #1 mssql_fetch_assoc() example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
}
else
{
// Print a nice list of users in the format of:
// * name (username)
echo '<ul>';
while ($row = mssql_fetch_assoc($query)) {
echo '<li>' . $row['name'] . ' (' . $row['username'] . ')</li>';
}
echo '</ul>';
}
// Free the query result
mssql_free_result($query);
?>
add a note
User Contributed Notes 8 notes
pegas1981 ¶
12 years ago
php at electricsurfer dot com ¶
16 years ago
WARNING: as of PHP 4.3.2
The keys in the array will only contain the 1st 30 characters of the column name if you have column names longer than that.
simonh at dreameyemedia dot com ¶
10 years ago
With the code mentioned above and in relation to a MSSQL query.
When using the following statements to retrieve dat "fetch_assoc" then running a split statement PHP it then into a array it will not pass the data retrieved will show correctly in a XML document created by the DOM object.
<?php
require("phpsqlajax_dbinfo.php");
// Start XML file, create parent node
$dom = new DOMDocument("1.0");
$node = $dom->createElement("markers");
$parnode = $dom->appendChild($node);
// Opens a connection to a DreameyeOne server
$connection=mssql_connect ("ELF\ELF", $username, $password);
if (!$connection) {
die('Not connected : ' . mssql_error());
}
// Set the active DreameyOne database
$db_selected = mssql_select_db($database, $connection);
if (!$db_selected) {
die ('Can\'t use db : ' . mssql_error());
}
// Select all the rows in the markers table
$query = "SELECT msg FROM ozekimessagein ORDER BY senttime DESC";
$result = mssql_query($query);
if (!$result) {
die('Invalid query: ' . mssql_error());
}
header("Content-type: text/xml");
// Iterate through the rows, adding XML nodes for each
while ($row = @mssql_fetch_assoc($result)) {
list ($vehicleID,$long,$lat) = split(',',$row);
// ADD TO XML DOCUMENT NODE
$node = $dom->createElement("marker");
$node = $dom->createElement("marker");
$newnode = $parnode->appendChild($node);
$newnode->setAttribute("VehicleID:",$vehicleID);
$newnode->setAttribute("lat",$lat);
$newnode->setAttribute("long",$long);
}
echo $dom->saveXML();
?>
Merlinman
electricsurfer.com ¶
15 years ago
WARNING:
PHP 4.3.4 introduced a BUG.
if the DB has: '' (empty string)
this function will return: ' ' (string with 1 space)
see: http://bugs.php.net/bug.php?id=26315
jbarker at erepublic dot com ¶
12 years ago
Beware when using mssql_fetch_assoc() to return data pulled in from joined tables; if the tables have the same column names, the column mentioned last will overwrite the prior one when populating the assoc.
Example:
<?
$result = mssql_query('SELECT articles.id, issues.id FROM articles, issues WHERE articles.pub_date = issues.pub_date');
$record = mssql_fetch_assoc($result);
print_r($record);
/*
Prints:
Array
(
[id] => 123
)
*/
?>
ben at thelocust dot org ¶
12 years ago
The 30 character field name limit is still an issue as of PHP 5.1.6, at least running under IIS.
Anonymous ¶
12 years ago
regarding 'The 30 character field name limit is still an issue'
Thought about using shorter column names and using the description to give more info regarding the column.
as to the
$result = mssql_query('SELECT articles.id, issues.id FROM articles, issues WHERE articles.pub_date = issues.pub_date');
try this
$result = mssql_query('SELECT articles.id as aid, issues.id as iid FROM articles, issues WHERE articles.pub_date = issues.pub_date');
brandonkirsch at uses dot gmail dot domain ¶
12 years ago
We are running FreeTDS on a Linux Apache / PHP server and encountered the following error when calling mssql_fetch_assoc()
Fatal error: Call to undefined function mssql_fetch_assoc()
We were confused because *some* of the mssql commands worked, such as mssql_connect and mssql_fetch_array. The trick to make mssql_fetch_assoc() work lies in configuring FreeTDS. We had to change the statement to contain the --enable-msdblib switch:
./configure --enable-msdblib
We then recompiled PHP to include --with-mssql=/path/to/freetds and finally mssql_fetch_assoc() began working properly.
官方地址：https://www.php.net/manual/en/function.mssql-fetch-assoc.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 FFI详解 - 一种全新的PHP扩展方式
两千行PHP学习笔记
php扩展开发