在asc命令Laravel中安排foreach循环

Question

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.

Answer 1

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!