|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24538 sqlite_fetch_array
Submitted: 2003-07-08 08:05 UTC Modified: 2003-10-18 22:09 UTC
Avg. Score:1.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: john at ceressoft dot nl Assigned:
Status: Closed Package: SQLite related
PHP Version: 5CVS-2003-07-08 (dev) OS: Linux
Private report: No CVE-ID: None
 [2003-07-08 08:05 UTC] john at ceressoft dot nl
when fetching data with sqlite_fetch_array as an assioative array, the data and names mixes wrong up.

Output from print_r:

{0] =>
    [time] => 1057663053
    [app] => OLAF
    [user] => Pakhuis administratie
    [msg] => login, new session

As you can see, columns app and user are exchanged


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2003-07-08 08:16 UTC]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.

How about a complete self-contained reproducing script? :)

 [2003-07-15 16:36 UTC]
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

 [2003-10-18 21:41 UTC] kevin at oceania dot net
Tested this bug with php5beta2 and the problem does not exist
any longer, if it did in the beginning. test script follows...

/* ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#SQLite Admin Structure Dump for table testtable
CREATE TABLE testtable (fone VARCHAR(99) NOT NULL DEFAULT 'blah', ftwo VARCHAR(3) NOT NULL DEFAULT 'blahblah', fthree VARCHAR(99) NOT NULL DEFAULT '')
### SQLite Admin Data Dump for table testtable
INSERT INTO testtable ( one, two, three);
INSERT INTO testtable ( one2, two2, three3);
INSERT INTO testtable ( one3, two3, three3);
INSERT INTO testtable ( one4, two4, three4);
INSERT INTO testtable ( one5, two5, three5);
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ */
  // make sure it is broken
  // our sql
  $sql = "SELECT * FROM testtable";
  // connect to the db
  $db = @sqlite_open('test.db', 0666, $sqliteerror);
  // run the query
  $res=sqlite_query($db, $sql);
  // set a counter
  // begin table for layout
  echo '<table border="1"><tr>';
  // get the field names
        // echo the field names
        echo '<th>'.sqlite_field_name($res, $i).'</th>';
        // increment the counter
  // end the table header row
  echo '</tr>';
  // loop through the ASSOCIATIVE array
  while($row=sqlite_fetch_array($res, SQLITE_ASSOC))
        // echo out the values
        echo '<tr><td>'.$row['fone']. '</td><td>'.$row['ftwo'].'</td><td>'.$row['fthree'].'</td></tr>';
  // end of table
  echo '</table>';
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 16 12:01:29 2024 UTC