PHP & Eloquent match array with array

Question

I have an issue where I'm trying to match 2 arrays (Check if $_POST array has values that are contained in the database array)

Array : ['79','80'] (this is stored inside my database)
Array : ['78','79','80'] (this is a POST from checkbox's)

Here's a snippet of my code

$filter = Course::GetAllCourses()->where('for_sites',2)->orderBy("set_date","DESC");
// I've tried
if ($request->getParam('level')) {

    $filter->where('groups',$request->getParam('level'));

}

// Also tried this resukt: nothing shows (no errors ) this works for a single value only though
foreach ($request->getParam('level') as $levels) {

    if ($request->getParam('level')) {

        $filter->where('groups','LIKE','%' . $levels . '%');

    }
}

// Also tried this shows everything doesn't matter what kind of 'level ' I've posted 

foreach ($request->getParam('level') as $levels) {

    if ($request->getParam('level')) {

        $filter->orWhere('groups','LIKE','%' . $levels . '%');

    }
}

$db_course = $filter->distinct()->get();

So the end game is:

If i $_POST values of array ['78','79','80'] i want to get results that have ['78','79'] or all three values or even just 1 blue e.g. ['78'] is this even possible?

Can you post the result of dd($request->getParam('level') and what exactly is in the groups column of your database? A text string? — Peter
– Peter, Commented Dec 12, 2018 at 15:44
Take a look at whereJsonContains(): laravel.com/docs/queries#json-where-clauses In your case, you would need multiple orWhereJsonContains() clauses. — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Dec 12, 2018 at 16:13

H45H · Accepted Answer · 2018-12-12 13:17:00Z

-1

i think you are searching for WhereIn

Something like :

$users = DB::table('users')
            ->whereIn('id', [1, 2, 3])
            ->get();

Reference

answered Dec 12, 2018 at 13:17

H45H

1,01710 silver badges28 bronze badges

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

2 Comments

Frosty Over a year ago

This works if the Database column is a single value e.g. "1" but my database column contains an array ['1','2','3']

H45H Over a year ago

then probably you might looking for this

Collectives™ on Stack Overflow

PHP & Eloquent match array with array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related