John Davidson

Message:

i have a question, if 100 users load the page simultaneously and i have the script like this:

select(some data)

if(exist)

{ update the data / etc }

and another page script like this:

delete(the data above)

Can something like this happen?

select(some data)

if(exist) // we get that exist

{

   // and here the date will be deleted by page 2 and cannot update or will be corrupted data

}

---

My Answer:
Yes, it is possible for corrupted data to occur in this scenario. If multiple users are accessing and modifying the same data simultaneously, there is a risk of data corruption or inconsistency.

To prevent this, you can use transactions in MySQL to ensure that all operations are completed successfully before committing the changes. You can also use locking mechanisms to prevent multiple users from accessing the same data at the same time.

It is important to carefully design your database schema and application logic to handle concurrent access to data to avoid data corruption.