How to run Transactions in controller?

Add this to your BaseController in the "Preload" section of the initController method:

PHP Code:

$this->db = \Config\Database::connect(); //Load database connection 


You should then be able to use transactions in any Controller like this:

PHP Code:

$this->db->transStart(); //Begin database transaction
$this->db->transComplete(); //Complete database transaction