Closing connection?

[Anon]

Do I have to have some code at the end of my script to close the connection to mysql database?

[Anon]

Yep...

mysql_close($DATABASE);

Where $DATABASE is the handle returned from mysql_connect() or one of the other connection functions.

example:

//Open Connection to database on server localhost
$DATABASE = mysql_pconnect("localhost", "user", "password");
mysql_select_db("databasename", $DATABASE);

~QUERIES~

//Close connection to database.
mysql_close($DATABASE);

[Anon]

Usually not. PHP is one of those languages that closes all connections once the script ends.

But it's good practice to close them manually and not depend on the interpreter to clean up your mess :-)

[Anon]

Yeh, I don't know how it is on linux, but on Win32 platforms I've found it to have memory leaks if you don't do it manually. And I'm beginning to wonder about the interpreter actualy cleaning up the data array memory as well. Every 5-10 days the memory leaks get so bad we have to reboot our server or risk seeing a nasty "PHP is unable to run: Out of memory" or something like that. I'm probably going to have to look into actualy using all the release data functions to see if they help.