[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...