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] auroraeosrose@php.net 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] auroraeosrose@php.net 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