Locking a detail view if a user is editing the item...

Posted by BenTheDesigner on Stack Overflow See other posts from Stack Overflow or by BenTheDesigner
Published on 2010-03-12T20:45:45Z Indexed on 2010/03/12 20:47 UTC
Read the original article Hit count: 122

Filed under:
|

Hi All

I am developing a user manager which must control access to the detail view of editable items. At present, when a user clicks 'edit', the application queries the link table to check if a user is currently editing that page, if not, it allows access to the page and then inserts a record into the link table preventing another user from editing the same page at the same time.

My question is what would the best way to handle the removal of records if say a user exists the browser without saving etc, therefore no action to remove the record.

I have a couple of ideas but would like other input before I decide.

BenTheDesigner

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql