ID:               46497
 Comment by:       lester at lsces dot co dot uk
 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:

Without more information on this there is nothing we can do. We do not
even know if the remote server is visible from outside PHP, and so there
is insufficient data to find a fault, since there are no other reports
of ibase_connect not working?


Previous Comments:
------------------------------------------------------------------------

[2008-11-10 10:15:21] mapopa at gmail dot com

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.

------------------------------------------------------------------------

[2008-11-07 00:39:35] fel...@php.net

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
&quot;***some ip***&quot;. 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

Reply via email to