TP5-事务的操作与回滚

Db::startTrans();
try{
    $order = Db::name('charge')->where('order_no', $data['out_trade_no'])->find();
    if(!$order){
        echo 'FAIL';
        exit();
    }
    if($order['status']==){
        echo 'FAIL';
        exit();
    }
    DB::table('charge')->where('order_no', $data['out_trade_no'])->update(['status'=>1, 'update_time'=>time()
    Db::table('user')->where('id', $order['user_id])->setInc('money', $order['money']);
    $data = array(
        'uid'  => $order['user_id'],
        'type' => 3,
        'relation' => $order['id'],
        'money' => $order['money'],
        'info' => '会员充值' . $order['money'] . '元',
        'create_time' => time(),
        'create_ip' => request()->ip()
    );
    Db::name('wealthlog')->insert($data);
    //提交事务
    Db::commit();
    echo 'SUCCESS';
} catch (\Exception $e) {
    //回滚事务
    Db::rollback();
    echo 'FAIL';
}