How to close a PDO handle

Question

I'm using PDO to access two SQLite 3 databases in PHP. I want to switch the database files during a query by renaming them but I can't do that while the files are open as it gives an error that the file is being used by another process. I've tried turning off persistent connections and setting the handles to null but neither work.

Is there really no way to close a PDO handle and release the lock on the database file?

Answer 1

I believe unset($var) does that, I use it on my pdo sqlite project and it works like I want it to :)

Answer 2

Set all references to the handle to null (or to anything except the PDO object, really) and the runtime will destruct the object, which will close the connection.

$db = new PDO('...');
// Do some stuff

$db = null;
// Assuming this was the last reference to that PDO
// object, the runtime will destroy the object and
// its connection.