laravel query writes multiple conditions

In Laravel, we often need to query based on multiple conditions. These conditions may include field values, time ranges, relationships, and more. In this article, we will discuss how to use Laravel Eloquent for multi-condition query.

Basic query When querying in Laravel, we can use basic query methods, such as where , orWhere , whereIn , whereNotIn , etc. These query methods can be chained to combine multiple query conditions. For example, we can use the following code to query the articles table for articles with ID 1 and status 1:

$article = DB::table('articles') ->where('id', 1) ->where('status', 1) ->first(); In the above example, we use the where method to specify two conditions. The first method is used to obtain a single record. If the query result is empty, null will be returned.

Advanced Query The Eloquent model in Laravel also provides many advanced query methods to handle more complex queries. The following are some commonly used advanced query methods:

2.1 whereBetween method

whereBetween method allows us to query records within a specified range. For example, we can use the following code to query articles created between 2019 and 2020:

$articles = DB::table('articles') ->whereBetween('created_at', ['2019-01-01', '2020-12-31']) ->get(); 2.2 orWhere method

orWhere The method allows us to query if any one of multiple conditions is met. For example, we can use the following code to query for articles with status 1 or 2:

$articles = DB::table('articles') ->where('category_id', 1) ->orWhere('status', 1) ->get(); 2.3 whereHas method

whereHas method allows us to query Records in the associated model that meet the filter criteria. For example, we can use the following code to query all articles with comments:

$articles = DB::table('articles') ->whereHas('comments') ->get(); In the above example, we used the whereHas method to query the associated model comments Whether there are records and return article records that meet the conditions. If we want to further filter comments that meet certain conditions, we can pass in additional filtering conditions in the whereHas method, for example:

$articles = DB::table('articles') ->whereHas('comments', function($query) { $query->where('status', 1); }) ->get(); In the above example, we have comments The model passes in the query conditions, only queries the comments with a status of 1, and returns the article records associated with them.

2.4 whereIn and whereNotIn methods

whereIn and whereNotIn allow us to follow the specified fields Filter results by value range. For example, we can use the following code to query records with article status 1, 2, and 3:

$articles = DB::table('articles') ->whereIn('status', [1, 2, 3]) ->get(); Mixed use In actual applications, we often need to use a combination of The above query method is used to complete multi-condition query. For example, we can use the following code to query articles with category ID 1 and status 1, and the number of comments is greater than 5:

$articles = DB::table('articles') ->where('category_id', 1) ->where('status', 1) ->whereHas('comments', function($query) { $query->where('status', 1); }, '>', 5) ->get(); In this example, we used the whereHas method To query comments that meet certain conditions, and use the > symbol to query whether the number of comments is greater than 5.

Conclusion

In Laravel, we can use multiple methods to perform multi-condition queries. Using the advanced query method of the Eloquent model can more easily complete complex query operations. Mastering the skills of multi-condition query can help us complete tasks more efficiently during development.

laravel query writes multiple conditions

Related articles