#23613 [Opn]: ibase_fetch_assoc() elements and ibase_fetch_object() properties case-sensitive

ID: 23613 User updated by: vhcampos at terra dot com dot br -Summary: PHP sometimes cannot display fields by name, only by position Reported By: vhcampos at terra dot com dot br Status: Open Bug Type: InterBase related Operating System: Windows 98 -PHP Version: 4.3.1 +PHP Version: 4.3.2-RC3-dev New Comment: I changed my code to use ibase_fetch_assoc() instead of ibase_fetch_row() to get an associative array. Surprisingly all field names are case-sensitive, like ibase_fetch_object()'s properties, mentioned in a prior message. I believe this behavior is incorrect, those values should be case-insensitive. I tried this using Apache 1.3.27 for Windows, Firebird 1.0.2.908 and PHP versions 4.3.1 and 4.3.2-RC3-dev. Previous Comments: ------------------------------------------------------------------------ [2003-05-13 21:31:13] vhcampos at terra dot com dot br You're right about ibase_fetch_row(): I should have read the manual. As for ibase_fetch_object(), I noticed (after using var_dump()) that all returned fields are in uppercase, so the example in the manual is wrong (the "email" field in the example should be "EMAIL"). Couldn't it be case insensitive since all fields in Interbase/Firebird are converted to uppercase? ------------------------------------------------------------------------ [2003-05-13 16:05:30] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Also, shorten your example script, we don't need HTML in it. And read the manual, ibase_fetch_row() returns numerical indices. Try doing var_dump() on the $row with both ibase_fetch_row() and ibase_fetch_object(). FYI: There's ibase_fetch_assoc() (undocumented for some reason) which returns the stuff how you expect. ------------------------------------------------------------------------ [2003-05-13 12:51:11] vhcampos at terra dot com dot br I forgot to mention earlier, but if I use $row[1] instead of $row["name"] the field is correctly retrieved. ------------------------------------------------------------------------ [2003-05-13 12:49:13] vhcampos at terra dot com dot br When I use the following code for the following table, PHP returns the message: Notice: Undefined index: name in d:\sites\index.php on line 29 when I try to echo($row["name"]) (or whatever field I try). If I try using $row->name after a $row = ibase_fetch_object($rst), I get the message: Notice: Undefined property: name in d:\sites\index.php on line 39 The problem doesn't happen if the table is empty. Interbase table: CREATE TABLE "NAME" ( "COD" INTEGER NOT NULL, "NAME" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, "DATE1" TIMESTAMP, PRIMARY KEY ("COD") ); PHP Example: <? $local_bd = "intranet:D:\Database\Projetos.gdb"; $usuario = "SYSDBA"; $senha = "masterkey"; $characterSet = "WIN1252"; $cn = ibase_connect($local_bd, $usuario, $senha, $characterSet, 0, 3) or die("Cannot connect to database."); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Untitled</title> </head> <body> This is just a test. <p> <? $sql = "select cod, name, date1 from Name order by name"; $rst = ibase_query($cn, $sql); while ($row = ibase_fetch_row($rst)) { echo("ID: " . $row["cod"] . "<br>\n"); echo("Name: " . $row["name"] . "<br>\n"); } ibase_free_result($rst); $rst = ibase_query($cn, $sql); while ($row = ibase_fetch_object($rst)) { echo("ID: " . $row->cod . "<br>\n"); echo("Name: " . $row->name . "<br>\n"); } ibase_free_result($rst); ?> </body> </html> <? ibase_close($cn); ?> PS: I'm using Apache 1.3.27 for Windows, PHP 4.3.1 and Firebird 1.0.2.908 (the latest version of Firebird's 1.0 tree). ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23613&edit=1