ThinkPHP5 锁

开发手册地址
https://www.kancloud.cn/manual/thinkphp5/118086
官网有关地址
http://www.thinkphp.cn/topic/9964.html
csdn地址
https://blog.csdn.net/nicajonh/article/details/78814987
https://blog.csdn.net/qq_37970345/article/details/72832093
https://blog.csdn.net/yao978318542/article/details/51209583
https://blog.csdn.net/qq_33867131/article/details/78561199

controller层
<?php
namespace app\home\controller;
use think\Controller;
use app\home\model\Test as TestModel;
class Test extends Controller {

    //锁表测试
    public function lock_table(){
        $testModel = new TestModel();
        $res = $testModel->lock_table(6);
        var_dump($res);
    }
    public function lock_table1(){
        $testModel = new TestModel();
        $res = $testModel->lock_table(8);
        var_dump($res);
    }
}

model层
<?php
namespace app\home\model;
use think\Db;
use think\Model;
class Test extends Model
{

    //锁表测试
    public function lock_table($shop_id){
        Db::startTrans();        // 启动事务
        try{
            $res = Db::name('shop')->lock(true)->where('Id',$shop_id)->select();
            if($res)
            {
                //执行你想进行的操作, 最后返回操作结果 result
                var_dump($res);
                sleep(2);
                $result = true;
                if(!$result)
                {
                    Db::rollback();//回滚
                    return 'error';
                }
            }
            Db::commit();// 提交事务
            return 'success';
        } catch (\Exception $e) {
            // 回滚事务
            Db::rollback();
        }
    }
}