Re: [PHP] Using odbc_pconnect function

[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