Is it the correct way to use orWhere ?

https://laravel.com/docs/9.x/queries#or-where-clauses

Level 73

When mixing AND and OR you might need to group them together to get the desired result.

See this example from the docs.

$users = DB::table('users')
            ->where('votes', '>', 100)
            ->orWhere(function($query) {
                $query->where('name', 'Abigail')
                      ->where('votes', '>', 50);
            })
            ->get();

1 like

Level 5

@Tray2 Thanks. Yes I read that but what will be the code in my case ?

Tray2

Level 73

@FounderStartup These two needs to be grouped

where('dealrealtor_id',$user->id)->orWhere('user_id', $user->id)

1 like

Level 5

@Tray2 Thanks again. But how ? How to group with OR ?

This is my code :

$totaldealsinprogress = Listings::where('dealrealtor_id',$user->id)->orWhere('user_id', $user->id)->where('status',1)->where('dealstatus',2)->count();

frankielee

Level 29

You can find the example here => https://laravel.com/docs/9.x/queries#logical-grouping

1 like

Level 5

@frankielee Yes but my code is not working. The example is different than what I need :) Can anybody help ?

frankielee

Best Answer

Level 29

Have you tried to group your code like the following?


 Listings::where(function ($query)  use ($user){
	$query->where('dealrealtor_id',$user->id)->orWhere('user_id', $user->id);
})->where('status',1)->where('dealstatus',2)->count();

1 like

Level 5

@frankielee $user-> is showing error.

ErrorException Undefined variable $user

frankielee

Level 29

I have updated my code, please check.

Level 5

@frankielee Its perfect. Thanks a ton. I need to learn a bit more about logical grouping :)

Level 75

Yes but my code is not working. The example is different than what I need :) Can anybody help ?

Stop asking for a code! The example in the documentation is pretty clear.

People please stop doing things instead of OP!

Level 5

@MichalOravec Here you go again . A negative person can never stop doing negative comments. If everything is already there in the documentation then why we need this platform ?

Kindly stay away as I advised and refrain from posting your negative comments. Don't spoil this excellent platform.

Level 75

@FounderStartup What is the difference between

$users = DB::table('users')
           ->where('name', '=', 'John')
           ->where(function ($query) {
               $query->where('votes', '>', 100)
                     ->orWhere('title', '=', 'Admin');
           })
           ->get();

and

 Listings::where(function ($query)  use ($user){
	$query->where('dealrealtor_id',$user->id)->orWhere('user_id', $user->id);
})->where('status',1)->where('dealstatus',2)->count();

in logical grouping? Nothing, it's the same.

It was really difficult? Unbelievable... Leave this forum if you have no effort to do something yourself.

1 like

Level 5

@MichalOravec I am already doing. But negative people like you should not be allowed on this platform. Stop ridiculing people ( I have seen many of your messages on this platform where you have done this again and again with many developers ). Don't lose your respect like this.

Simply ignore the post if you have these sudden rush of negativity. Keep your negativity to yourself . It will be better for you. A matured software engineer will never comment the way you are doing. Grow up now.

Level 5

@MichalOravec I repeat again. Why we need a platform like this when everything is there in the documentation ??? People like you will never understand.

Level 75

Stop ridiculing people

Where exactly?

Level 5

@MichalOravec There are so many post. You even asked somebody to stop coding :) Anyway ! It's your life . But I again suggest that stop ridiculing people. You will get respect only when you respect people. Simply ignore the post which you don't like. Thanks.

Level 75

@FounderStartup Simply don't ask for a code.

Laracasts is not free coding service.

1 like