Laravel eloquent give wrong result

Question

I have this code:

public function inbox()
{
    $id = Auth::user()->id;
    $bids = Bid::where('user_id',$id)
               ->where('status','0')
               ->orWhere('status','4')
               ->latest()->get();
               dd($bids);
    return view('rooms.inbox', compact('bids'));

}

and this is my database:

But when I run it I get this result:

my Auth user id is 8 but I get wrong results? Why?

ALso when i try ; $bids = Auth::user()->bids()->get(); then I get right results///

What is problem?

Imtiaz Pabel · Accepted Answer · 2016-05-31 13:35:05Z

2

you are getting this unexpected error because of orWhere,you can do like this way

$bids = Bid::where('user_id',$id)
                       ->where(function ($query) {
                         $query->where('status','0')
                         ->orWhere('status','4');
                       })
                       ->latest()->get();

answered May 31, 2016 at 13:35

Imtiaz Pabel

5,4451 gold badge21 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nisam · Accepted Answer · 2016-05-31 13:42:29Z

0

You need to use Advanced Where Clauses

Your Query should like,

$bids = Bid::where('user_id',$id)
            ->where(function ($query) {
                $query->where('status', '0')
                    ->orWhere('status', '4');
            })->latest()->get();

answered May 31, 2016 at 13:42

Nisam

2,30521 silver badges33 bronze badges

Collectives™ on Stack Overflow

Laravel eloquent give wrong result

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related