Home >PHP Framework >Laravel >How to use laravel orWhere? (with code example)

How to use laravel orWhere? (with code example)

藏色散人forward: 2022-01-04 14:42:055065browse

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;);

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();

(2) SQL statement:

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

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();

(3) SQL Statement:

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

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();

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!

Statement：

This article is reproduced at:phpernote.com. If there is any infringement, please contact admin@php.cn delete

Previous article：What to do if laravel image upload failsNext article：What to do if laravel image upload fails

See more

How to use laravel orWhere? (with code example)

Related articles