Are mysql_close and pg_close required?

Question

Possible duplicate:
using mysql_close ()

Are mysql_close and pg_close required?

In some script, no ... why?

What happens if I do not use it?

Answer 1

If you do not call this, the socket connection to the database remains open for ~ 30 seconds in the standby state.

If you get many, many people, and you are not able to reuse these connections with zombies in any way, your database may explode with too much user error.

So, the answer to your question is: it is not syntactically required, but it is very bad practice not to include them.

Answer 2

Why don't you read it in the PHP reference manual? All information is ...

• http://www.php.net/mysql_close
• http://www.php.net/pg_close
• http://www.php.net/manual/en/language.types.resource.php#language.types.resource.self-destruct

But in a nutshell: no, they are not needed, but IMHO it is better to close the connections themselves to free up resources when you no longer need them.

Answer 3

You do not explicitly publish resources, but rely on server-side timeouts and application-side internal work.

Answer 4

PHP will close any open connection at the end of execution. Thus, nothing happens if you do not put it.

See http://www.php.net/manual/en/function.mysql-close.php

The use of mysql_close () is usually not required, as mutable open links automatically close at the end of the script.