How to implement mysql record locking in Yii2

Question

I want to implement record locking functionality in my Yii2 application.

If one user opens update link/record (Ex.http://localhost/myproject/backend/web/user/update/1) then another user cannot able to access thislink and user will get an ALERT message saying "This record already opened by another user". So the record/page should lock for another user. (Same like MS Excel locking)

Once first user finishes and leaves from that record/page then it should unlock and another user can read/update that data.

So how can I use mysql database locking mechanism here in Yii2 active records or is there any other way to implement this.

Any help would be appreciated.

arogachev arogachev · Accepted Answer · 2015-07-07T13:57:54

It's called Optimistic Locking and described in official docs. Here is an example of implementation:

// ------ view code -------

use yii\helpers\Html;

// ...other input fields
echo Html::activeHiddenInput($model, 'version');


// ------ controller code -------

use yii\db\StaleObjectException;

public function actionUpdate($id)
{
    $model = $this->findModel($id);

    try {
        if ($model->load(Yii::$app->request->post()) && $model->save()) {
            return $this->redirect(['view', 'id' => $model->id]);
        } else {
            return $this->render('update', [
                'model' => $model,
            ]);
        }
    } catch (StaleObjectException $e) {
        // logic to resolve the conflict
    }
}

How to implement mysql record locking in Yii2

2 Answers