Geek Answers Handbook

How to close a PDO descriptor

I use PDO to access two SQLite 3 databases in PHP. I want to switch database files during a query by renaming them, but I cannot do this while the files are open, as it gives an error that the file is being used by another process. I tried to disconnect persistent connections and set the descriptors to null, but it does not work.

Is there no way to close the PDO descriptor and release the lock in the database file?

+5
source share
2 answers

I believe that unset($var)does this, I use it in my pdo sqlite project, and it works as if I want :)

+11
source

null ( , PDO, ), , .

$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.
+5

More articles:


All Articles