Is there any method to close connection similar to mysql_close()
for $wpdb
in WordPress?
Is it not necessary to close connection for global $wpdb
?
Is there any method to close connection similar to mysql_close()
for $wpdb
in WordPress?
Is it not necessary to close connection for global $wpdb
?
Comments are closed.
You don’t have to worry about closing connection to you DB because it will be automatically closed when a request will be processed by your server.
But if you have to close it, then you can do something like this:
Pay attention that it could lead to unexpected results because other plugins could rely on this connection.
I don’t think
wpdb
actually cares to have a way for explicitly closing connection.From search through code base the WP’s unit tests (not actual core code) are doing the following (note the difference in API used since latest WP versions):
$wpdb
is aglobal
instance of thewpdb
class. That class is what creates the database connection and that single database connection is reused repeatedly by the WordPress Core, as well as by most plugins, and themes. You don’t want to close it. If you look at the source forwpdb
there isn’t even a method provided within the class to kill the connection.The only time I would close a
wpdb
connections would be for connections you’ve created, and never for the$wpdb
instance, and then you will have to follow the pattern suggested by @EugeneManuilov:That is likely to be a bit squirrelly in itself because the
$mydb
object doesn’t really know that the connection is gone. You’ve reached in and pulled the carpet out from under it without really resyncing things. The object isn’t meant to function like that. I’d probably explicitly kill the object afterwards withunset($mydb);