[PHP] Using odbc_pconnect function

2002-12-09 Thread Luc Roettgers 
Hi,

Trying to use persistant connections to reduce general access times on my tables, I 
have the following problem. When creating my connection with: 

$connectionstring = odbc_pconnect(prov,username,pass); 

I'm able to use it on the current page but how do I resuse the variable 
$connectionstring on other pages since I make calls like:

$queryexe = odbc_do($connectionstring, $query);

Hope this is not confusing. Also, can I make the persistant connection expire after 
there have been no calls to the DB for a certain time?

Many Thanks,

-Luc

Re: [PHP] Using odbc_pconnect function

2002-12-09 Thread Adam Voigt 




I believe everything you have mentioned is automatic. You don't need to pass $connectionstring since PHP detects it's the same info and just sends you the same connection. Also, I believe PHP auto-closes after a certain amount of time (might be configurable, check the php.ini).



On Mon, 2002-12-09 at 10:48, Luc Roettgers wrote:

Hi,



Trying to use persistant connections to reduce general access times on my tables, I have the following problem. When creating my connection with: 



$connectionstring = odbc_pconnect(prov,username,pass); 



I'm able to use it on the current page but how do I resuse the variable $connectionstring on other pages since I make calls like:



$queryexe = odbc_do($connectionstring, $query);



Hope this is not confusing. Also, can I make the persistant connection expire after there have been no calls to the DB for a certain time?



Many Thanks,



-Luc




-- 
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc








signature.asc
Description: This is a digitally signed message part