php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #17872 ifx_fetch_row return the same tuple more than once
Submitted: 2002-06-20 06:45 UTC Modified: 2002-06-20 06:53 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: mario dot pranjic at irb dot hr Assigned:
Status: Not a bug Package: Informix related
PHP Version: 4.2.1 OS: Sun Solaris 7
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mario dot pranjic at irb dot hr
New email:
PHP Version: OS:

 

 [2002-06-20 06:45 UTC] mario dot pranjic at irb dot hr
Ever since version 4.0.5, Informix driver seems to be broken.

For further information, please look at the bug: http://bugs.php.net/bug.php?id=15600
that I submitted on 18th February this year.

Hope that someone will finally fix informix driver. I'm not the only loser using informix-php combination, am I?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-06-20 06:49 UTC] derick@php.net
That one is still open, and this bug report doesnt provide any information -> bogus (all more information to the first report in the future).

Derick
 [2002-06-20 06:52 UTC] mario dot pranjic at irb dot hr
I wanted to list the reseults from the query from the database. I got
one tuple as a result.
ifx_num_rows returns 1 at the end of the listing the results.
But, I got 4 same tuples on the output. I used the structure for
ifx_fetch_row as described in the example in documantation.
The structure:
$row = ifx_fetch_row ($rid, "FIRST");
 while (is_array($row)) ...

is not working properly...

This was all working just fine in php 4.0.5

The example:
        $conn_id=ifx_connect ("database@servertcp", "user",
"password");

        if (! $conn_id) {
                echo "<b>Ne mogu se spojiti na bazu</b>";
                exit;
        }

        $rid = ifx_prepare ($select, $conn_id);

        if (! $rid) {
                printf("Do&#353lo je do pogre&#353ke u radu\n");
                zavrsi($conn_id);
        }

        if (! ifx_do ($rid)) {
                printf("Ne mogu izvr&#353iti upit nad bazom
podataka\n");
                zavrsi($conn_id);
        }

        $row = ifx_fetch_row ($rid, "FIRST");

        while (is_array($row)) {
                for (reset($row); $fieldname = key($row); next($row)) {
                        $rez = array_values($row);

                        echo $rez[0];
                }
                $row = ifx_fetch_row ($rid, "NEXT");
        }

        $rowcount = ifx_num_rows($rid);

        ifx_free_result ($rid);
        ifx_close ($conn_id);
 [2002-06-20 06:53 UTC] derick@php.net
I thought I asked to add information to the FIRST report. Please leave this one bogus, and add relevant NEW information to the first one (15600).

Derick
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Mon May 12 06:01:28 2025 UTC