获取所有（）数据并按升序排序并选择

Question

i want to get all user data and sort by ascending order then select required columns

$drivers = Driver::all()
         ->select('id','first_name','last_name','phone_number','registration_id')
        ->get();

now i'm getting all the data

thank you

Answer 1

In this case, remove all() and add an orderBy():

    $drivers = Driver::select('id','first_name','last_name','phone_number','registration_id')
    ->orderBy('the-order-column', 'asc or desc')
    ->get();

The methods all() and get() do the same thing, except from that you can't modify the query using all() (like adding orderBy()).

Laravels documentation on orderBy(): https://laravel.com/docs/5.3/queries#ordering-grouping-limit-and-offset