Laravel

Laravel for Beginners! How to Easily Sort List Data from the Database in Descending or Ascending Order

 

This article clearly explains how to use Laravel to sort list data retrieved from the database in descending or ascending order based on user interaction. This technique is very useful for improving user experience.

Contents
  1. Check Laravel Version
  2. Edit the List Page View
  3. Controller Code
  4. Set Up the Route
  5. Summary

Check Laravel Version

First, let’s check the version of Laravel. I implemented this feature using “Laravel Framework 6.18.39”. You can check the version in your environment using the following command:

php artisan -V

Edit the List Page View

In the View that displays the list, add links to sort the data. For example, to sort by ID, add a link like the following to the ID column:

	<th><a href="./listpages?sort=id&order={{ $order }}">ID</a></th>
	<th>Name</th>
	<th>Age</th>
	<th>Gender</th>

Controller Code

Next, write the sorting logic in the Controller. It retrieves the sort field (column name) and order (descending or ascending) specified by the user, and fetches data based on that.
Using $request (parameters from the view), determine sort (the column name to sort) and order (desc or asc), and then retrieve the sorted data.

    public function listdata(Request $request)
    {
        $sort = $request->sort;
        $order = $request->order;
        // If parameters are not set, default to sorting by 'id' in descending order
        if (is_null($sort) && is_null($order)) {
            $sort = 'id';
            $order = 'desc';
        }

        $orderpram = "desc";
        // If the current order is 'desc', set 'asc' for the next view link parameter
        if($order=="desc"){
            $orderpram="asc";
        }

        // Retrieve 20 items sorted by the given ID
        $listpages = Listpage::orderBy($sort, $order)->paginate(20);

        return view('listpages', [
            'listpages' => $listpages,
            'order' => $orderpram, // Set view link parameter
        ]);
    }

Set Up the Route

Finally, configure the routing. By writing it as follows, you can access the list page with sorting functionality.
Display a page that sorts retrieved DB list data in descending/ascending order via “https:// ～ /listpages“:

Route::get('/listpages', 'ListpagesController@listdata');

Summary

This completes the basic implementation of sorting data in descending/ascending order using Laravel. Please adjust the page URL and Controller code to fit your actual project.
With this feature, users can more comfortably search for information.

Beginners should definitely try implementing this feature and experience the power of Laravel.

*Please use at your own risk when reusing.

Sort
RELATED POST