+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Codeigniter $this->db->trans_begin(); if not committed or rolled back and page is refreshed it locks the db (/showthread.php?tid=49640)
Codeigniter $this->db->trans_begin(); if not committed or rolled back and page is refreshed it locks the db - El Forum - 02-27-2012
[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...