#39494 [Opn->Fbk]: Cannot fetch any row

ID: 39494 Updated by: tony2001@php.net Reported By: taylor dot ren at gmail dot com -Status: Open +Status: Feedback Bug Type: InterBase related Operating System: XP PHP Version: 5.2.0 New Comment: Please enable error_reporting(E_ALL) at the top of the script and use _function_ ibase_errmsg(), not variable $ibase_errmsg. Previous Comments: ------------------------------------------------------------------------ [2006-11-13 23:38:54] taylor dot ren at gmail dot com Hi Tony, Thanks again. Code segment now looks like this: ================================ <body> <?php $connection = ibase_connect('localhost:f:/data/test.ib', 'tr', 'enigma', 'gb_2312'); var_dump($connection); var_dump($ibase_errmsg); $sql='select * from t1'; $result=ibase_query($connection, $sql); var_dump($result); var_dump(ibase_fetch_row($result)); var_dump($ibase_errmsg); ?> End of statement. =========================== Output now is: resource(1) of type (Firebird/InterBase link) NULL bool(false) bool(false) NULL End of statement. Any further comments? </body> ------------------------------------------------------------------------ [2006-11-13 12:59:33] tony2001@php.net >resource(1) of type (Firebird/InterBase link) bool(false) bool(false) Are you sure? There are 4 (four) var_dump() calls, but you showed 3. What if you put ibase_errmsg() right after the ibase_query() call? ------------------------------------------------------------------------ [2006-11-13 12:48:04] taylor dot ren at gmail dot com 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... ------------------------------------------------------------------------ [2006-11-13 12:29:55] tony2001@php.net 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? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/39494 -- Edit this bug report at http://bugs.php.net/?id=39494&edit=1