need to sort prodcut by price ASC and DESC

Posted 1 year ago by R0.IT

I need to sort prodcut by price ASC and DESC I have created the controller:

   public function products($category_url, Request $request){
        Product::getProducts($category_url, self:: $data);
        if ($category1 = Categorie::where('url', '=', $category_url)->first()) {
           $sort = $request->get('sort', 'asc');
           $products = Product::where('categorie_id', $category1->getAttribute('id'))->orderBy('price', $sort)->get();
          $sort = $sort == 'asc' ? 'desc' : 'asc'; 
           return view('content.products', self::$data , compact('products', 'sort'));

the route

Route::get('shop/{category_url}?sort=DESC','[email protected]');
Route::get('shop/{category_url}?sort=ASC','[email protected]');

the link from the view

  <a href="{{ url('shop/'.$category['url'])}}?sort=DESC" style="color:black"> High to low</a> |
    <a href="{{ url('shop/'.$category['url'])}}?sort=ASC" style="color:black">Low to high</a>

But when I click on them the order doesn't change, any can please advice? Thanks

Please sign in or create an account to participate in this conversation.

Laracasts Mascot

Hi, Have We Met Yet?

Did you know that, in addition to the forum, Laracasts includes well over 1000 lessons on modern web development? All for the price of one lunch out per month.

Sign Me Up


Reply to

Use Markdown with GitHub-flavored code blocks.