Laravel Query Builder Where OR whereIn array

Question

I am having some trouble in Laravel using the query builder to select users based on two where clauses. The first where clause would contain multiple where statements to select a user based on some conditions. If this fails in the OR part I would like to check simply if the user ID is in the array. Would be grateful for some advice on how I could achieve this. Thanks.

$rs = DB::table('tblUser')
        ->select('name')
        ->where(function($q) {
            $q->where(function($q){
              $q->where('fid', '=', $this->argument('fid'))
                ->where('type', '<', 10)
            })
            ->orWhereIn('id', $userIdSArray);
        })
        ->get();

I think there is a problem at ->orWhereIn. If I just try ->orWhere('id', '123'); this just runs fine. So there is something wrong on that part. — Otonel88
– Otonel88, Commented May 9, 2018 at 17:08
What's the result when you replace ->get() with ->toSql()? What's the content of $userIdSArray? — Jonas Staudenmeir
– Jonas Staudenmeir, Commented May 9, 2018 at 17:10
$userIdsArray = ['123', '456']; I don't get anything if i dd($rs) while using toSql() in the above — Otonel88
– Otonel88, Commented May 9, 2018 at 17:17

Md. Miraj Khan · Accepted Answer · 2018-05-09 17:23:16Z

0

$userIdSArray = [ '2', '4', '5' ];
$rs           = DB::table( 'Users' )
                  ->select( 'name' )
                  ->where( function ( $q ) use ( $userIdSArray ) {
                      $q->where( function ( $q ) {
                          $q->where( 'fid', '=', $this->argument( 'fid' ) )
                            ->where( 'type', '<', 10 );
                       })
                       ->orWhereIn( 'id', $userIdSArray );
                  })
                  ->get();

I think you need to pass $userIdSArray in Query builder . And You also forgot (;) after [->where( 'type', '<', 10 )]

answered May 9, 2018 at 17:23

Md. Miraj Khan

3773 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Laravel Query Builder Where OR whereIn array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related