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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Sat Apr 20 04:01:28 2024 UTC