where like php,php – Eloquent – 多个WHERE LIKE条件

使用闭合.首先,确保将关键字列表存储到数组等中.然后 …

$keywords = ['samsung', 's7', 'what else'];

$products = Product::where(function ($query) use ($keywords) {

foreach ($keywords as $keyword) {

$query->orWhere('keyword', 'like', $keyword);

}

})->paginate(15);

其他例子

$keywords = [

['name', 'LIKE', $searchQuery],

['category_id', '=', $selectedSubcategory],

];

$products = Product::where(function ($query) use ($keywords) {

foreach ($keywords as $keyword) {

$query->where($keyword);

}

})->paginate(15);

除了其他

$keywords = [

['name', 'LIKE', $searchQuery],

['category_id', '=', $selectedSubcategory],

['please_id', '=', $learnPhpArray],

];

$products = Product::query();

foreach ($keywords as $keyword) {

$products = $products->where($keyword);

}

return $products->paginate(15);

orWhere做了什么？它是否用AND连接查询部分？

不,用OR.作为逆(？),默认情况下它本身就是AND.

参考