Database transaction not working in controller codeigniter

Question

I am calling multiple models in controllers and all models do database query. i did something like this

public function InsertSale()
    {
            $this->db->trans_start(TRUE);
            // all logic part and models calling which do insert/update/delete

            $this->db->trans_complete();
}

Above code is not working even if something fails after some queries they dont rollback.

Why would you even have DB transaction in anything that you want to calls "a controller"?! — tereško, Aug 18 '14 at 05:25
Remove `TRUE` try using `$this->db->trans_start();` By default its true.I am using transaction like yours and working fine.So it should work for you too. — Shaiful Islam, Nov 19 '14 at 01:10
@tereško for changes that involve several models, for instace. — Sebastianb, Apr 16 '18 at 15:11
Ah, well .. what CodeIgnoter has are not "models". They are just table abstractions. Besides, "model" is not a class but a layer. Basically, you end up with all the business logic being dumped in the controllers. — tereško, Apr 16 '18 at 16:42

Rwd · Answer 1 · 2019-11-27T09:41:30.047

1

Having true in $this->db->trans_start(true); will put the transaction in to test mode which means that, regardless of what happens, the query will be rolled back.

If you wanted to see if the query would work you would use:

$this->db->trans_status();

Which will return either true/false depending on the outcome.

edited Nov 27 '19 at 09:41

answered Nov 19 '14 at 11:52

Rwd

34,180
6
64
78

score 0 · Answer 2 · edited May 23 '17 at 11:52

0

So that you have to follow like this

$this->db->trans_start(); # Starting Transaction
$this->db->trans_strict(FALSE); 

$this->db->insert('table_name', $someDataArray); # Inserting data

# Updating data
$this->db->where('id', $id);
$this->db->update('table_name', $someDataArray); 

$this->db->trans_complete();

This is work fine. Check this answer too

edited May 23 '17 at 11:52

Community

1
1

answered Jan 15 '16 at 13:01

Abdulla Nilam

36,589
17
64
85

Database transaction not working in controller codeigniter

2 Answers2