could a database connection remains through sessions ?

halxp

look, i create the connection (firebird) with $foo=ibase_pconnect(...), then I execute a statement $bar=$foo->ibase_query(...), then i perform some operation an return the control to the navigator, but keeping every object in the session, and at this point everything is ok and i know that all is working fine.
Well, when the navigator comes back to the server (a GET or POST) and i try to do this...
$bar2=$foo->ibase_query(...), i receive a (debugging) message notifying me that 'invalid database handle (no active connection)', i mean, the connection was lost even with pconnect...
Then, the question is ...
could connections remain through sessions ?, I know that the variables, arrays and objects can do (and they do it), but the connection could/should ?, if not ...
is there any way to do it ?
thanks in advance and sorry my poor English

ZibingsCoder

The way you've described this, there is no way to do this. It would be safer to "create" a persistant connection everytime your pages are loaded. Don't worry about it opening up too many connections, because the first thing a persistant connection does in PHP is search for a previous persistant connection.

To sum it all up, make sure to either create a config file or some kind of connection initialization on -each- page that can be loaded by a user. This will ensure that you never have this error. As to your question on whether or not it can be done through session, the answer is no.

halxp

but, what i really want is mantain the state of the statements, and reading the php docs, i understand now that it is not posible cause php was made to fetch rows secuentially from the first to the last record. And that explain (to me now) why all the libs developed to deal with databases (p.e. ADOdb for php) just save the entire resulsets into arrays.
I'm really sad for it, cause i was writing an interface for ADOdb in javascript+jsolait and embedded into xul, it was becoming a very cool lib, but now i believe that i'm gonna have to think in java (servlets) or something like that..., and i'm asking me weather i'm not reinventing the wheel...
well, thanks anyway...