Simple set up pagination in backend Laravel when using SQL DB

 

• The OFFSET clause specifies the number of rows to skip before starting to return rows from the query. The offset_row_count can be a constant, variable, or parameter that is greater or equal to zero.

https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/

• 
  

          // Init and set up limit and offset for pagination

          $page  = $request->page;

          // Get item per page from request

          $item_per_page = $request->limit;

          $offset = ($page - 1) * $item_per_page;

          // Order by

          $order_by = $request->sort;

          if (strpos($order_by, '+transaction_date') !== false) {

              $order = 'DESC';

              // Sort by transaction date

              $order_item = 'table.transaction_date';

          }

          else {

              $order = 'ASC';

              $order_item = 'table.transaction_date';

          }
• 
  

          })->where('table.company_id', $application_company_id)->limit($item_per_page)->offset($offset)->orderBy($order_item, $order)-->get();