ID: 45289 Updated by: u...@php.net Reported By: mike dot benza at rice dot edu Status: No Feedback Bug Type: MySQLi related Operating System: * PHP Version: 5.2.4 New Comment:
I think its bogus. Wrong use of the API. The critical part here is that you get a result set at all... Previous Comments: ------------------------------------------------------------------------ [2009-05-15 19:55:28] jochen dot wiedmann at gmail dot com I have checked the latest snapshot (php5.2-200905151830), whether the problem still persists by using the script below. (Should be easy to derive a .phpt file from it.) <?php $mysqli = mysqli_init(); $mysqli->real_connect("localhost", "root", null, 'test'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $mysqli->query("DROP TABLE IF EXISTS prep_and_fetch_row") or die($mysqli->error); $mysqli->query("CREATE TABLE prep_and_fetch_row(id BIGINT NOT NULL PRIMARY KEY, name VARCHAR(64) NOT NULL)") or die($mysqli->error); $mysqli->query("INSERT INTO prep_and_fetch_row (id, name) VALUES (1, 'abc')") or die($mysqli->error); $stmt = $mysqli->prepare("SELECT * FROM prep_and_fetch_row WHERE id=?") or die($mysqli->error); $id = "1"; $stmt->bind_param("i", $id) or die($mysqli->error); $stmt->execute() or die($mysqli->error); $result = $mysqli->use_result() or die($mysqli->error); while ($row = $result->fetch_row()) { print "----- result row -----------\n"; print_r($row); } print "----- no more results -----------\n"; $mysqli->query("DROP TABLE prep_and_fetch_row") or die($mysqli->error); $mysqli->close(); ?> Expected output: Something like ----- result row ----------- Array ( [0] => int(1) [1] => string(3) "abc" ) ----- no more results ----------- Actual output: ----- result row ----------- Array ( [0] => [1] => ) ----- no more results ----------- I'd consider this to be a clear bug. ------------------------------------------------------------------------ [2009-05-15 13:39:22] jochen dot wiedmann at gmail dot com I have the same problem with PHP 5.2.6, as delivered with Fedora 10 Linux. ------------------------------------------------------------------------ [2008-07-22 01:00:02] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2008-07-14 21:05:49] j...@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi ------------------------------------------------------------------------ [2008-07-11 08:54:43] omolano at PLEASENOSPAMinicia dot es I've also had this problem. In my case I was trying to use PDO::FETCH_ASSOC on a prepared statement and the database was SQLite 3 based. I also got null values, like the above poster, not garbage. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/45289 -- Edit this bug report at http://bugs.php.net/?id=45289&edit=1