ID: 35366 Updated by: [EMAIL PROTECTED] Reported By: sl898 at poczta dot onet dot pl -Status: Open +Status: Bogus Bug Type: InterBase related Operating System: Windows 2000/2003 PHP Version: 5CVS-2005-11-24 (snap) New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2005-11-28 15:13:36] tm at nanosoft dot com dot pl I found that after change a php.ini file from magic_quotes_runtime = On to magic_quotes_runtime = Off everything is ok, and empty fields from database are as expected. ------------------------------------------------------------------------ [2005-11-24 15:45:15] sl898 at poczta dot onet dot pl Description: ------------ Functions ibase_fetch_object, ibase_fetch_row return wrong values when there is an empty string ('') in firebird table. When there is a 'null' value in the table this problem doesn't occure. PHP ver. 5.0.0 works fine, problem is in ver 5.0.4 and higher. In this example in record number 3 there is value from record number 1 instead of empty string (''). Reproduce code: --------------- CREATE TABLE test_table (test_field VARCHAR(10)) Insert 4 records into test_table rec_no|test_field ------------------ 1 | 'test1' 2 | 'test2' 3 | '' 4 | 'test4' ------------------ $sql_string = "SELECT test_field FROM test_table"; $connection = ibase_connect($database, $user, $pass); $dbo = ibase_query($connection, $sql_string); while ( $oRow = ibase_fetch_object($dbo) ) { var_dump($oRow); } Expected result: ---------------- { ["TEST_FIELD"]=> string(5) "test1" } { ["TEST_FIELD"]=> string(5) "test2" } { ["TEST_FIELD"]=> string(0) "" } { ["TEST_FIELD"]=> string(5) "test4" } Actual result: -------------- { ["TEST_FIELD"]=> string(5) "test1" } { ["TEST_FIELD"]=> string(5) "test2" } { ["TEST_FIELD"]=> string(5) "test1" } { ["TEST_FIELD"]=> string(5) "test4" } ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35366&edit=1
