Is there transaction support in the new PHP SQLite3 class?

Question

I discovered that there is a new SQLite3 class (starting with PHP 5.3.3) and started using it in my last project.

http://www.php.net/manual/en/book.sqlite3.php

Everything was fine until I needed transactions. Am I missing something in the documentation? How can I achieve transactions using this class.

Answer 1

Since SQLite3 itself supports transactions, it seems that all you have to do is initialize the transactions with the query: BEGIN TRANSACTION (as on other systems) and COMMIT TRANSACTION to complete the query.