#32405 [Opn->Fbk]: mysqli->fetch() is returning bad data

From: Date: Mon, 21 Mar 2005 23:10:42 +0000
Subject: #32405 [Opn->Fbk]: mysqli->fetch() is returning bad data
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-75693@lists.php.net to get a copy of this message 
 ID:               32405
 Updated by:       tony2001@php.net
 Reported By:      paul at thehedron dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         MySQLi related
 Operating System: Linux (fedora core 3)
 PHP Version:      5.0.3
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.0-win32-latest.zip




Previous Comments:
------------------------------------------------------------------------

[2005-03-22 00:06:09] paul at thehedron dot com

Description:
------------
mysqli->fetch() is returning bad data on int columns.  I saw this
listed, then closed as bogus (29002).  I just hit it today and assure
you it is not bogus.  

Here is my full setup:
-----------------------------------------------------------
CPU: AMD64 
OS:  Fedora Core 3 (2.6.9-1.667)
PHP: 5.0.3
     libmcrypt-2.5.7
     mcrypt-2.6.4
     mhash-0.9.2
Apache: 1.3.33
     mod_ssl-2.8.22-1.3.33
     openssl-0.9.7e
MySQL: 4.1.10
GCC: 3.4.2
-----------------------------------------------------------
PHP configuration:
./configure \
--with-apxs=/www/bin/apxs \
--with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config \
--with-mcrypt=/shared/LAMP/PHP5/libmcrypt-2.5.7 \
--enable-ftp \
--enable-trans-sid 


Reproduce code:
---------------
CREATE TABLE users (
user_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
lastname VARCHAR(50) NOT NULL,
PRIMARY KEY(user_id));
-----------------------------------------------------------------------
<?php
$mysqli = new mysqli('localhost', 'user', 'password',
'test');

if ($stmt = $mysqli->prepare("SELECT user_id, lastname FROM users")) {
   $stmt->execute();

   $stmt->bind_result($col1, $col2);

   while ($stmt->fetch()) {
       printf("%s %s <br />", $col1, $col2);
   }
   $stmt->close();
}
$mysqli->close();
?> 


Expected result:
----------------
Expected results:
1 Peterson
2 Asenbach

Actual result:
--------------
Actual results:
32199691940659210 Peterson 
32199691940659211 Asenbach 


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=32405&edit=1

Thread (7 messages)

« previous php.bugs (#75693) next »