PHP

laravel pagination

//For Pagination 
//Follow some steps

//1. set pagination value  in controller
DB::table('users') -> paginate(15)
  
//2 show pagination in blade file
@if ($items->hasPages())
    <div class="pagination-wrapper">
         {{ $items->links() }}
    </div>
@endif
      
      
//3. if you face css issue in blade file add write your css or just enable bootstrap for it
      
  //Open file -> app/Providers/AppServiceProvider.php
   //add use IlluminatePaginationPaginator; 
   // add below given line in boot function
     public function boot()
    {
        Paginator::useBootstrap();
        //
    }
      
   
  
  
  

laravel check pagination in blade

@if ($items->hasPages())
    <div class="pagination-wrapper">
         {{ $items->links() }}
    </div>
@endif

laravel pagination

<div>Showing {{($users->currentpage()-1)*$users->perpage()+1}} to {{$users->currentpage()*$users->perpage()}}
    of  {{$users->total()}} entries
</div>

Laravel Pagination

$users = User::where('votes', '>', 100)->paginate(15);

$users = User::where('votes', '>', 100)->simplePaginate(15);

$users = User::where('votes', '>', 100)->cursorPaginate(15);]


$users = User::paginate(15)->withQueryString();

$users = User::paginate(15)->fragment('users');


$users = User::where('votes', '>', 100)->paginate(
    $perPage = 15, $columns = ['*'], $pageName = 'users'
);


<div class="container">
    @foreach ($users as $user)
        {{ $user->name }}
    @endforeach
</div>
 
{{ $users->links() }}

{{ $users->onEachSide(5)->links() }}

use IlluminatePaginationPaginator;
 
/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Paginator::useBootstrapFive();
    Paginator::useBootstrapFour();
}

# The JSON from the paginator will include meta information such as total, current_page, last_page, and more. The result records are available via the data key in the JSON array. Here is an example of the JSON created by returning a paginator instance from a route:


{
   "total": 50,
   "per_page": 15,
   "current_page": 1,
   "last_page": 4,
   "first_page_url": "http://laravel.app?page=1",
   "last_page_url": "http://laravel.app?page=4",
   "next_page_url": "http://laravel.app?page=2",
   "prev_page_url": null,
   "path": "http://laravel.app",
   "from": 1,
   "to": 15,
   "data":[
        {
            // Record...
        },
        {
            // Record...
        }
   ]
}


Paginator / LengthAwarePaginator Instance Methods
Each paginator instance provides additional pagination information via the following methods:

Method	Description
$paginator->count()	Get the number of items for the current page.
$paginator->currentPage()	Get the current page number.
$paginator->firstItem()	Get the result number of the first item in the results.
$paginator->getOptions()	Get the paginator options.
$paginator->getUrlRange($start, $end)	Create a range of pagination URLs.
$paginator->hasPages()	Determine if there are enough items to split into multiple pages.
$paginator->hasMorePages()	Determine if there are more items in the data store.
$paginator->items()	Get the items for the current page.
$paginator->lastItem()	Get the result number of the last item in the results.
$paginator->lastPage()	Get the page number of the last available page. (Not available when using simplePaginate).
$paginator->nextPageUrl()	Get the URL for the next page.
$paginator->onFirstPage()	Determine if the paginator is on the first page.
$paginator->perPage()	The number of items to be shown per page.
$paginator->previousPageUrl()	Get the URL for the previous page.
$paginator->total()	Determine the total number of matching items in the data store. (Not available when using simplePaginate).
$paginator->url($page)	Get the URL for a given page number.
$paginator->getPageName()	Get the query string variable used to store the page.
$paginator->setPageName($name)	Set the query string variable used to store the page.


Cursor Paginator Instance Methods
Each cursor paginator instance provides additional pagination information via the following methods:

Method	Description
$paginator->count()	Get the number of items for the current page.
$paginator->cursor()	Get the current cursor instance.
$paginator->getOptions()	Get the paginator options.
$paginator->hasPages()	Determine if there are enough items to split into multiple pages.
$paginator->hasMorePages()	Determine if there are more items in the data store.
$paginator->getCursorName()	Get the query string variable used to store the cursor.
$paginator->items()	Get the items for the current page.
$paginator->nextCursor()	Get the cursor instance for the next set of items.
$paginator->nextPageUrl()	Get the URL for the next page.
$paginator->onFirstPage()	Determine if the paginator is on the first page.
$paginator->onLastPage()	Determine if the paginator is on the last page.
$paginator->perPage()	The number of items to be shown per page.
$paginator->previousCursor()	Get the cursor instance for the previous set of items.
$paginator->previousPageUrl()	Get the URL for the previous page.
$paginator->setCursorName()	Set the query string variable used to store the cursor.
$paginator->url($cursor)	Get the URL for a given cursor instance.

laravel pagination

//controller function to return view
public function index()
    {
        $data = ModelName::where(condition)->paginate(5);
        return view('viewPath', compact('data'));
    }
    
//paste this in view, where pagination to be display
{{$data->links()}}

laravel pagination with query string, laravel pagination with string

{{ $users->withQueryString()->links() }}

laravel pagination number of items

    public function myReferals(int $user_id): array
    {
        $refer = User::query()->where('ref_id', $user_id)->select(['id', 'name', 'created_at'])
            ->paginate(20);
        $data = [];
        foreach ($refer->items() as $key => $item) {
            $number = $refer->firstItem() + $key;
            $data[] = [
                'number' => $number,
                'id'     => $item->id,
                'name'   => $item->name,
                'data'   => AdminService::parseCarbonDateFormat($item['created_at']),
            ];

        }
        $refer         = $refer->toArray();
        $refer['data'] = $data;

        return AdminService::returnSuccess([
            'status' => 'success',
            'data'   => $refer,
        ]);
    }

laravel 6 pagination example

DB::table('users') -> paginate(15)
  
//2 show pagination in blade file
@if ($items->hasPages())
    <div class="pagination-wrapper">
         {{ $items->links() }}
    </div>
@endif

laravel pagination layout issue

/**
 * AppServiceProvider.php
 */

use IlluminatePaginationPaginator; // Don't forget this

public function boot ()
{
      Paginator::useBootstrap();	// Add this
}

custom pagination laravel css

php artisan vendor:publish --tag=laravel-pagination
  OR
use IlluminatePaginationPaginator;

public function boot()
{
    Paginator::defaultView('your-pagination-view-name');

}

laravel pagination

DB::table('users') -> paginate(15)

Laravel Pagination

use IlluminatePaginationPaginator;

Paginator::useBootstrap();

Laravel custom pagination

<?php
// config
$link_limit = 7; // maximum number of links (a little bit inaccurate, but will be ok for now)
?>

@if ($paginator->lastPage() > 1)
    <ul class="pagination">
        <li class="{{ ($paginator->currentPage() == 1) ? ' disabled' : '' }}">
            <a href="{{ $paginator->url(1) }}">First</a>
         </li>
        @for ($i = 1; $i <= $paginator->lastPage(); $i++)
            <?php
            $half_total_links = floor($link_limit / 2);
            $from = $paginator->currentPage() - $half_total_links;
            $to = $paginator->currentPage() + $half_total_links;
            if ($paginator->currentPage() < $half_total_links) {
               $to += $half_total_links - $paginator->currentPage();
            }
            if ($paginator->lastPage() - $paginator->currentPage() < $half_total_links) {
                $from -= $half_total_links - ($paginator->lastPage() - $paginator->currentPage()) - 1;
            }
            ?>
            @if ($from < $i && $i < $to)
                <li class="{{ ($paginator->currentPage() == $i) ? ' active' : '' }}">
                    <a href="{{ $paginator->url($i) }}">{{ $i }}</a>
                </li>
            @endif
        @endfor
        <li class="{{ ($paginator->currentPage() == $paginator->lastPage()) ? ' disabled' : '' }}">
            <a href="{{ $paginator->url($paginator->lastPage()) }}">Last</a>
        </li>
    </ul>
@endif

Laravel Pagination

@if (isset($paginator) && $paginator->lastPage() > 1)

    <ul class="pagination">

        <?php
        $interval = isset($interval) ? abs(intval($interval)) : 3 ;
        $from = $paginator->currentPage() - $interval;
        if($from < 1){
            $from = 1;
        }

        $to = $paginator->currentPage() + $interval;
        if($to > $paginator->lastPage()){
            $to = $paginator->lastPage();
        }
        ?>

        <!-- first/previous -->
        @if($paginator->currentPage() > 1)
            <li>
                <a href="{{ $paginator->url(1) }}" aria-label="First">
                    <span aria-hidden="true">«</span>
                </a>
            </li>

            <li>
                <a href="{{ $paginator->url($paginator->currentPage() - 1) }}" aria-label="Previous">
                    <span aria-hidden="true">‹</span>
                </a>
            </li>
        @endif

        <!-- links -->
        @for($i = $from; $i <= $to; $i++)
            <?php 
            $isCurrentPage = $paginator->currentPage() == $i;
            ?>
            <li class="{{ $isCurrentPage ? 'active' : '' }}">
                <a href="{{ !$isCurrentPage ? $paginator->url($i) : '#' }}">
                    {{ $i }}
                </a>
            </li>
        @endfor

        <!-- next/last -->
        @if($paginator->currentPage() < $paginator->lastPage())
            <li>
                <a href="{{ $paginator->url($paginator->currentPage() + 1) }}" aria-label="Next">
                    <span aria-hidden="true">›</span>
                </a>
            </li>

            <li>
                <a href="{{ $paginator->url($paginator->lastpage()) }}" aria-label="Last">
                    <span aria-hidden="true">»</span>
                </a>
            </li>
        @endif

    </ul>

@endif

laravel Simple Pagination

// Instead of 
$products = Product::paginate(8);

// Now you can do this
$products = Product::simplePaginate(8);

custom pagination in laravel

 'data' => [
    'meta' => [
    'totalPages' => ceil($pagination->totalRecords / $pagination->perPage),
    'currentPage' => $pagination->currentPage + 1,
    'totalRecords' => $pagination->totalRecords,
    'recordsOnCurrentPage' => count($records),
    'recordFrom' => ($pagination->currentPage * $pagination->perPage) + 1,
    'recordTo' => ($pagination->currentPage * $pagination->perPage) + count($records),
  ],
    'records' => $records,

laravel table number pagination

@foreach ($items as $key => $value)    
  {{ $items->firstItem() + $key }}
@endforeach

laravel create pagination

<?php

namespace AppHelpers;

use IlluminateContainerContainer;
use IlluminatePaginationLengthAwarePaginator;
use IlluminatePaginationPaginator;
use IlluminateSupportCollection;

class PaginationHelper
{
    public static function paginate(Collection $results, $showPerPage)
    {
        $pageNumber = Paginator::resolveCurrentPage('page');
        
        $totalPageNumber = $results->count();

        return self::paginator($results->forPage($pageNumber, $showPerPage), $totalPageNumber, $showPerPage, $pageNumber, [
            'path' => Paginator::resolveCurrentPath(),
            'pageName' => 'page',
        ]);

    }

    /**
     * Create a new length-aware paginator instance.
     *
     * @param  IlluminateSupportCollection  $items
     * @param  int  $total
     * @param  int  $perPage
     * @param  int  $currentPage
     * @param  array  $options
     * @return IlluminatePaginationLengthAwarePaginator
     */
    protected static function paginator($items, $total, $perPage, $currentPage, $options)
    {
        return Container::getInstance()->makeWith(LengthAwarePaginator::class, compact(
            'items', 'total', 'perPage', 'currentPage', 'options'
        ));
    }
}

laravel create pagination

"autoload": {
    "files": [
        "app/Helpers/PaginationHelper.php"
    ],
    "classmap": [
        "database/seeds",
        "database/factories"
    ],
    "psr-4": {
        "App": "app/"
    }
},

laravel create pagination

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

    $users = AppUser::get();

    $showPerPage = 20;

    $paginated = PaginationHelper::paginate($users, $showPerPage);

    return $paginated;
});