User Abort / Connection Lost

[n2o666]

Hi,

I have written a content management application in PHP. It allows users to build web sites with information pages and stock pages etc...

They are formed from a table with pageno, paragraph no etc...

Until recently everything has been OK, but I am having problems with the paragraph numbers being duplicated. After several weeks of headaches I have located the problem.

An example if a user has 300 items on a page when item 1 is deleted the script moves all the paragraph no's down 1 position. In addition to this it also renames images (an oversight in my part not having a primary key in the database at the start).

The problem is that if a user looses their connection or presses the stop button the moving down of the paragraph no's stops and the images may not be renamed.

What is the best way of trapping the stop button or disconnect and forcing the script to continue to completion.

I have tried the function ignore_user_abort() but this doesn't seem to work (mind you I was using it at the top of the PHP function file and not in my function itself). There is a reference to a setting in php.ini for turning it on/off but it is not in my php.ini.

Anyone got any ideas.

Thanks,

Mark

[The_Chancer]

Just as a suggestion - and I know it is bad practice, but why not use an onclose popup, that will check if the previous script has finished, if not it will complete the work, then close itself... and if so it just closes itself.

Will have to rely on javascript though.. thats the only bad part....

[n2o666]

Hi,

Thanks for the suggestion but I was overlooking the obvious course to take, SQL Transactional Queries, if the whole of the paragraphs don't get renumbered then do not commit the query. Therefore if the connection is closed prematurely the database will remain unaltered. The problem with the images being renamed I am addressing with naming them with a unique field from the DB thus they do not need to be renamed when the paragraphs are altered.

Mark