<?php

namespace app\test\controller;

use think\Controller;

use think\Db;

class Index extends Controller

{

    public function index()

    {

        $time = date('H:i:s');

        // 开启事务

        Db::startTrans();

        db('sms')->lock(true)->select();//加锁

        $update1 = db('sms')->where(['id' => 1])->update(['email' => 1]);

        $update2 = db('sms')->where(['id' => 2])->update(['email' => 2]);

        $update3 = db('sms')->where(['id' => 3])->update(['email' => 8]);

        if($update1 && $update2 && $update3){

            sleep(5);

            Db::commit();//提交

            return $time.'_lock_true_'.date('H:i:s').'---'.$update1.'---'.$update2.'---'.$update3;

        }else{

            Db::rollback();//回滚

            return $time.'_lock_false_'.date('H:i:s').'---'.$update1.'---'.$update2.'---'.$update3;

        }

    }

}