#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:
>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?
Previous Comments:
------------------------------------------------------------------------
[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?
------------------------------------------------------------------------
[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
Thread (10 messages)