From: Timothy_Maguire@hartehanks.com
To: pgsql-php@postgresql.org
Subject: db connections in session variables
Date: Tue, 13 Nov 2001 15:36:59 -0500
Message-ID: <OFD16A9778.5F12758D-ON85256B03.0066298C@hartehanks.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: Timothy_Maguire@hartehanks.com
Subject: Re: db connections in session variables
In-Reply-To: <OFD16A9778.5F12758D-ON85256B03.0066298C@hartehanks.com>
References: <OFD16A9778.5F12758D-ON85256B03.0066298C@hartehanks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox