UPDATE – With SELECT before.

QuestionsUPDATE – With SELECT before.
Paul Kozlenko asked 10 years ago

I have just started using phpgrid – which I may add is extremely easy to use.

I have tested with 2 users making changes to the same data retrieved – user 1 makes a change, followed by user 2 making a different change. Using phpGrid without any changes, User 2's change wins and is saved.

My question is:
Is there a way to configure phpGrid to do a SELECT to the database with ALL the current row fields data before an update occurs to ensure another user's changes are not overwritten?

Ideally – when a save of already updated data (by another user) is attempted, an alert will appear to indicate this happening, and the grid will be refreshed to display the updated data.

Thank You

1 Answers
Abu Ghufran answered 10 years ago

Hello Paul,

First solution is to use excel-view (cellEdit) mode. In this way, only the changed cell is submitted to server and not the whole row data. You can refer demos/appearence/excel-view.php for working demo.

Second, If you want application based row level locking in grid:

1) Introduce a new field 'last_modified', make it hidden on grid and editable. It will store the timestamp of row update.
2) Implement an on_update event handler and check if:
i) Fetch the edited row db table row, using select query
i) Check if posted back 'last_modified' value is different from the one in database against same row id
ii) If Yes, You can show phpgrid_error('Already edited') otherwise, go with the update.

I've also prepared a demo for you: http://pastebin.com/Ds4WrD4z

Your Answer

4 + 8 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?