Laravel whereIn OR whereIn

Question

I m making a products search by filters   My code   - gt where function  query  use  filter      if  empty  filter        foreach   filter as  key   gt   value                      f   explode       value                  query- gt  whereIn  products value    f                             Query   and  products value in  Bomann  PHILIPS  and products value in  red white      But I need   and  products value in  Bomann  PHILIPS  OR products value in  red white      Is there something similar in Laravel   orWhereIn

User · Answer

query   DB  table  dms stakeholder permissions     query- gt select DB  raw  group concat dms stakeholder permissions fid  as fid    dms stakeholder permissions rights     query- gt where  dms stakeholder permissions stakeholder id   4     query- gt orWhere function  subquery   use   stakeholderId                subquery- gt where  dms stakeholder permissions stakeholder id   stakeholderId                subquery- gt whereIn  dms stakeholder permissions rights  array  1   2   3                result    query- gt get     return  result       OUTPUT  input  stakeholderId   1    select group concat dms stakeholder permissions fid  as fid  dms stakeholder permissionss rights from dms stakeholder permissions where dms stakeholder permissions stakeholder id   4 or  dms stakeholder permissions stakeholder id   1 and dms stakeholder permissions rights in  1  2  3

User · Answer

You have a orWhereIn function in Laravel  It takes the same parameters as the whereIn function   It s not in the documentation but you can find it in the laravel API  http   laravel com api 4 1   That should give you this    query- gt  orWhereIn  products value    f

User · Answer

You could have searched just for whereIn function in the core to see that  Here you are  This must answer all your questions         Add a  where in  clause to the query         param  string   column     param  mixed    values     param  string   boolean     param  bool     not     return  Illuminate Database Query Builder static     public function whereIn  column   values   boolean    and    not   false         type    not    NotIn     In           If the value of the where in clause is actually a Closure  we will assume that        the developer is using a full sub-select for this  in  statement  and will        execute those Closures  then we can re-construct the entire sub-selects      if   values instanceof Closure                return  this- gt whereInSub  column   values   boolean   not               this- gt wheres     compact  type    column    values    boolean          this- gt bindings   array merge  this- gt bindings   values        return  this      Look that it has a third boolean param  Good luck

User · Answer

Yes  orWhereIn is a method that you can use   I m fairly sure it should give you the result you re looking for  however  if it doesn t you could simply use implode to create a string and then explode it  this is a guess at your array structure     values   implode      array map function  value        return trim  value            filters      query- gt whereIn  products value   explode      values

User · Answer

For example  if you have multiple whereIn OR whereIn conditions and you want to put brackets  do it like this    getrecord   DiamondMaster  where  is delete   0  - gt where  user id  Auth  user  - gt id   if  empty  request- gt stone id          postdata    request- gt stone id       certi id  trim  postdata            getrecord    getrecord- gt whereIn  id  explode       certi id                              - gt orWhereIn  Certi NO  explode       certi id            getrecord    getrecord- gt get

[php] Laravel whereIn OR whereIn

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to laravel-4

Examples related to query-builder