在PHP脚本执行期间处理Internet连接崩溃的最佳方法

Question

I have a script that executes multiples inserts in a MySQL Database with PHP PDO. User clicks a button and a insert is done. Button can be clicked one minute later and another insert is done. This can be done until user cliks on button "End Application". What to do when internet connection crashes before user clicks "End Application"? Is it possible to rollback the mysql queries even without internet connection? Thank you.

Answer 1

If you have an application that can be ended, then it be started as well, which means that you have at least one additional status of the progress of the user;

I would imagine a table with the various states in which the progress can be

• started
• ended
• deleted (?)

Then you need a table in which you need to watch the progress of the user, the status and the run which this person currently does; as it is not clear what your application looks like it is difficult to give some hints on this.

Nevertheless, with a status and a user and a run you can always recover from a break in the internet connection.