Re: MySQL close connection, what's the purpose?
| From: | chris smith | Date: | Fri, 31 Mar 2006 23:37:52 +0000 |
| Subject: | Re: MySQL close connection, what's the purpose? | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-233026@lists.php.net to get a copy of this message | ||
On 4/1/06, Anthony Ettinger <aettinger@sdsualumni.org> wrote:
> On 3/31/06, chris smith <dmagick@gmail.com> wrote:
> > On 4/1/06, tedd <tedd@sperling.com> wrote:
> > > At 10:30 PM +0200 3/31/06, Martin Zvarík wrote:
> > > >Hi,
> > > > I was wondering why is it necessary to use
> > > >mysql_close() at the end of your script.
> > > >If you don't do it, it works anyways, doesn't it?
> > > >
> > > >MZ
> > >
> > > MZ:
> > >
> > > I always close the connection right after my
> > > query -- force of habit. It's like leaving the
> > > toilet seat up, it's only going to get you into
> > > trouble.
> >
> > So you close it after every query and then re-open it later for the
> > next query? I don't see that as a good idea.
> >
>
> No, you leave it open until you're done with the database.
Reading Ted's post didn't give this impression. I wanted to make sure
he wasn't doing it that way.
--
Postgresql & php tutorials
http://www.designmagick.com/