is it necessary to use mysql_close() at the end of a query in PHP?
+3
A:
Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. See also freeing resources.
read more at :
Haim Evgi
2010-01-14 15:41:28
Performance can be improved by closing as soon as you are done so the handle is available for other processes to use.
Adeel
2010-08-11 05:39:50
+10
A:
In the manual :
mysql_close() closes the non-persistent connection to the MySQL server that's associated with the specified link identifier.
Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.
More reading about that here
marcgg
2010-01-14 15:41:30
Terminating resources as soon as they're no longer required is always a good practice. If your script is long running holding on to resource you no longer need just brings you closer to resource exhaustion.
preinheimer
2010-01-14 15:54:13
+1
A:
No. When the PHP requests ends all resources will be freed, including MySQL connection resources.
CodeAddict
2010-01-14 15:41:42
+2
A:
As answered by others and the manual, it's not necessary. But if you wonder the use; you usually only want to do this when there is more to come in the PHP script and you want to ensure that another connection/transaction is to be used then.
BalusC
2010-01-14 15:45:41