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
|
 |
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 DATABASE blog; |
Create a database table called users with id, name, and address columns and populate it with sample data
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
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;
|
Open the UserController.php and paste the code below
|
<?php
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
|
<?php 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']); |
We are done. Run the command php artisan serve to obtain the application url.
Paste the url http://127.0.0.1:8000/users on your browser.
In this laravel tutorial we covered write a query to set limit and offset for the where condition
|
Article Contributed By :
|
|
|
|
|
696 Views |
|