首選innodb存儲(chǔ)引擎才支持事務(wù)蝠猬。
$table=M('table');
$table->startTrans();//開(kāi)啟事務(wù)
$table->commit();//成功則提交
$table->rollback();//不成功尤蒿，則回滾
詳見(jiàn)代碼：
$returnorder=M('return_order_goods_info');
$returnorder->startTrans();//開(kāi)啟事務(wù)
$data['type']=I('tmp_type');
$data['description']=I('description');
$data['return_type']=I('tem_return_type');
$data['pick_up_province']=I('rev_province');
$data['pick_up_city']=I('rev_city');
$data['pick_up_county']=I('rev_county');
$data['pick_up_address']=I('rev_address');
$data['create_time']=time();
$orderinfo['sku_name']=I['sku_name'];
$orderinfo['sku_default_image']=I['sku_default_image'];
$resultinfo=M('return_order_commodity_info')->add($orderinfo);
$ceshi=M("return_order_commodity_info")->getLastSql();
if($result && $resultinfo){
$returnorder->commit();//成功則提交
$this->ajaxReturn(array("data"=>$data,"info"=>'已提交成功盏缤，請(qǐng)耐心等待工作人員審核',"status"=>1));
}else{
$returnorder->rollback();//不成功拉盾，則回滾
$this->ajaxReturn(array("data"=>$data,"info"=>'未提交成功，請(qǐng)聯(lián)系客服',"status"=>0));
}
第二種：
$trans_result = true;
$trans = M();
$trans->startTrans(); // 開(kāi)啟事務(wù)
try { // 異常處理
// 更新實(shí)施
$busbidList = M("busbid")->where($map)->select();
foreach($busbidList as $k => $v) {
$map['id'] = $busbidList[$k]['id'];
$result = M('busbid')->where($map)->data($data)->save();
if ($result === false) {
throw new Exception(“錯(cuò)誤原因”);
}
}
} catch (Exception $ex) {
$trans_result = false;
// 記錄日志
Log::record("== xxx更新失敗 ==", 'DEBUG');
Log::record($ex->getMessage(), 'DEBUG');
}
if ($trans_result === false) {
$trans->rollback();
// 更新失敗
$array['status'] = 0;
} else {
$trans->commit();
// 更新成功
$array['status'] = 1;
}
