Edit Report a Bug

    mssql_fetch_assoc

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

    mssql_fetch_assoc — 結果の現在行を連想配列として返す

    警告

    この関数は PHP 7.0.0 で 削除 されました。

    この関数の代替として、これらが使えます。

    説明

    mssql_fetch_assoc ( resource $result_id ) : array

    取得した行に対応する連想配列を返し、内部データポインタをひとつ進めます。 mssql_fetch_assoc() は、 mssql_fetch_array() の二番目のオプションパラメータに MSSQL_ASSOC を指定してコールするのと同等です。

    パラメータ

    result_id

    処理対象となる結果リソース。これは mssql_query() のコールによって取得します。

    返り値

    取得した行に対応する連想配列を返します。もう行がない場合は FALSE を返します。

    例

    例1 mssql_fetch_assoc() の例

    <?php
    // select クエリを MSSQL に送信します
    $query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');

    // レコードが存在するかどうかを調べます
    if (!mssql_num_rows($query)) {
        echo     'No records found';
    }
    else
    {
            // ユーザー一覧を
        // * name (username) 形式で出力します

            echo '<ul>';

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

        echo     '</ul>';
    }

    // 結果を開放します
    mssql_free_result($query);
    ?>

    add a note add a note

    User Contributed Notes 8 notes

    up
    5
    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
    up
    2
    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.
    up
    1
    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
    up
    2
    electricsurfer.com
    21 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
    up
    1
    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
    )

    */
    ?>
    up
    1
    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.
    up
    0
    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');
    up
    0
    brandonkirsch at uses dot gmail dot domain
    18 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 add a note
    To Top