Received: from hapcibeno.freestart.hu (hapcibeno.freestart.hu [213.197.64.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAEBYqm16900 for ; Wed, 14 Nov 2001 06:34:53 -0500 (EST) (envelope-from pgerzson@freestart.hu) Received: from erinyes.freestart.hu ([213.197.64.251] helo=jaguar) by freestart.hu with smtp (Freestart relay 2 (FS-Lin)) id 163ydm-0007Gl-00 for ; Wed, 14 Nov 2001 12:55:38 +0100 Message-ID: <00af01c16d00$a9eb9220$01fdfea9@jaguar> From: "Papp Gyozo" To: References: <20011113214943.350272AB48@bugs.unl.edu.ar> Subject: Re: db connections in session variables Date: Wed, 14 Nov 2001 10:53:49 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanner: exiscan by Freestart Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from base64 to 8bit by postgresql.org id fAEBe8L17027 X-Archive-Number: 200111/3 X-Sequence-Number: 650 Beside this overwhelming description, PHP manual states it somewhere, but I can't recall it exactly where. Oooh, what fool me! it was discussed in session_register section: (http://www.php.net/manual/en/function.session-register.php) "Note: It is not currently possible to register resource variables in a session. For example, you can not create a connection to a database and store the connection id as a session variable and expect the connection to still be valid the next time the session is restored. PHP functions that return a resource are identified by having a return type of resource in their function definitions. A list of functions that return resources are available in the resource types appendix." BTW, when I worte my first PHP code, this note had not been added yet, and I also tried to register resources. ----- Original Message ----- From: "Martín Marqués" To: Sent: Tuesday, November 13, 2001 10:49 PM Subject: Re: [PHP] db connections in session variables On Mar 13 Nov 2001 17:36, you wrote: > I was wondering if it were possible to store a database connection in a > session variable. No! Because the persistent connection gets opened with one child, and when you go for the next page you have very high probabilities (unless you have a very poor http configuration) of caching a new child, and not the old one. The problem comes here, just because the pconnect was done against the old child, and the new one doesn't know a thing about the pconnect you did before, so you'll allways (or almost always) an error of "wrong connection id". Hope I was clear. > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral ----------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org