ID: 39494 User updated by: taylor dot ren at gmail dot com Reported By: taylor dot ren at gmail dot com -Status: Feedback +Status: Open Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment:
Hi Tony, Thanks for your quick fdbk. The output is like this per your suggest script: resource(1) of type (Firebird/InterBase link) bool(false) bool(false) It seems to me the connection to InterBase is fine but the $result fails after call to ibase_query()... as it returns false... Previous Comments: ------------------------------------------------------------------------ [2006-11-13 12:29:55] [EMAIL PROTECTED] What do you get with this script? <?php $connection = ibase_connect('localhost:f:/data/test.ib', 'tr', 'enigma', 'gb_2312'); var_dump($connection); $sql='select * from t1'; $result=ibase_query($connection, $sql); var_dump($result); var_dump(ibase_fetch_row($result)); var_dump(ibase_errmsg()); ?> ------------------------------------------------------------------------ [2006-11-13 12:28:17] taylor dot ren at gmail dot com BTW, the PHPinfo() prompts the below Interbase related info: interbase Firebird/InterBase Support dynamic Compile-time Client Library Version Interbase 6 Run-time Client Library Version WI-V7.5.1.80 Is it because I am using IB 7.5 but the compile time lib is only IB 6? ------------------------------------------------------------------------ [2006-11-13 12:24:47] taylor dot ren at gmail dot com Description: ------------ I installed PHP with IIS and opened InterBase ext. 1. IB is OK. I can run separately developed Win32 programs. 2. PHP is OK. I can load a PHP test file with as simple as phpinfo(); 3. ibase_XXXX functions seems OK because there is no error message prompted. 4. Database/table name OK. PHP Interbase script: Tried in Firefox & IE6. Reproduce code: --------------- <body> <?php $connection = ibase_connect('localhost:f:/data/test.ib', 'tr', 'enigma', 'gb_2312'); $sql='select * from t1'; $result=ibase_query($connection, $sql); while($row=ibase_fetch_object($result)) { echo (int)$row->id1, "\n"; } ibase_free_result($result); ibase_close($connection); ?> End of statement. </body> Expected result: ---------------- I am expecting something like: 1 2 Actual result: -------------- but only the last HTML statement: "End of statement" was displayed. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1