using mysql_close() = best practice?
am 24.10.2009 10:36:06 von Kim Madsen
Hi
PHP closes an open db connection when the script is done.
I've read somewhere that in PHP6 this behaviour will dissapear, is this
true? In that case using mysql_close() would definetly be best practice
in all current scripts, to make it portable.
A nice solution would probably be adding a end_mysql() or page_end() to
all pages and put whatever is needed into that function (mysql_close,
mysql_free_result, etc)
--
Kind regards
Kim Emax - masterminds.dk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: using mysql_close() = best practice?
am 27.10.2009 07:35:18 von Eric Bauman
On 24/10/2009 7:36 PM, Kim Madsen wrote:
> Hi
>
> PHP closes an open db connection when the script is done.
>
> I've read somewhere that in PHP6 this behaviour will dissapear, is this
> true? In that case using mysql_close() would definetly be best practice
> in all current scripts, to make it portable.
>
> A nice solution would probably be adding a end_mysql() or page_end() to
> all pages and put whatever is needed into that function (mysql_close,
> mysql_free_result, etc)
>
I can't say with any certainty whether that is true or not - but it
certainly seems like it is false. Non-persistent connections are
destroyed automatically by the garbage collector when no more references
are detected. See
http://au2.php.net/manual/en/language.types.resource.php#lan guage.types.resource.self-destruct
That said, I believe it to be good practice to close any opened database
connection. All my database methods are wrapped in a class, however, so
I do this in the destructor.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php