Welcome Guest, Not a member yet? Register   Sign In
Codeigniter $this->db->trans_begin(); if not committed or rolled back and page is refreshed it locks the db
#1

[eluser]Unknown[/eluser]
Codeigniter $this->db->trans_begin(); if not committed or rolled back and page is refreshed it locks the db.

I have a page where $this->db->trans_begin(); is used and some insertions are done. Then a modal opens and asks user to confirm and if confirmed by user it commits the transaction else rolls but if i when the modal opens before committing or roll back happening i refresh he browser. On following the same thing 3 to 4 times the browser hangs as tables gets locked...

Does anybody knows how in case the transaction is open in codeigniter and page is refreshed i can close it before starting a new one...




Theme © iAndrew 2016 - Forum software by © MyBB