Posted by ~john on 09/28/56 11:48

I'm working on a multi-user system that at times may result in 2 users
accessing the same screen. These screens allow the users to both view
and update data. The problem comes when you have user A and user B
viewing the same screen and user A submits his page that writes to the
database. User B is now viewing a screen with invalid data. How do I
prevent this scenario from happening with PHP?

I thought about using a lock flag in a database table that gets set
when a page loads but realized there's a problem if the page is closed
and the the lock flag never gets reset.

What should I be doing to handle a situation like this?

thanks,

~john

• Next in forum: php/mysql grid app?
• Prev in forum: Finding out who clicked on my link
• Thread view: Maintaining data integrity with multiple users

[Reply to this message]