How to use laravel orWhere? (with code example)-Laravel-php.cn

How to use laravel orWhere? (with code example)

藏色散人

Release： 2022-01-18 10:18:14

forward

5060 people have browsed it

The following tutorial column from Laravel will explain how to use laravel orWhere. I hope it will be helpful to everyone!

The where condition query under the laravel framework is very simple, so I won’t write it here. Here I mainly record the splicing of the orWhere multi-condition or query statement that is not commonly used. The example is as follows:

(1 ) SQL statement:

select `id` from `user` where (`email` = &#39;admin@phpernote.com&#39; and `password` = &#39;123456&#39;) or (`mobile` = &#39;13681127231&#39; and `password` = &#39;123456&#39;);

Copy after login

laravel model statement:

User::select([&#39;id&#39;])
    ->where(function ($query) use ($userName, $password) {
        $query->where(&#39;password&#39;, &#39;=&#39;, &#39;123456&#39;)->where(&#39;email&#39;, &#39;=&#39;, &#39;admin@phpernote.com&#39;);
    })
    ->orWhere(function ($query) use ($userName, $password) {
        $query->where(&#39;password&#39;, &#39;=&#39;, &#39;123456&#39;)->where(&#39;mobile&#39;, &#39;=&#39;, &#39;13681127231&#39;);
    })
    ->first();

Copy after login

(2) SQL statement:

select count(*) from `user` where `type` = 1 and `valid_type` = 2 and (`valid_end` < 1560738570 or `valid_begin` > 1560738570);

Copy after login

laravel model statement:

$model = User::where(&#39;type&#39;, 1)->where(&#39;valid_type&#39;, &#39;=&#39;, 2)->where(function ($query) {
    $query->where(&#39;valid_end&#39;, &#39;<&#39;, 1560738570)->orWhere(function ($query) {
        $query->where(&#39;valid_begin&#39;, &#39;>&#39;, 1560738570);
    });
})->first();

Copy after login

(3) SQL Statement:

select count(*) from `user` where `valid_type` = 2 or (`valid_type` = 3 and (`valid_end` < 1560738570 or `valid_begin` > 1560738570));

Copy after login

laravel model Statement:

$model = User::where(function ($query) {
    $query->where(&#39;valid_type&#39;, 2);
})->orWhere(function ($query) {
    $query->where(&#39;valid_type&#39;, &#39;=&#39;, 3)->where(function ($query) {
        $query->where(&#39;valid_end&#39;, &#39;<&#39;, 1560738570)->orWhere(function ($query) {
            $query->where(&#39;valid_begin&#39;, &#39;>&#39;, 1560738570);
        });
    });
})->first();

Copy after login

Related recommendations: The latest five Laravel video tutorials

The above is the detailed content of How to use laravel orWhere? (with code example). For more information, please follow other related articles on the PHP Chinese website!