#48453 [Opn->Asn]: fetch_assoc() problem
| From: | pajoye@php.net | Date: | Thu, 04 Jun 2009 08:44:19 +0000 |
| Subject: | #48453 [Opn->Asn]: fetch_assoc() problem | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-138039@lists.php.net to get a copy of this message | ||
ID: 48453
Updated by: pajoye@php.net
Reported By: gubbov53 at hotmail dot com
-Status: Open
+Status: Assigned
Bug Type: MySQLi related
Operating System: Windows Vista
PHP Version: 5.2.9
-Assigned To:
+Assigned To: mysql
New Comment:
There is a script to test.
Previous Comments:
------------------------------------------------------------------------
[2009-06-04 08:41:15] gubbov53 at hotmail dot com
Tried with the latest PHP Version 5.2.10RC2-dev but the problem
remains.
------------------------------------------------------------------------
[2009-06-03 20:39:54] jani@php.net
Please read this: http://bugs.php.net/how-to-report.php
------------------------------------------------------------------------
[2009-06-03 12:48:40] gubbov53 at hotmail dot com
To have this problem set up a small MySQL db by running the following
as root:
------------
create database books_db;
use books_db;
create table books
( isbn char(13) not null primary key,
author char(50),
title char(100),
price float(4,2)
);
grant select, insert, update, delete
on books_db.*
to books_user@localhost identified by 'password';
insert into books values
("0-672-31697-8", "Michael Morgan", "Java 2 for Professional
Developers", 34.99),
("0-672-31745-1", "Thomas Down", "Installing Debian GNU/Linux",
24.99);
---------------
Then run this file in IE:
--------------
<html>
<body>
<?php
@ $db=new
mysqli('localhost','books_user','password','books_db');
if (mysqli_connect_errno()) {
echo "Error: Could not connect to database. Please try again
later.";
exit;
}
$query="select title,author from books where author like
'%Morgan%'";
$result=$db->query($query);
$num_results=$result->num_rows;
echo "<p>Number of books found: ".$num_results."</p>";
for ($i=0; $i<$num_results; $i++) {
$row=$result->fetch_assoc(); // loops here...
echo "<p><strong>".($i+1)." Title: ";
echo htmlspecialchars(stripslashes($row['title']));
echo "</strong><br />Author: ";
echo stripslashes($row['author']);
}
$result->free();
$db->close();
?>
</body>
</html>
------------------------------------------------------------------------
[2009-06-02 20:09:18] jani@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2009-06-02 15:13:12] gubbov53 at hotmail dot com
Description:
------------
fetch_assoc() (see below) does not work. Hangs Apache.
If "$row=$result->fetch_assoc();" is replaced by
"$row=$result->fetch_row();" the code is working...
Reproduce code:
---------------
$result=$db->query($query);
$num_results=$result->num_rows;
echo "<p>Number of books found: ".$num_results."</p>";
for ($i=0; $i<$num_results; $i++) {
$row=$result->fetch_assoc(); // Does not work!!!
...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=48453&edit=1