Sunday, 15 September 2013

mysql - Should I try a rollback before beginning a new transaction? -



mysql - Should I try a rollback before beginning a new transaction? -

i have uncertainty , can't find similar question.

in generic php script like:

$pdo->begintransaction(); //... //many things do... //... $pdo->commit();

let's user stops page loading or loses connection before commit reached. transaction remain opened? have seek rollback before begintransaction?

if worried user dropping connection, improve off using ignore_user_abort

ignore_user_abort

that way, regardless of whether user stops page loading or other consequence, script runs until completion.

mysql pdo transactions rollback

No comments:

Post a Comment