db connections in session variables - Mailing list pgsql-php

From Timothy_Maguire@hartehanks.com
Subject db connections in session variables
Date
Msg-id OFD16A9778.5F12758D-ON85256B03.0066298C@hartehanks.com
Whole thread Raw
Responses Re: db connections in session variables  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-php
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



pgsql-php by date:

Previous
From: "Dan Wilson"
Date:
Subject: phpPgAdmin finds new home
Next
From: Martín Marqués
Date:
Subject: Re: db connections in session variables