When should I close a database connection in PHP?

by

Never create a new connection for every query; You don’t even have to close it manually.

Just create the connection at the beginning of you page

have a look at: How do you efficiently connect to mysql in php without reconnecting on every query

you can use this:

public function __destruct()
{
   mysql_close($this->connection);
}

it will get called when the page is closed

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. Commands out of sync; you can’t run this command now
  3. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  4. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  5. SELECT COUNT(*) AS count – How to use this count
  6. Example of how to use bind_result vs get_result
  7. mysqli::query(): Couldn’t fetch mysqli
  8. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  9. PHP MySQLI Prevent SQL Injection [duplicate]
  10. What is the difference between MySQL, MySQLi and PDO? [closed]
  11. How to test if a MySQL query was successful in modifying database table data?
  12. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  13. PHP Commands Out of Sync error
  14. Call to a member function execute() on boolean in [duplicate]
  15. Mysql No connection could be made because the target machine actively refused it
  16. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  17. How to connect to MySQL database in PHP using mysqli extension?
  18. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  19. Fatal error: Call to undefined function mysqli_result()
  20. Using PHP to execute multiple MYSQL Queries
  21. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  22. How to run multiple insert query in SQL using PHP in one go?
  23. Strange problem with the length of the field gotten from database [duplicate]
  24. PHP: mysql v mysqli v pdo [closed]
  25. mysqli persistent connection
  26. How do I ensure I caught all errors from MySQLi::multi_query?
  27. Mysqli multiple row insert, simple multi insert query [duplicate]
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. Why cannot the PHP hide the error message thrown by the MySQL connection?

Leave a Comment