Pagination Data from Database with Eloquent ORM in Laravel Framework

Create new database named laravel_db. In this database, create new table named product as below:

Download and install the latest version of Composer from https://getcomposer.org/download/
Open Windows Terminal in Visual Studio Code install Laravel Installer with command as below:
```
composer global require laravel/installer
```
Create new folder named LearnLaravelWithRealApps. Use Visual Studio Code open to LearnLaravelWithRealApps foler. In this folder, create new project named LearnLaravelWithRealApps with command as below:
```
laravel new LearnLaravelWithRealApps
```
Run LearnLaravelWithRealApps project with command as below:
```
php artisan serve
```
Open LearnLaravelWithRealApps project with url as below:
```
http://localhost:8000
```

Open .env file in root folder. Add values as below connect to database:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=laravel_db
DB_USERNAME=root
DB_PASSWORD=

Open Windows Terminal in Visual Studio Code and clear config cache with command as below:

php artisan config:clear

Create new PHP file named Product.php in app/Models folder as below:

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
    protected $primarykey = 'id';
    protected $table = 'product';
    public $timestamps = false;
}

Create new folder named Repositories. In Repositories folder, create new folder named Product. Create new PHP file named ProductRepository.php in app/Repositories/Product folder as below:

<?php

namespace App\Repositories\Product;

interface ProductRepository
{
    public function findAll($n);
}

Create new PHP file named ProductRepositoryImpl.php in app/Repositories/Product folder as below:

<?php

namespace App\Repositories\Product;

use App\Models\Product;

class ProductRepositoryImpl implements ProductRepository
{
    public function findAll($n)
    {
        $products = Product::paginate($n);
        $products->setPath('/demo/index');
        return $products;
    }
}

Open AppServiceProvider.php file in app/Providers folder and add declare new repository to register method as below:

<?php

namespace App\Providers;

use App\Repositories\Product\ProductRepository;
use App\Repositories\Product\ProductRepositoryImpl;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    public function register()
    {
        $this->app->bind(ProductRepository::class, ProductRepositoryImpl::class);
    }

    public function boot()
    {
    }
}

Open AppServiceProvider.php file in app/Providers folder and add declare Bootstrap for Pagination as below:

<?php

namespace App\Providers;

use App\Repositories\Product\ProductRepository;
use App\Repositories\Product\ProductRepositoryImpl;
use Illuminate\Support\ServiceProvider;
use Illuminate\Pagination\Paginator;

class AppServiceProvider extends ServiceProvider
{
    public function register()
    {
        $this->app->bind(ProductRepository::class, ProductRepositoryImpl::class);
    }

    public function boot()
    {
        Paginator::useBootstrap();
    }
}

Create new PHP file named DemoController.php in app/Http/Controllers folder as below:

<?php

namespace App\Http\Controllers;

use App\Repositories\Product\ProductRepository;

class DemoController extends Controller
{
    protected $productRepository;

    public function __construct(ProductRepository $productRepository)
    {
        $this->productRepository = $productRepository;
    }

    public function index()
    {
        $data = array(
            'products' => $this->productRepository->findAll(2)
        );
        return view('demo/index')->with($data);
    }
}

Create new folder named demo in resources/views folder. In this folder, create new Blade file named index.blade.php as below:

<html>

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

    <body>

        <div class="container">
            <div class="row">
                <div class="col">&nbsp;</div>
            </div>
            <div class="row">
                <div class="col">
                    <table border="1" class="table">
                        <tr>
                            <th>Id</th>
                            <th>Name</th>
                            <th>Price</th>
                            <th>Quantity</th>
                            <th>Status</th>
                            <th>Created</th>
                            <th>Description</th>
                        </tr>
                        @foreach($products as $product)
                        <tr>
                            <td>{{$product->id}}</td>
                            <td>{{$product->name}}</td>
                            <td>{{$product->price}}</td>
                            <td>{{$product->quantity}}</td>
                            <td>{{$product->status}}</td>
                            <td>{{$product->created}}</td>
                            <td>{{$product->description}}</td>
                        </tr>
                        @endforeach
                        <tr>
                            <td colspan="3" align="center">
                                &nbsp;
                                <div class="d-flex justify-content-center">
                                    @if ($products->hasPages())
                                        Showing {{((($products->currentPage() -1) * $products->perPage()) + 1)}} to {{((($products->currentPage() -1) * $products->perPage()) + $products->count()) }} of {{ $products->total() }} products. Page {{ $products->currentPage() }}/{{ $products->lastPage() }}
                                    @endif
                                </div>
                            </td>
                            <td colspan="4" align="center">
                                &nbsp;
                                <div class="d-flex justify-content-center">
                                    {{ $products->links() }}
                                </div>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
        </div>
    </body>

</html>

Open web.php file in routes folder, add new routes as below:

<?php
    
use Illuminate\Support\Facades\Route;

use App\Http\Controllers\DemoController;

Route::get('/', [DemoController::class, 'index']);
Route::get('/demo', [DemoController::class, 'index']);
Route::get('/demo/index', [DemoController::class, 'index']);

Access index action in Demo controller with urls as below:

http://localhost:8000
http://localhost:8000/demo
http://localhost:8000/demo/index

Output

Create Database

Structure of Product Table

Data of Product Table

Install Laravel

Connect to Database

Clear Config Cache

Create Product Model

Create ProductRepository Interface

Create ProductRepositoryImpl Class

Declare Product Repository

Install Bootstrap Pagination

Controllers

Views

Routes

Structure of Laravel Project

Run Application

Related Posts