close
2021-08-12: 昨天又用到多筆WHERE條件
但是怎麼用怎麼錯，原來最外面還要用一個ARRAY把他包起來 = =" de了一個小時才發現
特此手動至頂一下
$query->where([
['column_1', '=', 'value_1'],
['column_2', '<>', 'value_2'],
[COLUMN, OPERATOR, VALUE],
...
])--
Q: 在Laravel eloquent中從DB中搜尋條件如果有很多的話看起來就會很醜，有沒有一次加入所有條件的方法？
ex:
$results = User::where('this', '=', 1)
->where('that', '=', 1)
->where('this_too', '=', 1)
->where('that_too', '=', 1)
->where('this_as_well', '=', 1)
->where('that_as_well', '=', 1)
->where('this_one_too', '=', 1)
->where('that_one_too', '=', 1)
->where('this_one_as_well', '=', 1)
->where('that_one_as_well', '=', 1)
->get();
A:
where條件可以帶入搜尋條件Array，詳細如下：
In Laravel 5.3 (and still true as of 6.x) you can use more granular wheres passed as array:
$query->where([
['column_1', '=', 'value_1'],
['column_2', '<>', 'value_2'],
[COLUMN, OPERATOR, VALUE],
...
])Personally I haven't found use-case for this over just multiple where calls, but fact is you can use it.
Since June 2014 you can pass an array to where
As long as you want all the wheres use and operator, you can group them this way:
$matchThese = ['field' => 'value', 'another_field' => 'another_value', ...];
// if you need another group of wheres as an alternative:
$orThose = ['yet_another_field' => 'yet_another_value', ...];Then:
$results = User::where($matchThese)->get();
// with another group
$results = User::where($matchThese)
->orWhere($orThose)
->get();The above will result in such query:
SELECT * FROM users
WHERE (field = value AND another_field = another_value AND ...)
OR (yet_another_field = yet_another_value AND ...)
全站熱搜
留言列表
AI 
