SQL Server 最大参数2100个,有什么办法循环查询
//获取数据库中的账号
$account = DB::connection('Me_MuOnline'. $_GET['serverCode'] .'')->table('MEMB_INFO')
->leftJoin('MEMB_STAT', 'MEMB_INFO.memb___id', '=','MEMB_STAT.memb___id' )
->select('MEMB_INFO.memb___id','MEMB_STAT.ConnectStat','MEMB_STAT.IP','MEMB_STAT.ConnectTM','MEMB_STAT.DisConnectTM');
// -----------
$character = DB::connection('MuOnline')->table('Character')
->leftJoin('AccountCharacter', 'Character.AccountID', '=','AccountCharacter.Id' )
->select('Character.AccountID', 'Character.Name', 'Character.Class', 'Character.cLevel','Character.mLevel', 'Character.RESETS', 'Character.Strength', 'Character.Dexterity','Character.Vitality', 'Character.Energy', 'Character.Leadership','Character.MapNumber','Character.MapPosX','Character.MapPosY','AccountCharacter.GameIDC')
//->whereIn('Character.AccountID',array_slice(json_decode($account->pluck('memb___id'),true),@$_GET['page']*50,2000))
->whereIn('Character.AccountID',$account->pluck('memb___id'))
->whereIn('Character.Class', $classCode)
->where(function ($query) {
$query->orWhere('Name', 'like', '%' . @$_GET['search'] . '%');
})
->orderBy('RESETS', 'desc')
->orderBy('mLevel', 'desc')
->orderBy('cLevel', 'desc')
->paginate(50)
->withPath('?serverCode=' . $_GET['serverCode'] . '&type=level&class=' . @$_GET['class'] . '&search=' . @$_GET['search'] . '');
最大参数2100个,有什么办法循环查询不影响分页和查询搜索
// 这个虽然能查询,然后2000个之后的搜索不到,分页总数也有点问题
->whereIn('Character.AccountID',array_slice(json_decode($account->pluck('memb___id'),true),@$_GET['page']*50,2000))
推荐文章: