mssql_fetch_assoc

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

mssql_fetch_assoc — Retourne un tableau associatif pour la ligne courant de résultat MS SQL Server

Avertissement

Cette fonction a été SUPPRIMÉE à partir de PHP 7.0.0.

Les alternatives à cette fonction incluent :

Description

mssql_fetch_assoc ( resource $result_id ) : array

Retourne un tableau associatif pour la ligne courante de résultat MS SQL Server et déplace le pointeur de données interne au début. mssql_fetch_assoc() est équivalent à mssql_fetch_array() avec le paramètre MSSQL_ASSOC.

Liste de paramètres

result_id: La ressource de résultat à lire. Ce résultat provient d'un appel à la fonction mssql_query().

Valeurs de retour

Retourne un tableau associatif qui correspond à la ligne récupérée, ou FALSE s'il n'y a plus de ligne.

Exemples

Exemple #1 Exemple avec mssql_fetch_assoc()


<?php
// Effectue une sélection sur MSSQL
$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');

// Vérifie s'il y a des résultats
if (!mssql_num_rows($query)) {
    echo 'Pas de résultats trouvés';
} else {
    // Affiche une liste d'utilisateurs au format 
    // nom (login)

    echo '<ul>';

    while ($row = mssql_fetch_assoc($query)) {
        echo '<li>' . $row['name'] . ' (' . $row['username'] . ')</li>';
    }

    echo '</ul>';
}

// Libère les résultats
mssql_free_result($query);
?>

add a note

User Contributed Notes 8 notes

down

pegas1981 ¶

17 years ago


[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

down

php at electricsurfer dot com ¶

21 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.

down

simonh at dreameyemedia dot com ¶

15 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

down

electricsurfer.com ¶

20 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

down

jbarker at erepublic dot com ¶

17 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
)

*/
?>

down

ben at thelocust dot org ¶

18 years ago


The 30 character field name limit is still an issue as of PHP 5.1.6, at least running under IIS.

down

Anonymous ¶

17 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');

down

brandonkirsch at uses dot gmail dot domain ¶

17 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.

add a note