Get all elements of array in query laravel

Question

I am trying to loop in an array but when it comes to the query it gets only the first element, so a little help would be very important.

 $data = Offers::whereIn('id_business', $business_id_array)
                    ->where([
                        'visible' => 'yes',
                        'delete' => 'no'
                    ])
                    ->where('end_date', '>=', date('Y-m-d h:m:i'))
                    ->orderBy('id', 'desc')
                    ->get();

                $data=array($data);

                foreach($data as $key => $item) {
                    $offers = DB::select('the data i need to get WHERE o.`id` = ' . $item[$key]['id']);


                }

and this is my problem in here, It gets only the id of the first element

o.`id` = ' . $item[$key]['id']

Try $item->id in your loop.

Amit Gupta
– Amit Gupta

2017-06-09 14:13:26 +00:00
Commented Jun 9, 2017 at 14:13 — Amit Gupta
– Amit Gupta, Commented Jun 9, 2017 at 14:13
@AmitGupta no man, it doesnt work

User45648
– User45648

2017-06-09 14:21:31 +00:00
Commented Jun 9, 2017 at 14:21 — User45648
– User45648, Commented Jun 9, 2017 at 14:21

Phong Tran · Accepted Answer · 2017-06-09 14:49:18Z

1

because you have return the view in side the foreach loop, so it only loop through the first item and return. What you can do with this case is

$data = Offers::whereIn('id_business', $business_id_array)...->get()->toArray();
$offers = array_map(function($item){
     $offer = DB::select('the data i need to get WHERE o.`id` = ?', [$item->id]);  
     return $offer;
},$data);
return view(....,['offers' =>$offers]);

answered Jun 9, 2017 at 14:49

Phong Tran

963 bronze badges

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

Comments

Chris G · Accepted Answer · 2017-06-09 14:10:40Z

0

First, you do not need to cast the $data to an array - it will get returned as a collection, which you can iterate through like an array. So you'll be able to use something like this

$offers = Offers::whereIn('id_business', $business_id_array)...->get();

foreach ($offers as $offer) {
    $moreData = DB::select('the data i need to get WHERE o.`id` = ?', [$offer->id]);
}

answered Jun 9, 2017 at 14:10

Chris G

7,0502 gold badges21 silver badges20 bronze badges

11 Comments

User45648 Over a year ago

it still get only one id, only the first one, while i get 4 elements as array

ayip Over a year ago

use foreach ($offers->items as $offer) instead

User45648 Over a year ago

@ayip you mean foreach ($offers as $items=>$offer)

ayip Over a year ago

no, use either foreach ($offers->items as $offer) or if it gives any errors, use foreach ($offers->getItems() as $offer)

Phong Tran Over a year ago

@User154584 do you do anything with $moreData inside the loop beside running the query?

|

Mick · Accepted Answer · 2017-06-09 14:21:42Z

0

This looks like you are using the id from one table, to get the associated data from another table.

Should there not be a relationship in place, between the two tables?

The answer from @Chris G looks correct, maybe dd($offers) to be certain what is in there.

Mick

answered Jun 9, 2017 at 14:21

Mick

1,6015 gold badges26 silver badges45 bronze badges

2 Comments

User45648 Over a year ago

it get an array when like this : Collection {#256 ▼ #items: array:4 [▼ 0 => Offers {#255 ▶} 1 => Offers {#254 ▶} 2 => Offers {#253 ▶} 3 => Offers {#252 ▶} ] }

User45648 Over a year ago

and inside each of this arrays I need to get the ID

Collectives™ on Stack Overflow

Get all elements of array in query laravel

3 Answers 3

Comments

11 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

11 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related