halben Posted September 12, 2013 Share Posted September 12, 2013 Hi, I'm new to this forum and I'm looking for some assistance. I have the following code: (just a quick example) <?php try { // import Soap client require_once('/random.php'); // connect to 3rd party DB $3rd_db_client = new Something($one, $two, $three); // Do some more stuff } catch(exception $e) { echo $e->getMessage() ; exit; } ?> My question is, does the catch{ exit; } close the DB connection? Quote Link to comment https://forums.phpfreaks.com/topic/282109-closing-a-db-connection-when-not-need/ Share on other sites More sharing options...
Drongo_III Posted September 12, 2013 Share Posted September 12, 2013 Generally a connection to a database will close when the script stops executing. So exiting the script would in theory close the connection. However there are database specific functions for closing the connection which are more appropriate - e.g mysqli_close. Equivalents exist for pdo etc. http://php.net/manual/en/mysqli.close.php Quote Link to comment https://forums.phpfreaks.com/topic/282109-closing-a-db-connection-when-not-need/#findComment-1449275 Share on other sites More sharing options...
Irate Posted September 12, 2013 Share Posted September 12, 2013 Only if you get an error in your try block. Use a finally { exit; } block. Quote Link to comment https://forums.phpfreaks.com/topic/282109-closing-a-db-connection-when-not-need/#findComment-1449279 Share on other sites More sharing options...
halben Posted September 12, 2013 Author Share Posted September 12, 2013 Thanks guys. Fast reply, I'm liking this forum! Quote Link to comment https://forums.phpfreaks.com/topic/282109-closing-a-db-connection-when-not-need/#findComment-1449291 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.