Today, We want to share with you Laravel 6 Multiple Where Eloquent Query.In this post we will show you laravel 6 search query with multiple conditions, hear for How to Create Multiple Where Clause Query Using Laravel 6 Eloquent? we will give you demo and example for implement.In this post, we will learn about Eloquent Subquery Enhancements in Laravel 6.0 with an example.
Laravel 6 Multiple Where Eloquent Query
There are the Following The simple About laravel 6 multiple where conditions Full Information With Example and source code.
As I will cover this Post with live Working example to develop find with where condition in laravel, so the and condition in where clause in laravel is used for this example is following below.
Example : 1 where and whereDate
Movie::select('id','slogen')
->where('movie_applicability','=','SPECIFIC_MOVIES')
->where('movi_id','=', $movi_id)
->where('is_upcomming','=', 1)
->whereDate('new_updated_song','>=', NOW())
->get();
Example : 2 Laravel 6 Join with Multiple Where conditions
Tamilrokers::join('movie_list_hindi','movie_list_hindi.song_id','=','movie_lists.song_id')
->select('movie_lists.*','movie_list_hindi.*','movie_list_hindi.id as mib_id','movie_lists.item_group_id')
->where('movie_lists.movi_id','=',$movi_id)
->where('movie_lists.is_upcomming','=',0)
->where('movie_lists.song_id','=',$song_id)
->where('movie_list_hindi.is_upcomming','=',0);
Example : 3 where, whereRaw, groupBy, orderBy and DB::raw()
Tamilrokers::select(DB::raw("GROUP_CONCAT(DISTINCT song_id) as movies_list"), 'movi_id')
->where('is_upcomming', 1)
->where('new_updated_song','=', 1)
->whereRaw('updated_at < DATE_SUB(NOW(), INTERVAL 30 MINUTE)')
->groupBy('movi_id')
->orderBy('updated_at','ASC')
->limit(1000);
Example : 4 where, whereIn, whereRaw Example
Tamilrokers::where('is_upcomming', 1)
->where('new_updated_song','=', 1)
->whereIn('song_id',$movie_list_arr)
->whereRaw('updated_at < DATE_SUB(NOW(), INTERVAL 30 MINUTE)')
->where('movi_id','=', $movi_id)
->get();
Example : 5 Laravel 6 WhereNotIn Query Example
$movie_ids_web = '71,27,34';
$movie_ids = explode(',', $movie_ids_web);
$movies = Movie::select("*")
->whereNotIn('id', $movie_ids)
->get();
dd($movies);
Laravel 6 AND-OR-AND + brackets with Eloquent
laravel 6 nested where
$q->where(function ($query) {
$query->where('movie', 'Hindi')
->where('price', '>=', 180);
})->orWhere(function($query) {
$query->where('movie', 'English')
->where('price', '>=', 250);
})
Web Programming Tutorials Example with Demo
Read :
Summary
You can also read about AngularJS, ASP.NET, VueJs, PHP.
I hope you get an idea about laravel 6 query with if condition.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.