blocks|key|84632|text|使用Logical+Grouping+(Laravel+7.x/4.2)。对于您的示例，应该是这样的：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|84633|Model::where(function+($query)+{
++++$query->where('a',+'=',+1)
++++++++++->orWhere('b',+'=',+1);
})->where(function+($query)+{
++++$query->where('c',+'=',+1)
++++++++++->orWhere('d',+'=',+1);
});|code-block|syntax|javascript|84634|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/master/queries#logical-grouping|1|https://laravel.com/docs/7.x/queries#parameter-grouping|2|https://laravel.com/docs/4.2/queries#advanced-wheres^0|2|G|0|S|3|1|W|3|2|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]|$A|Y|B|Z|1|10]|$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]|Q|$5|L|M|N|C|$O|R]]|S|$5|L|M|N|C|$O|T]]]]

Make use of <a href="https://laravel.com/docs/master/queries#logical-grouping" rel="nofollow noreferrer">Logical Grouping</a> (Laravel <a href="https://laravel.com/docs/7.x/queries#parameter-grouping" rel="nofollow noreferrer">7.x</a>/<a href="https://laravel.com/docs/4.2/queries#advanced-wheres" rel="nofollow noreferrer">4.2</a>). For your example, it'd be something like this:
<pre><code>Model::where(function ($query) {
 $query-&gt;where('a', '=', 1)
 -&gt;orWhere('b', '=', 1);
})-&gt;where(function ($query) {
 $query-&gt;where('c', '=', 1)
 -&gt;orWhere('d', '=', 1);
});
</code></pre>

blocks|key|84654|text|如果你想在Laravel+4中使用a，b，c，d的参数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84655|Model::where(function+($query)+use+($a,$b)+{
++++$query->where('a',+'=',+$a)
++++++++++->orWhere('b',+'=',+$b);
})
->where(function+($query)+use+($c,$d)+{
++++$query->where('c',+'=',+$c)
++++++++++->orWhere('d',+'=',+$d);
});|code-block|syntax|javascript|84656|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you want to use parameters for a,b,c,d in Laravel 4

<pre><code>Model::where(function ($query) use ($a,$b) {
 $query-&gt;where('a', '=', $a)
 -&gt;orWhere('b', '=', $b);
})
-&gt;where(function ($query) use ($c,$d) {
 $query-&gt;where('c', '=', $c)
 -&gt;orWhere('d', '=', $d);
});
</code></pre>

blocks|key|302142|text|如果你循环OR条件，你不需要第二个$查询->+where从其他帖子(实际上我不认为你一般需要，你可以在嵌套的where中使用orWhere，如果更容易)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302143|$attributes+=+['first'=>'a','second'=>'b'];

$query->where(function+($query)+use+($attributes)+
{
++++foreach+($attributes+as+$key=>value)
++++{
++++++++//you+can+use+orWhere+the+first+time,+doesn't+need+to+be+->where
++++++++$query->orWhere($key,$value);
++++}
});|code-block|syntax|javascript|302144|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Incase you're looping the OR conditions, you don't need the the second $query->where from the other posts (actually I don't think you need in general, you can just use orWhere in the nested where if easier)

<pre><code>$attributes = ['first'=&gt;'a','second'=&gt;'b'];

$query-&gt;where(function ($query) use ($attributes) 
{
 foreach ($attributes as $key=&gt;value)
 {
 //you can use orWhere the first time, doesn't need to be -&gt;where
 $query-&gt;orWhere($key,$value);
 }
});
</code></pre>

blocks|key|302170|text|您还可以使用查询作用域来使事情变得更整洁一些，这样您就可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302171|Invoice::where('account',+27)->notPaidAt($date)->get();|code-block|syntax|javascript|302172|然后在你的模型中|302173|public+function+scopeNotPaidAt($query,+$asAt)
{
++++$query+=+$query->where(function+($query)+use+($asAt)+{+
++++++++$query->where('paid',+'=',+'0000-00-00')->orWhere('paid',+'>=',+$asAt);+
++++});
++++return+$query;++++
}|302174|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can also use query scopes to make things a bit tidier, so you can do something like:

<pre><code>Invoice::where('account', 27)-&gt;notPaidAt($date)-&gt;get();
</code></pre>

Then in your model 

<pre><code>public function scopeNotPaidAt($query, $asAt)
{
 $query = $query-&gt;where(function ($query) use ($asAt) { 
 $query-&gt;where('paid', '=', '0000-00-00')-&gt;orWhere('paid', '&gt;=', $asAt); 
 });
 return $query; 
}
</code></pre>

blocks|key|302195|text|您还可以查询第一个或条件，然后再应用另一个或条件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302196|$model+=+Model::where('a',1)->orWhere('b',1);|code-block|syntax|javascript|302197|现在对该$model变量应用另一个条件|offset|length|style|CODE|302198|$model1+=+$model->where('c',1)->orWhere('d',1)->get();|302199|entityMap^0|0|0|4|6|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can also query the first or condition and later you can apply another or condition

<pre><code>$model = Model::where('a',1)-&gt;orWhere('b',1);
</code></pre>

now apply another condition on that <code>$model</code> variable

<pre><code>$model1 = $model-&gt;where('c',1)-&gt;orWhere('d',1)-&gt;get();
</code></pre>

blocks|key|84783|text|如果您想在laravel+4中使用括号，并且不要忘记返回|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84784|在Larave4中(至少)，您需要在括号中使用$a，$b，如示例中所示|84785|$a+=+1;
$b+=+1;
$c+=+1;
$d+=+1;
Model::where(function+($query)+use+($a,+$b)+{
++++return+$query->where('a',+'=',+$a)
++++++++++->orWhere('b',+'=',+$b);
})->where(function+($query)+use+($c,+$d)+{
++++return+$query->where('c',+'=',+$c)
++++++++++->orWhere('d',+'=',+$d);
});|code-block|syntax|javascript|84786|这是我的结果：|84787|📷|atomic|offset|length|84788|​|84789|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9dc3d7c26120d63909fe8e4275b495bd.jpeg|imageAlt^0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|14|8|@]|9|@$N|15|O|16|1|17]]|A|$]]|$1|P|3|Q|5|6|7|18|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]]]

if you want to use parentheses in laravel 4 and don't forget return 
In Laravel 4 (at least) you need to use $a, $b in parentheses as in the example

<pre class="lang-php prettyprint-override"><code>$a = 1;
$b = 1;
$c = 1;
$d = 1;
Model::where(function ($query) use ($a, $b) {
 return $query-&gt;where('a', '=', $a)
 -&gt;orWhere('b', '=', $b);
})-&gt;where(function ($query) use ($c, $d) {
 return $query-&gt;where('c', '=', $c)
 -&gt;orWhere('d', '=', $d);
});
</code></pre>

This is my result:
<a href="https://i.stack.imgur.com/LAvKK.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/LAvKK.jpg" alt="enter image description here"></a>

blocks|key|84796|text|YourModel::where(function+($query)+use($a,$b)+{
++++$query->where('a','=',$a)
++++++++++->orWhere('b','=',+$b);
})->where(function+($query)+use+($c,$d)+{
++++$query->where('c','=',$c)
++++++++++->orWhere('d','=',$d);
});|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|84797|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>YourModel::where(function ($query) use($a,$b) {
 $query-&gt;where('a','=',$a)
 -&gt;orWhere('b','=', $b);
})-&gt;where(function ($query) use ($c,$d) {
 $query-&gt;where('c','=',$c)
 -&gt;orWhere('d','=',$d);
});
</code></pre>

blocks|key|84888|text|另一种不使用Modal的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84889|数据库:+stocks列:id、name、company_name、exchange_name、status|84890|📷|atomic|offset|length|84891|​|84892|++$name+='aa'
++$stocks+=+DB::table('stocks')
++++++++++++->select('name',+'company_name',+'exchange_name')
++++++++++++->where(function($query)+use+($name)+{
++++++++++++++++$query->where('name',+'like',+'%25'+.+$name+.+'%25')
++++++++++++++++->orWhere('company_name',+'like',+'%25'+.+$name+.+'%25');
++++++++++++})
++++++++++++->Where('status',+'=',+1)
++++++++++++->limit(20)
++++++++++++->get();|code-block|syntax|javascript|84893|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/94feb324a35c8d82e2e0146c0c8be76c.png|imageAlt^0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@$G|11|H|12|1|13]]|A|$]]|$1|I|3|J|5|6|7|14|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|15|8|@]|9|@]|A|$N|O]]|$1|P|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W|X|-4]]]]

Another way without using Modal 

Database: stocks 
Columns:id,name,company_name,exchange_name,status
<a href="https://i.stack.imgur.com/e9UXS.png" rel="noreferrer"><img src="https://i.stack.imgur.com/e9UXS.png" alt="enter image description here"></a>

<pre><code> $name ='aa'
 $stocks = DB::table('stocks')
 -&gt;select('name', 'company_name', 'exchange_name')
 -&gt;where(function($query) use ($name) {
 $query-&gt;where('name', 'like', '%' . $name . '%')
 -&gt;orWhere('company_name', 'like', '%' . $name . '%');
 })
 -&gt;Where('status', '=', 1)
 -&gt;limit(20)
 -&gt;get();
</code></pre>

blocks|key|302383|text|对于能言善辩的查询生成器，以下查询将不起作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302384|MODELNAME::where('a',+1)->orWhere('b',+1)->where('c',+1)->orWhere('d',+1);|code-block|syntax|javascript|302385|但是你可以使用下面的代码：|302386|MODELNAME::where(function($a)+{
++++$a->where('a',+1)->orWhere('b',+1);
})->where(function($a)+{
++++$a->where('c',+1)->orWhere('d',+1);
});|302387|您可以使用第二个查询，它将完美地工作。|302388|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

For eloquent query builder the following query will not work:
<pre><code>MODELNAME::where('a', 1)-&gt;orWhere('b', 1)-&gt;where('c', 1)-&gt;orWhere('d', 1);
</code></pre>
But you can use this code:
<pre><code>MODELNAME::where(function($a) {
 $a-&gt;where('a', 1)-&gt;orWhere('b', 1);
})-&gt;where(function($a) {
 $a-&gt;where('c', 1)-&gt;orWhere('d', 1);
});
</code></pre>
You can use the second query and it will work perfectly.

blocks|key|84938|text|这对我很管用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84939|$business+=+Model::where('model_id',+$model_id1)->orWhere('model_id',+$model_id2)->first();|code-block|syntax|javascript|84940|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This works for me
<pre><code>$business = Model::where('model_id', $model_id1)-&gt;orWhere('model_id', $model_id2)-&gt;first();
</code></pre>

blocks|key|302414|text|您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302415|Model::where('table_column',+'value')->orWhere('table_column',+'value')->get()|code-block|syntax|javascript|302416|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use:
<pre><code>Model::where('table_column', 'value')-&gt;orWhere('table_column', 'value')-&gt;get()
</code></pre>

How do I say <code>WHERE (a = 1 OR b =1 ) AND (c = 1 OR d = 1)</code>

For more complicated queries am I supposed to use raw SQL?

Laravel 4 Eloquent Query Using WHERE with OR AND OR?

数据库

我怎么说WHERE (a = 1 OR b =1 ) AND (c = 1 OR d = 1)？对于更复杂的查询，我是否应该使用原始SQL？

问Laravel 4雄辩的查询使用WHERE with OR和OR？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel 4雄辩的查询使用WHERE with OR和OR？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel 4雄辩的查询使用WHERE with OR和OR？
EN