Laravel 8 Get Next and Previous Record Example

July 31, 2021 | Category : Other

Hi Dev,This tutorial shows you laravel 8 next previous record url and link. you can see how to get previous and next record in laravel 8 query. step by step explain laravel get next and previous record. you can understand a concept of how to get next and previous record in laravel 8.

In this example, we will create posts table and create view route to display post details. in details page we will add previous and next button to show next post and previous post. you can use this example with laravel 6, laravel 7 and laravel 8 version.

You can see simply preview as bellow:

Preview:

Step 1: Create Post Model

In first step, we need to create posts route with next and previous attribute. so we can get next and previous record from object. so let's add code as bellow and add some dummy records to your posts table:

app/Models/Post.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

use HasFactory;

protected $fillable = [

'title',

'body',

'slug'

];

/**

* Write code on Method

*

* @return response()

*/

public function getNextAttribute(){

return static::where('id', '>', $this->id)->orderBy('id','asc')->first();

}

/**

* Write code on Method

*

* @return response()

*/

public function getPreviousAttribute(){

return static::where('id', '<', $this->id)->orderBy('id','desc')->first();

}

}

Step 2: Create Route

In this is step we need to create some routes for view posts.

routes/web.php

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\PostController;

/*

|--------------------------------------------------------------------------

| 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('posts/{slug}',[PostController::class,'show'])->name('posts.show');

Step 3: Create Controller

in this step, you can put bellow code for post controller:

app/Http/Controllers/PostController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Post;

class PostController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function show($slug)

{

$post = Post::whereSlug($slug)->first();

return view('posts.show', compact('post'));

}

}

Step 4: Create Blade Files

here, we need to create blade files for show. so let's create one by one files:

resources/views/posts/show.blade.php

<!DOCTYPE html>

<html lang="{{ str_replace('_', '-', app()->getLocale()) }}">

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>How to Get Previous and Next Record in Laravel - ItSolutionstuff.com</title>

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0/dist/css/bootstrap.min.css" rel="stylesheet">

</head>

<body>

<div class="container mt-5">

<h1>How to Get Previous and Next Record in Laravel - ItSolutionstuff.com</h1>

<h2>{{ $post->title }}</h2>

<p>{{ $post->body }}</p>

<div class="row">

<div class="col-6">

@if (isset($post->previous))

<a href="{{ route('posts.show', $post->previous->slug) }}">

<div> Previous</div>

<p>{{ $post->previous->title }}</p>

</a>

@endif

</div>

<div class="col-6">

@if (isset($post->next))

<a href="{{ route('posts.show', $post->next->slug) }}">

<div>Next</div>

<p>{{ $post->next->title }}</p>

</a>

@endif

</div>

</div>

</div>

</body>

</html>

Now we are ready to run our example. so run bellow command so quick run:

php artisan serve

Now you can open bellow URL on your browser:

localhost:8000/posts/{your_slug}

i hope it can help you...