php中范围查询语句,php-多个动态查询范围

我已经在数据库查询上建立了一个过滤器,现在

我想让它更舒适.

目标是使其具有动态性,这意味着

用户可以选择任意组合.

public function filter(FilterList $request)

{

$view = view('profile.browse.list');

$search = $request->get('filter');

$filter = [

'male' => Profile::male(),

'female' => Profile::female(),

'10' => Profile::man(),

'11' => Profile::women(),

'12' => Profile::couple(),

'15' => Profile::domina(),

'20' => Profile::affaire(),

'21' => Profile::cybersex(),

'22' => Profile::marriage(),

'23' => Profile::flirt(),

];

return $view->with([

'List' => $filter[$search]->unmoderated()->paginate(15)->appends(['filter' => $search]),

]);

}

我知道我的解决方案并不是很好的解决方案.

我已将查询范围保存在$filter数组中,

无法添加第二个或想要的范围

$users = User :: popular()-> women()-> orderBy(‘created_at’)-> get();

有任何暗示对我有帮助.

我不知道要开始…

谢谢你的帮助

编辑

public function scopeMarriage($query)

{

return $query->where('LookFor', 'LIKE', '%Ehe%');

}

解决方法:

因此,用户正在提交动态数量的输入,并希望基于这些输入将查询范围链接到您的查询？如果那是您想要的,我相信您可以做这样的事情：

// Method array taken from your example

$methods = [

'male' => 'male',

'female' => 'female',

'12' => 'couple',

];

// Begin the query. Since the unmoderated() scope query is always called,

// I used that in this example.

// But note that you can also use Model::query(); to begin a query

$query = Profile::unmoderated();

// Loop through the request inputs

foreach ($request->all() as $param)

{

// If it exists in the provided array, add it to the query.

if (array_key_exists($param, $methods))

{

$query->{$methods[$param]}();

}

}

// Call get, paginate, etc. to actually fetch the results and then return it.

return $query->paginate(15);

标签：laravel,php

来源： https://codeday.me/bug/20191119/2036840.html