$param = input();
//搜索
$keyword = $param['keyword']??'';
$start_time = !empty($param['start_time']) ?strtotime($param['start_time']): 0;
$end_time = !empty($param['end_time']) ? strtotime($param['end_time']) : strtotime('2037-12-12');
$where = [];
$lists = Db::name('grade a')
->where( 'a.create_time','>=', $start_time)
->where( 'a.create_time','<=', $end_time )
->where('a.is_del',0)
->where( "a.grade_name|a.score|a.grade",'like',"%{$keyword}%" )//模糊搜索
->order( 'a.create_time desc' )
->paginate(15,null,['query'=>$param]);//分页搜索带条件
$page = $lists ->render();
$lists = $lists ->toArray()['data'];
tp5模糊查询、分页搜索带条件
最新推荐文章于 2022-10-31 16:25:52 发布