Bret

Can you figure out how many minutes the average userwould take for an update/edit function? You could then write a CRON script to reset those accounts after some predetermined expiry time is reached.

Another option is to timestamp when the user requests the record and when it gets updated...if the update timestamp is before the request timestamp and the requestor id doesn't match the updator id, you know you haven't had the record checked in yet. You can then decide if there was an appropriate delay before issuing out the record to another user for their edit...

Bastien


From: Bret Walker <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] DB Access, Sessions and Blocking Access
Date: Wed, 17 Aug 2005 17:19:38 -0500

Hello-

I'm developing a web-based system whereby users can edit documents and
then e-mail the documents to selected recipients.

The "documents" are comprised of the data from several MySQL fields.

I want to make sure that two people don't edit a document at the same time.

My users log in via a script that starts a session.

My initial idea was to have a field to denote file access (1 for "in
use" 0 for available).  The problem with this would be if a user
navigates to a different page or closes the browser window without
clicking a "save" or "close" button (which would execute a query to set
the in_use field to 0).

I'm sure others have dealt with the issue of exclusive access to a MySQL
resource.  I've looked into InnoDB transactional support, but that
doesn't seem to be what I need, since I'm not overly concerned about
simultaneously access, just simultaneous editing.

How can I ensure the "document" isn't accessed by two people at the same
time?

Thanks,
Bret


<< smime.p7s >>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to