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 Illuminate\Pagination\Paginator; 
   // add below given line in boot function
     public function boot()
    {
        Paginator::useBootstrap();
        //
    }

Source: grepper.com

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 Illuminate\Pagination\Paginator;
 
/**
 * 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.

Source: grepper.com

Laravel pagination

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

Source: laracasts.com

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

Source: stackoverflow.com

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()}}

Source: laravel.com

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

Source: grepper.com

Laravel pagination

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

Source: grepper.com

Laravel Pagination

use Illuminate\Pagination\Paginator;

Paginator::useBootstrap();

Source: laravel.com

Laravel Simple Pagination

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

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

Source: grepper.com

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

Source: stackoverflow.com

Similar codes

15 votes286 views4 answers
Remove space from start and end of string in php
PHP
0 vote449 views1 answer
Yii app db createcommand join yii1
PHP Yii
33 votes305 views6 answers
Laravel query builder
PHP Laravel
0 vote300 views2 answers
Pdo check if row exists
PHP
2 votes295 views1 answer
Php pow
PHP
0 vote318 views2 answers
Asset function in laravel not working
PHP
0 vote324 views1 answer
Laravel signed Route custom domain
PHP Laravel
1 vote296 views1 answer
Prettier with php
PHP
7 votes284 views2 answers
Php compare string
PHP
8 votes332 views3 answers
Route parameter type laravel
PHP Laravel