Synthaxe Where!!

Hello,

I have a little problem with my where : https://openweb.vip/whatsapp-web/ https://19216801.onl/ https://routerlogin.uno/

that work correctly :

     $event = Evenement::where([
        ['categorie_user', $user -> categorie_user ],
        ])->whereNotIn('id', $participantselect->pluck('evenement_id')) ->get();

But that no:

 $event = Evenement::where([
    ['categorie_user', $user -> categorie_user ],
    ['categorie_user',"Public" ],
    ])->whereNotIn('id', $participantselect->pluck('evenement_id')) ->get();

what is the error ?

Sti3bas

6 years ago

Level 53

@johnwalker1 I guess you want categorie_user to be $user->categorie_user OR Public right? If so:

$event = Evenement::where(function($query) use ($user) {
   $query->where('categorie_user', $user->categorie_user)
      ->orWhere('categorie_user', 'Public');
})->whereNotIn('id', $participantselect->pluck('evenement_id'))->get();

Please or to participate in this conversation.