How do I arrange a foreach loop in ascending order with Laravel? Here's my current code:
<h2 class="title">Top Performing Schools</h2>
@foreach($sch as $sch)
<div class="sch">
<div class="sch-content">
<a href="{{$sch->url}}">
<img style="width:60px;vertical-align: middle;" src="{{asset('images/'.$sch->logo)}}">
{{$sch->name}}
</a>
</div>
</div>
@endforeach
My guess is that $result = $result->orderBy('ranking_philippines', 'asc');
has to be put somewhere. ranking_philippines
is the database field that contains the ranking data that I want the items to be sorted by.
Ok Phil, we have to do some wild guessing here. Let's presume your table is called schools
and the model School
.
The controller, let's call it SchoolController
should look like this:
public function getRanking() {
$scores = School::orderBy('ranking_philippines', 'asc')->get();
return view('schools.ranking', compact('scores'));
}
Then in resources/views/schools/ranking.blade.php
you have to get something like this:
<h2 class="title">Top Performing Schools</h2>
@foreach($scores as $score)
<div class="sch">
<div class="sch-content">
<a href="{{$score->url}}">
<img style="width:60px;vertical-align: middle;" src="{{asset('/images/'.$score->logo)}}">
{{$score->name}}
</a>
</div>
</div>
@endforeach
I hope that gives you some help. You have to help us too Phil by being more specific. No offense. I understand. Good luck with your project!