Nested Loop in Eloquent in Laravel

Question

I am having trouble with my code. I have two tables Stocks and StockLists however, I want to get all the related stock in the stocks list based on the stock code. But the result is repeated in each stocks.... Here is the link of the image https://www.screencast.com/t/rHdT2gigh

public function index()
{
    $stocks = Stock::all();
     foreach ($stocks as $stock) {
        $stockInfos = DB::table('stocksList')
        ->where('stockCode', $stock->stockCode)
        ->take(3)
        ->get();
     }
     return view('welcome', compact('stocks', 'stockInfos'));
}

Here is my blade.php

@forelse($stocks as $stock)
                    <tr align="left">
                        <th scope="row">{{ $stock->stockCode }}</th>
                        <td><strong>{{ $stock->stockName }}</strong></td>
                        <td><strong>
                            @forelse($stockInfos as $stockInfo)
                            {{ $stockInfo->stockDate }} : {{ $stockInfo->stockPrice }}
                            <br>
                            @empty
                            <em>No Data</em>
                            @endforelse                            
                        </strong></td>    
                    </tr>
                    @empty
                    @endforelse

@Nikita stock table has only stock code, while the stocklist has the list of prices every day.. link — EasyWay
– EasyWay, Commented Sep 6, 2017 at 10:34

aaron0207 · Accepted Answer · 2017-09-06 10:41:32Z

1

You are overwritting the $stockInfos variable try with

public function index()
{
    $stocks = Stock::all();
    $stockInfos = [];
     foreach ($stocks as $stock) {
        array_push($stockInfos,DB::table('stocksList')
        ->where('stockCode', $stock->stockCode)
        ->take(3)
        ->get());
     }
     return view('welcome', compact('stocks'))->with('stockInfos',collect($stockInfos));
}

And in your view :

@forelse($stocks as $stock)
      <tr align="left">
          <th scope="row">{{ $stock->stockCode }}</th>
          <td><strong>{{ $stock->stockName }}</strong></td>
          <td><strong>
                            @forelse($stockInfos->where('stockCode',$stock->stockCode) as $stockInfo)
                            {{ $stockInfo->stockDate }} : {{ $stockInfo->stockPrice }}
                            <br>
                            @empty
                            <em>No Data</em>
                            @endforelse                            
                        </strong></td>    
                    </tr>
                    @empty
                    @endforelse

edited Sep 6, 2017 at 10:41

answered Sep 6, 2017 at 10:31

aaron0207

2,3531 gold badge20 silver badges25 bronze badges

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

3 Comments

EasyWay Over a year ago

Thank you but I get an error "Call to a member function where() on array"

EasyWay Over a year ago

I tried your updated code it works but it shows no data :(

aaron0207 Over a year ago

do dd($stocks,$stockInfos right before the return in your controller and look for the data there, maybe the problem is in the query

Nikita · Accepted Answer · 2017-09-06 10:36:58Z

0

Try this :

$stockInfos = DB::table('Stock')
             ->join('stocksList','stocksList.stockCode','=','Stock.stockCode')
             ->get();

answered Sep 6, 2017 at 10:36

Nikita

4372 silver badges12 bronze badges

Collectives™ on Stack Overflow

Nested Loop in Eloquent in Laravel

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related