Re: closing database connection prior to redirection?
| From: | EaTrom | Date: | Fri, 15 Dec 2000 15:48:17 +0000 |
| Subject: | Re: closing database connection prior to redirection? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5271@lists.php.net to get a copy of this message | ||
I have a similar issue.. I run a php admin script that authenticates a user
into a MySQL database, and there is a function to close and unlock the db.
when that happens, it should log the admin out, and checking the environment
var SQL_AUTH_USER_NAME it looks fine, but if I select another option it
automatically reconnects using the previous user/password instead of
re-authenticating via login.
Any help?
> From: "Dave VanAuken" <dave@hawk-systems.com>
> Date: Thu, 14 Dec 2000 14:04:55 -0500
> To: <php-db@lists.php.net>
> Subject: RE: [PHP-DB] closing database connection prior to redirection?
>
> Is this for all database implementations? MySQl, PostgreSQL...
> particularly in the case of PHP header() redirect.
>
> thanks
>
> Dave
>
> -----Original Message-----
> From: Matthew Ballard [mailto:Matthew@TheAirport.com]
> Sent: Thursday, December 14, 2000 1:26 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] closing database connection prior to redirection?
>
>
> With PHP, when you hit the end of a script (which redirecting using
> Header(Location...) or Javascript or a Meta tag is), then as long as you
> don't use persistent conncetions, PHP automatically cleans up after the
> script including closing existing DB connections.
> Matthew