Do Array of items check on sql query using whereor and wherein Laravel 5.4

Question

I have a mysql query in which I need make a check for array of values in 2 columns using Or. Inshort I have one array which needs to be checked on 2 columns using Or condition.

using sql

SELECT *
FROM table_name
WHERE col_1 IN (1, 8, 3) 
OR
WHERE col_2 IN (1, 8, 3)

using laravel

        $mu = DB::table('users')
        ->join('table_a', 'users.id', '=', 'table_a.user_id')
        ->select('table_a.user_id')
        //This are all AND
        ->where('table_b.search_status','available')
        ->where('table_b.role','<>',2)

        //This 2 parts needs to be in OR clause
        ->whereIn('table_b.lang',$seeks)
        ->whereIn('table_b.lang_2',$seeks)

        //This is AND too
        ->whereIn('table_a.language_id',$lang)
        ->get()->pluck('user_id')->toArray();

I want to do something like:

         ->where(function($q) 
        {
            $q->whereIn('table_b.lang',$seeks)
              ->orWhere(whereIn('table_b.lang_2',$seeks));
        })

But gives error: undefined $seeks.

Sandeesh · Accepted Answer · 2017-06-03 05:05:16Z

1

Use a closure where condition to wrap them.

$mu = DB::table('users')
    ->join('table_a', 'users.id', '=', 'table_a.user_id')
    ->select('table_a.user_id')
    ->where('table_b.search_status', 'available')
    ->where('table_b.role','<>', 2)
    ->where(function ($query) use ($seeks) {
        $query->whereIn('table_b.lang', $seeks)
            ->orWhereIn('table_b.lang_2', $seeks);
    })
    ->whereIn('table_a.language_id', $lang)
    ->get()->pluck('user_id')->toArray();

edited Jun 3, 2017 at 5:05

answered Jun 3, 2017 at 4:55

Sandeesh

12k3 gold badges35 silver badges42 bronze badges

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

Comments

Pawan Dongol · Accepted Answer · 2017-06-03 00:06:42Z

0

Just replace this:-

  ->where(function($q) use ($seeks)
    {
        $q->whereIn('table_b.lang',$seeks)
          ->orWhere(whereIn('table_b.lang_2',$seeks));
    });

Into

 ->where(function($q) use ($seeks)
    {
        $q->whereIn('table_b.lang',$seeks)
          ->orWhere(whereIn('table_b.lang_2',$seeks));
    });

answered Jun 3, 2017 at 0:06

Pawan Dongol

1,1583 gold badges16 silver badges33 bronze badges

Collectives™ on Stack Overflow

Do Array of items check on sql query using whereor and wherein Laravel 5.4

using sql

using laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

using sql

using laravel

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related