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