db connections in session variables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



I was wondering if it were possible to store a database connection in a
session variable.

I have tried these 2 methods:

$conn = pg_pconnect("server", "5432", "db");
session_start();
session_register('conn');

$conn = pg_pconnect("server", "5432", "db");
session_id($conn);
session_start();

both of them register a session with the value of "Resource id #1" but
don't act as a db connection.  I am just trying to clean up some code so I
don't have to do a new database connection on every page that I create.

Then if you are able to do this, where would you close the connection?

I guess in ASP, it is possible to store db connections in a session
variable.  I have never done it there either but someone told me that you
can.

Tim.

Timothy P. Maguire
Web Developer II
Harte-Hanks
978 436 3325




[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux