之前tp5的时候一直这样写
//同字段名时，使用field明确返回的字段以及别名 $join = [ ['cmf_mudidi_class w','a.class_id=w.id'], ]; $mudidi=Db::table('cmf_mudidi')->alias('a')->field('a.id,w.type_id,a.name,w.class_name') ->join($join)->paginate(10);后来发现最早的写法太诡异，刚好最近写到搜索，特别记录下
// 搜索记录 public function search_log(){ $param=$this->request->param(); if(empty($param['page'])){ $this->error('搜索记录不存在'); } $begin_time=$param['begin_time']; $end_time=$param['end_time']; $keywords=$param['keywords']; $where=array(); if($begin_time || $end_time){ $begin_time=strtotime($begin_time); $end_time=strtotime($end_time); $where[]=['a.ctime','between',[$begin_time,$end_time]]; } if(!empty($keywords)){ $where[]=['b.dog_card_number',$keywords]; } $list=DB::name('search_log')->alias('a') ->join('dog b','a.dog_id = b.id') ->where($where) ->where('b.card_status',2) ->paginate(10); $this->success($list); }