...

View Full Version : lock a record from editing



esthera
12-24-2006, 10:54 AM
i have a form in an admin program i wrote that more then one people can be logged in and editing at the same time.
is it possible to make the form that it can detect if someone else has the saem form open and if so make it read only.

Linark
12-24-2006, 11:38 AM
You could do this by having a mySQL table called 'template_locked' and then set that table to the id of the person editing it, and then when the form is submitted/tried to edit it then have the script test this field and compare it against the user id.if it matches allow it to continue, if not exit we cant edit template.

esthera
12-24-2006, 11:39 AM
but how do I know they are editing?
it's just an html form that pulls the data from the db

Linark
12-24-2006, 11:50 AM
when the users clicks "edit" make the script query the database setting the template clicked to locked with there user id.

esthera
12-24-2006, 04:32 PM
but then if the session times out or they don't click save but just close the window then the record will be on edit forever wont' it?

anarchy3200
12-24-2006, 05:16 PM
Well create an extra field when you set the id that locked it and put in that the time it was checked out at, then you check the id and the checkout time.
If no id set : can edit
If id set: check time
---
If time > 15mins ago : can edit
If time < 15mins ago : cannot edit

esthera
12-24-2006, 06:05 PM
is there anyway to clear it on timeout or when the browser is closed?

it's just that someone can be on the form for more then 15 mintues so that's not really the best way.

anarchy3200
12-24-2006, 06:16 PM
Well the timestamp could only be updated on a submission by the user, i.e. them submitting the form, if the data entry takes longer then i think you would just have to use a longer time and accept the inconvenience of having to wait for it.
For your example of on the browser being closed at this point no information is sent to the server so it wouldn't be posible to remove the lock at this point.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum