- $num = 1;
- $good_id = 199758;
- $model = Db::name("tettt");
- $model->execute("set autocommit=0");
- $model->startTrans();
- //SELECT data AS old_data, version AS old_version FROM …
- $data = Db::name("tettt")->lock(true)->where('id',$good_id)->find();
- if(empty($data )){
- return "商品不存在";
- }
- $total = $data['count']; //商品库存
- if($total< $num){
- return "库存不足";
- }
- $data['count'] = $total-$num;
- $res = $model->where('id',$good_id)->update($data);
- if($res){
- $model->commit();
- return "成功购买".$num."个";
- }else{
- $model->rollback();
- return "shibai";
- }
上一篇:
php前后端分离项目跨域问题
友情提示:垃圾评论一律封号...