DB connection in session

[Anon]

Hi,
I've made a class called DB.php. This is a class that contains methods to connect to a PgSQL database and run queries on the tables.
I want to be able to "carry" the DB object along when I move around my site.

The reason is that I don't want to connect to the database more that once.

I've tried handling this with sessions, and it seems like I'm able to store the object in the session.

My problem is that i can't use my methods on the object anymore.

Can anybody help?
Maybe you know a way that I can bring my connection along as I move around my site?

Thanks in advance!

Kristian Blom

[[deleted]]

Well, I'm not being familiar with your code, I can only offer this one suggestion...

If you are opening the connection to the database with pg_connect, when the script is through, it usually automatically closes the connection. You might want to move over to pg_pconnect to obtain a persistent connection. An added benefit from using pg_pconnect is that you shouldn't have to pass around your object. According to the manual, if you use pg_pconnect a second time with the same parameters (which I'm sure your class calls it the same why each time), it will not open up a new connection, but use the existing one...

Hope that info helps,
Matt Wade
codewalkers.com

[Anon]

Thanks...
I think it worked pretty well...