Loop through an array of multiple values

Question

I have the following variable which holds an array :

$category = $request->get('catBox');

The variable has the following output :

array(2) { [0]=> string(7) "Zamalek" [1]=> string(4) "Ahly" }

How can I properly put the $category variable in the below query :

       $Tagids = DB::table('tags')
                    ->where('t_name', $category)                  
                    ->pluck('id');

So that after that I will loop through the result to store a row for each result :

foreach($Tagids as $tagid){

                      $tagIns = new tagpost();
                      $tagIns->tag_id = $tagid;
                       $tagIns->save();
                   }

Have you tried printing out the content of the $category is it really an array? Add this ` dd($category);` after you get it from the request and make sure that it returns array of ids. — nakov
– nakov, Commented Aug 8, 2019 at 17:42

dparoli · Accepted Answer · 2019-08-08 18:47:36Z

1

You can to use a whereIn() it accepts an array of values as second argument, i.e.:

$Tagids = DB::table('tags')
            ->whereIn('t_name', array_values($category))                  
            ->pluck('id');

Probably array_values() is redundant, you can try even without:

$Tagids = DB::table('tags')
            ->whereIn('t_name', $category)                  
            ->pluck('id');

answered Aug 8, 2019 at 18:47

dparoli

9,1911 gold badge34 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Loop through an array of multiple values

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