如何在Laravel中按字母顺序对记录进行排序

Question

How to sort records in alphabetical order in laravel?

public function index()
{
    $comproducts = Comproduct::paginate(3);

    $items = Item::orderBy('name')->all();        

    return view('computer', compact(['comproducts', 'items']));

}

This is not working correctly. This shows

Call to undefined method Illuminate\Database\Query\Builder::all()

this error. How can i fix this?

Answer 1

I use get() instead , you can't modify query with method all() and also it is static function

  $items = Item::orderBy('name')->get();