Laravel 6 Multiple orWhere with multiple parameters

Laravel 6 Multiple orWhere with multiple parameters

Today, We want to share with you Laravel 6 Multiple orWhere with multiple parameters.In this post we will show you Laravel eloquent multiple WHERE with OR AND OR and LIKE?, hear for laravel search query with multiple conditions we will give you demo and example for implement.In this post, we will learn about multiple where clause query using Laravel Eloquent with an example.

Laravel 6 Multiple orWhere with multiple parameters

There are the Following The simple About Laravel 6 Multiple orWhere with multiple parameters Full Information With Example and source code.

As I will cover this Post with live Working example to develop laravel collection multiple where, so the some major files and Directory structures for this example is following below.

  SQL create table primary key Autoincrement

Laravel Multiple Orwhere

AND-OR-AND + brackets with Eloquent

$q->where('status', 1);
$q->orWhere('is_deleted', 2);
$q->orWhere('is_active', 3);

instaeds of

$q->where('status', 1);
$q->orWhere(['is_deleted' => 2, 'is_active' => 3]);

Eloquent – multiple WHERE LIKE conditions

$keywords = ['Narendra Modi', 'rajkot', 'PM'];

$members = Member::where(function ($query) use ($keywords) {
    foreach ($keywords as $keyword) {
       $query->orWhere('keyword', 'like', $keyword);
    }
})->paginate(10);
dd($members);

orWhere with multiple conditions in Eloquent

$members = Member::live()
   ->where('member_name', 'like' , '%'.$qry.'%')
   ->orWhere(function($query) use($qry) {
        $query->where('desc','like','%'.$qry.'%')
              ->where('desc','!=',$qry) 
   })->get();
   dd($members);

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 where multiple values.
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.

Leave a Reply

avatar
  Subscribe  
Notify of