Using a foreach variable in a Laravel view

Question

My MySQL table looks like this (the relevant part):

student_id (int) | engmins(int) | totalmins(int) | created_at (datetime)    
1                | 50           | 100            | 2017-12-15 00:00:00
1                | 20           | 45             | 2017-12-15 00:00:00

I have the following code:

$students = StudentDetails::with('student','studentschool','classactivity')
    ->where('class', 1)
    ->orderBy('studentgrade', 'DESC')
    ->get();

$calculatePercentage = array();

foreach ($students as $s) 
{
    $fetchEngClassPercents= DB::table('ClassActivity')
    ->select(DB::raw('round((sum(engmins) * 60) / (sum(totalmins) * 60) * 100) as percents'))
    ->where('created_at', '>=', Carbon::now()->subDays(30))
    ->where('student_id', '=', $s->student->id)->get();     
    foreach($fetchEngClassPercents as $f)
    {
        $calculatePercentage = $f->percents;
        var_dump($calculatePercentage); //Debug purposes
    }
}

var_dump($calculatePercentage);  //Debug purposes

$params = [
    'engClassPercentage' => $calculatePercentage,
    'studentInfo'        => $students,
];

return view('user.classes.engclass.index', $params);

var_dump INSIDE the loop executes string(2) "43" NULL
var_dump OUTSIDE the loop executes NULL

This is how it looks in the view:

<td>
    @foreach($engClassPercentage as $p)
        {{ $p->percents }}
    @endforeach
</td>

This doesn't work in the view, it simply shows nothing.

For some reason, $calculatePercentage remains null outside of the loop (upon previous attempt of dumping the var). When it's in the foreach loop, it executes the query.

The strange thing is that I declared the array ($calculatePercentage) outside of the loop are assigned it with the variable in the foreach loop.

I am quite lost at this point to be honest, and I'd be glad if I can get assistance.

try using it like this return view('user.classes.engclass.index')->with('engClassPercentage' , $calculatePercentage); — Gaurav Gupta
– Gaurav Gupta, Commented Dec 16, 2017 at 11:18
I have other variable that is passed through $resources, how would I do it then? — Michael Naidis
– Michael Naidis, Commented Dec 16, 2017 at 11:22
$params = [ 'engClassPercentage' => $calculatePercentage, 'studentInfo' => $students, ]; return view('user.classes.engclass.index')->with($params); — Gaurav Gupta
– Gaurav Gupta, Commented Dec 16, 2017 at 12:31

HiKangg · Accepted Answer · 2017-12-16 13:56:04Z

3

change $calculatePercentage = $f-percents; to like below. Then in foreach part change $p->percents to $p.

$calculatePercentage[] = $f->percents;

@foreach($engClassPercentage as $p)
   {{$p}}
@endforeach

edited Dec 16, 2017 at 13:56

answered Dec 16, 2017 at 11:50

HiKangg

2611 gold badge5 silver badges20 bronze badges

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

3 Comments

Michael Naidis Over a year ago

This worked. However, now the same calculation gets applied for all enteries (even if student_id is 2 and he has nothing, it shows the same percentage calculation for student_id) 1.

HiKangg Over a year ago

Could you explain more precisely?

HiKangg Over a year ago

Do you mean percentage results are same when student_id is 2 and 1, means nothing one and existing one, right?

Dave · Accepted Answer · 2017-12-16 11:27:31Z

2

$calculatePercentage is getting overwritten on each loop change it to an array key

$calculatePercentage[] = $f->percents;

Then in your foreach call the $params array

@foreach($params['engClassPercentage'] as $p)

answered Dec 16, 2017 at 11:27

Dave

9189 silver badges23 bronze badges

1 Comment

Michael Naidis Over a year ago

I still seem to be getting "Trying to get property of non-object" in the view while var_dump executes array(1) { [0]=> string(2) "67" }

oreopot · Accepted Answer · 2017-12-16 11:28:21Z

0

You aren't storing values that is getting calculated in foreach loop:

Hence the values doesn't persist as per your requirements.

Updated Code:

foreach ($students as $s) 
{
    $fetchEngClassPercents= DB::table('ClassActivity')
    ->select(DB::raw('round((sum(engmins) * 60) / (sum(totalmins) * 60) * 100) as percents'))
    ->where('created_at', '>=', Carbon::now()->subDays(30))
    ->where('student_id', '=', $s->student->id)->get();     
    foreach($fetchEngClassPercents as $f)
    {
        $calculatePercentage[] = $f->percents; // <-- This line is edited.
    }
}

answered Dec 16, 2017 at 11:28

oreopot

3,4592 gold badges23 silver badges31 bronze badges

Collectives™ on Stack Overflow

Using a foreach variable in a Laravel view

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related