PHP MySQL Database Connection

Question

Is it necessary to explicitly close a DB connection after executing a query (and other DB operation)?

Answer 1

No, php does that automatically. You could call it "good programming practice" to clean up (aka close the connection) though.

Answer 2

Generally, only close it after you have finished the database for that entire page. Also, depending on the API you are using to handle the database, most ones you should be using now (such as PDO) are implemented via Objects, so the destructor will automatically handle closing it at the end if needed.