Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Making a database connection persists in PHP


  • From: "Michael Swierczek" <mike(dot)swierczek(at)gmail(dot)com>
  • To: "Mary Anderson" <maryfran(at)demog(dot)berkeley(dot)edu>
  • Cc: pgsql-novice(at)postgresql(dot)org
  • Subject: Re: Making a database connection persists in PHP
  • Date: Mon, 31 Mar 2008 22:10:37 -0400
  • Message-id: <68b5b5880803311910p66fda93cw75fe07c140996619@mail.gmail.com> <text/plain>

Mary,
     I think this is more of a PHP question than a Postgres question.
I believe you can put the question in a session variable.   You may
also want to investigate connection pooling, where your application
keeps a set of open connections and then each time a request needs a
connection, it grabs one from the pool, uses it, and then gives it
back.   A web search on connection pooling and PHP should tell you
what you need.
     Good luck.

-Mike

On 3/31/08, Mary Anderson <maryfran(at)demog(dot)berkeley(dot)edu> wrote:
> Hi all,
>     Don't know if this should go to the PHP group or the postgresql group
>
>     I am writing a PHP-postgres application.  I would like to have a
>  database connection persists across php pages.  What the application
>  does at present is to create a new connection every time a new page is
>  called.  Can I put a connection into a session variable?
>
>     Thanks
>
>  Mary Anderson
>
>
>  --
>  Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>  To make changes to your subscription:
>  http://www.postgresql.org/mailpref/pgsql-novice
>



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group