Laravel Where and OrWhere

Question

I am trying to figure out how to create the following query in eloquent:

SELECT * 
FROM  `pvp_battles` 
WHERE (player1_id = 2 || player2_id =2) && winner !=2

2 is the player id. This is what I did:

$profile->loses = PvpBattle::where('player1_id',$profile->id)
        ->orWhere('player2_id',$profile->id)
        ->where('winner','!=',$profile->id)->count();

Sadly it shows that the count is 49 while it's 25. What's wrong?

Answer 1

Here is the fix:

$profile->loses = PvpBattle::where(function($q) use($profile) {
  return $q
           ->where('player1_id', $profile->id)
           ->orWhere('player2_id', $profile->id);
})->where('winner', '!=', $profile->id)->count();

or:

$profile->loses = PvpBattle::where(DB::raw($profile->id.' IN (`player1_id`, `player2_id`)'))
                           ->where('winner', '!=', $profile->id)->count();