ID: 46497
Comment by: mapopa at gmail dot com
Reported By: andre dot gadonski at gmail dot com
Status: Open
Bug Type: InterBase related
Operating System: FreeBSD
PHP Version: 5.2.6
New Comment:
i think you need to use pconnect
ibase_pconnect() acts very much like ibase_connect() with two major
differences.
First, when connecting, the function will first try to find a
(persistent) link that's already opened with the same parameters. If
one is found, an identifier for it will be returned instead of opening
a new connection.
Previous Comments:
------------------------------------------------------------------------
[2008-11-07 00:39:35] [EMAIL PROTECTED]
I can't reproduce it on Linux.
------------------------------------------------------------------------
[2008-11-05 19:00:55] andre dot gadonski at gmail dot com
Description:
------------
I'm using connect, the error had to be in the connect function and not
in the query function.
The interbase server is not on same computer as the script.
The function connect should be get the connection from the previous
persistent connection.
Apache version: Apache 2.0 Handler
Reproduce code:
---------------
<?php
$conn = ibase_connect(...);
$sql = ibase_prepare($conn, 'SELECT * FROM USUARIO WHERE USU_SENHA = ?
AND USU_COD = ?;');
$query = ibase_execute($sql, $param['pwd'], $param['usr']);
$row = ibase_fetch_object($query);
exit(var_dump($row));
?>
Actual result:
--------------
object(stdClass)#3 (6) {
["USU_COD"]=>
int(61)
["USU_NOME"]=>
string(25) "ANDRE GADONSKI DE FREITAS"
["USU_CATEG"]=>
int(0)
["USU_SENHA"]=>
string(6) "xxxx"
["USU_LOGIN"]=>
NULL
["USU_DOMINIO"]=>
NULL
}
<br />
<b>Warning</b>: Unknown: Unable to complete network request to host
"***some ip***". Error reading
data from the connection. Bad file descriptor in <b>Unknown</b> on
line <b>0</b><br />
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=46497&edit=1
