DB Transaction with CodeIgniter

Transaction in CodeIgniter

CodeIgniter’s database abstraction allows you to use transactions with databases that support transaction-safe table types. In MySql, InnoDB table type provides support for transaction.
CodeIgniter facilitates developers so that either CI manages commit and rollback commands or allows its developers to do it.

DB Transaction Managed By CI

$this->db->trans_start();
$this->db->query('AN SQL QUERY...');
$this->db->query('ANOTHER QUERY...');
$this->db->query('AND YET ANOTHER QUERY...');
$this->db->trans_complete();

You can write as many queries as you want between trans_start() and trans_complete(). System will commit or rollback based to success of failure of all queries.

You can pass value as “true” in-order to check rollback functionality. If you pass “true” as value in trans_start() function, it will not add values in DB even if System executes insert DB command.

$this->db->trans_start(true);

Transactions Managed by Developers Manually

$this->db->trans_begin();

$this->db->query('AN SQL QUERY...');
$this->db->query('ANOTHER QUERY...');
$this->db->query('AND YET ANOTHER QUERY...');

if ($this->db->trans_status() === FALSE)
{
$this->db->trans_rollback();
}
else
{
$this->db->trans_commit();
}

By using CodeIgniter’s default functions or writing code manually, Developer can provide support for database transactions and ensure Data Integrity.