Bug #52027 [Bgs]: NULL bytes in mysqli prepared statements

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

 ID:               52027
 User updated by:  jamie at splooshmedia dot co dot uk
 Reported by:      jamie at splooshmedia dot co dot uk
 Summary:          NULL bytes in mysqli prepared statements
 Status:           Bogus
 Type:             Bug
 Package:          PHP-GTK related
 Operating System: Windows 7
 PHP Version:      Irrelevant

 New Comment:

Thanks for your help. After getting mysql dll files from PHP 5.2.13NTS
and copying them into PHP-GTK the problem has gone.. Must have been a
version mismatch as you say! Strange that some functionality worked but
not all.


Previous Comments:
------------------------------------------------------------------------
[2010-06-09 15:22:22] [email protected]

BTW - some additional debugging suggestions for your setup - testing
against WAMP is irrelevant, it's a different PHP executable in a
different location with different extensions and loading different
dependencies

Try your mysqli on your php-gtk install, just comment out the php-gtk
extension, and see if you still get the errors

------------------------------------------------------------------------
[2010-06-09 15:12:51] [email protected]

Cannot reproduce - works perfectly here

check that you do not have the wrong libmysql being loaded (not
php_mysqli.dll - but the libmysql.dll that it uses - this sounds like a
client mismatch)

------------------------------------------------------------------------
[2010-06-09 11:22:09] jamie at splooshmedia dot co dot uk

Description:
------------
MySQLi prepared statements always return NULL bytes when running in
PHP-GTK. This bug does not exist in WAMP environment. Normal queries
work fine in PHP-GTK. My PHP-GTK/MySQL setup is fine.

Test script:
---------------
$test = null;
if($stmt = $mysqli->prepare("SELECT 'here 3' FROM saved_data LIMIT 1"))
{	
	echo 'here 1';
	$stmt->bind_result($test);	
	$stmt->execute();
	while($stmt->fetch()) {
                echo 'here 2';
		var_dump($test);
	}
}

Expected result:
----------------
here 1
here 2
string(6) "here 3"

Actual result:
--------------
here 1
here 2
string(7) "       "


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



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