Write laravel example to set limit and offset in Laravel PHP

Published January 17, 2022

Using the OFFSET value, you can specify which row to start when you are retrieving a keyword. The OFFSET value is usually used together with the LIMIT keyword. This post presents an example of how to set the limit and offset in a Laravel project.


How to set Limit and Offset in Laravel PHP

In this example, we will use the setLimit and offset functions in Laravel to select a specific set of data from a MySQL database. Let's go through the steps below:

Step 1:Create a new Laravel project in your Composer command prompt using the  command below

composer create-project --prefer-dist laravel/laravel LimitOffset



How to set Limit and Offset in Laravel PHP


A new project will be created in your htdocs folder.

Step 2: Use the SQL query below to create a new database where your data will be stored for future retrieval



Create a database table called users with id, name, and address columns and populate it with sample data

How to set Limit and Offset in Laravel PHP 2


Now that our database is set up, let's link it to our Laravel application.

Step 3: Create a connection between your Laravel application and the MySQL database by configuring your .env file. To do this, set your DB_CONNECTION, DB_HOST, DB_PORT, DB_DATABASE, DB_USERNAME, and DB_PASSWORD


How to set Limit and Offset in Laravel PHP 3


Our database connection is set. Now let’s proceed to generating migration.

Step 4: Create a userController.php using the following command

php artisan make:controller UserController;



How to set Limit and Offset in Laravel PHP 4

Open the UserController.php and paste the code below



namespace App\Http\Controllers;


use Illuminate\Http\Request;


//import database class

use Illuminate\Support\Facades\DB;


class UserController extends Controller



function index()


        return DB::select("SELECT name, email, address FROM  users ORDER BY id  LIMIT 5 OFFSET 3");





In this code, we have implemented the set Limit and offset in SQL Query. This query will select data from our users table.

Step 5: Let’s create a route to display our view.  Open, webb.php and paste the code below



use Illuminate\Support\Facades\Route;

use App\Http\Controllers\UserController;



| Web Routes



| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!




Route::get('/', function () {

return view('welcome');


Route::get('users', [UserController::class,'index']);



How to set Limit and Offset in Laravel PHP 5


We are done. Run the command php artisan serve to obtain the application url.


Paste the url on your browser.

How to set Limit and Offset in Laravel PHP 6


In this laravel tutorial we covered write a query to set limit and offset for the where condition


Download Source code


Article Contributed By :