database update

Questionsdatabase update
Paul Kozlenko asked 6 years ago

I would like to update a database (multi-user environment) using PHPGRID, not only by a unique column qualification, but using the original row data in the WHERE clause to confirm data hasn't been changed by another user.

Does phpgrid have a way to enable this feature? Or is there an example solution of how this can be accomplished?

Another reason for asking this, is that some tables don't have a single unique key column. They might make use of several columns to create the uniqe selection.

– Paul

1 Answers
Abu Ghufran answered 6 years ago

Hello,

There is no other way except row id based checks in on_update/on_insert event handlers.
Locking will need to be managed manually in operations callback event handlers.

Refer demos/editing/custom-events.php for events help.

Your Answer

8 + 17 =

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?