thinkphp5常用

db()->startTrans();//开启事务
$res_a = db('sendgroup')->where(['pc_id'=>$pc_id,'sendblock_id'=>$sendblock_id,'pc_id'=>$pc_id])->delete();
$res_b = db('sendgroup')->insertAll($data);
if($res_a && $res_b){
   db()->commit(); // 提交事务
   $this->success('操作成功');
}else{
   db()->rollback();// 回滚事务	
   $this->error('操作失败');
}

 

public function index(){
	$where['is_use'] = ['eq',1];//1-上架中 2-已下架
	$list = db('cheap_card')->field('a.*,b.user_id,b.user_id,is_use')->alias('a')->join('cleap_card_get b','a.id=b.cheap_card_id','LEFT')->where($where)->order('a.id asc')->paginate(20)->each(function($item, $key){
		return $item;
	});
	$this->assign('list', $list);
	return view();
}