increment row number with laravel pagination

Question

How to make increment row number with laravel pagination ? When i use pagination and i go to page 2 and above it will back to beginning. for example i will paginate(3)

    <thead>
    <tr>
       <th>No</th>
       <th>Name</th>
    </tr>
    </thead>
    <tbody>
    <?php $i = 1; ?>
    @foreach ($telephone->results as $telp)
    <tr>
       <td>
         {{$i++}}
       </td>
       <td>{{ $telp->name }}</td>                               
    </tr>
    @endforeach
    </tbody>

when i go to page 2 the number will start from 1 again.

i need to make it when i go to page 2 it will start from 4

score 29 · Answer 1 · answered Dec 07 '16 at 15:45

29

In Laravel 5.3 you can use firstItem():

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

answered Dec 07 '16 at 15:45

o.v

835
10
15

Sodruldeen Mustapha · Answer 2 · 2019-04-17T11:47:47.060

15

The below works with laravel 5.4

<?php $i = ($telephone->currentpage()-1)* $telephone-
>perpage() + 1;?>
@foreach($telephone as $whatever)
<td> {{ $i++ }}</td>
@endforeach

Edited The below works for laravel 5.7 above

@foreach ($telephone as $key=> $whatever)
  <td>{{ $key+ $telephone->firstItem() }}</td>
@endforeach

edited Apr 17 '19 at 11:47

answered Sep 20 '17 at 07:38

Sodruldeen Mustapha

1,135
10
22

Jason Lewis · Accepted Answer · 2013-08-04T02:49:09.217

8

You should be able to use the getFrom method to get the starting number of the current pages results. So instead of setting $i = 1; you should be able to do this.

<?php $i = $telephone->getFrom(); ?>

In Laravel 3 there is no getFrom method so you need to calculate it manually.

<?php $i = ($telephone->page - 1) * $telephone->per_page + 1; ?>

edited Aug 04 '13 at 02:49

answered Aug 03 '13 at 02:31

Jason Lewis

18,537
4
61
64

Thank you for your kind attention. By the way when I use getForm method i get error Call to undefined method Laravel\Paginator::getFrom() – user2194246 Aug 03 '13 at 15:12
Ah sorry, assumed L4. I've updated my answer to include an L3 variation. – Jason Lewis Aug 04 '13 at 02:49

score 7 · Answer 4 · answered Sep 07 '16 at 08:48

7

Laravel 5.3

@foreach ($products as $key=>$val)
  {{ ($products->currentpage()-1) * $products->perpage() + $key + 1 }}
@endforeach

answered Sep 07 '16 at 08:48

Mhd Syarif

101
1
2

score 4 · Answer 5 · answered Nov 09 '19 at 21:46

For Laravel 6.2: $loop - just in case, is a built-in instance in Blade

@foreach($array as $item)
    <tr class="table-row">
      <td class="site-id">
         {{($array->currentPage() - 1) * $array->perPage() + $loop->iteration}}
      </td>
    </tr>
@endforeach
</table>

score 1 · Answer 6 · edited Aug 03 '17 at 06:23

1

You can simply add the following line

$i = ($telephone->currentpage()-1)* $telephone->perpage();

in place of

$i = 1;

edited Aug 03 '17 at 06:23

answered Aug 03 '17 at 06:19

Shweta

661
6
11

score 1 · Answer 7 · answered Mar 20 '18 at 03:27

1

@php($sl = ($yourVariable->perPage() * $yourVariable->currentPage()) - ($yourVariable->perPage() - 1))

@foreach($yourVariable as $item)

<td>{{ $item->key_name }}</td>

.....

@php($sl++)

@endforeach

answered Mar 20 '18 at 03:27

Ashok Barua

11
1

you should explain the answer – tryingToLearn Mar 20 '18 at 03:48

score 1 · Answer 8 · edited Jan 15 '20 at 10:56

1

In Laravel 6


@php $i = ($data->currentpage()-1)* $data->perpage() + 1;@endphp

@foreach($data as $banner)
 <tr>
   <td>{{$i}}</td>
   <td><img src="{{ URL::to('/') }}/dist/img/{{$banner->name}}" height="250" width="600"></td>
 </tr>
 @php  $i += 1; @endphp
@endforeach

edited Jan 15 '20 at 10:56

parisssss

803
16
36

answered Jan 15 '20 at 10:23

Asad Aslam

11
1

Elbo Shindi Pangestu · Answer 9 · 2020-05-04T09:09:39.477

If you are using Laravel Pagination. It works very well

The backend

public function index()
{
    return view('your.telephone.index', [
        'telephone' => Telephone::paginate(15)
    ]);
}

Blade front end

<td>{{ (($telephone->currentPage() * 10) - 10) + $loop->iteration  }}</td>

And don't forget embed the page

{{ $telephone->links() }}

For $loop->iteration

See the doc here: https://laravel.com/docs/7.x/blade#the-loop-variable

For $telephone->currentPage()

See the doc here: https://laravel.com/docs/7.x/pagination#paginator-instance-methods

score 1 · Answer 10 · answered Jan 06 '22 at 07:51

I'm using this, in Laravel 8, accessing $loop, and links()->paginator:

       @foreach ($users as $user)
            <tr>
                <td class="text-center">{{ ($users->currentPage() - 1)  * $users->links()->paginator->perPage() + $loop->iteration }}</td>
                <td class="text-center">{{$user->name}}</td>
            </tr>
        @endforeach

Which works properly even when the final page is only partially filled.

Could also use $users->perPage() in place of $users->links()->paginator->perPage()

user1429277 · Answer 11 · 2015-11-12T14:07:37.710

0

Or avoid php tags completely by

 @foreach ($users as $key => $user)
    {{ (Input::get('page', 1) - 1) * $users->getPerPage() + $key + 1 }}
 @endforeach

edited Nov 12 '15 at 14:07

answered Nov 12 '15 at 14:02

user1429277

36
3

score 0 · Answer 12 · answered May 28 '21 at 06:50

You can use it in your controller. example given below

$records = Table::paginate(20);
return view('yourview',compact('records')->with('i', ($request->input('page', 1) - 1) * 20);

Note: paginate value must be equal to with() function vlaue

after that you can use $i variable in you blade file. controller calculate value according to page number and return to blade

In blade file. use inside the loop

{{ ++$i }}

Hopefully this will help you

score 0 · Answer 13 · answered Sep 14 '21 at 03:47

0

Laravel 8++

$loop->iteration is available out of the box inside loop.

{{ ($barangs->currentPage() - 1)  * $barangs->count() + $loop->iteration }}

answered Sep 14 '21 at 03:47

Roby Cigar

766
2
14
28

`$barangs->count()` should be `$barangs->perPage()`. `count()` is for the current page, which will cause issues if you're on the last page and it has a different number of results from the others pages. – anjama Mar 30 '22 at 14:04

score 0 · Answer 14 · answered May 15 '23 at 16:00

0

$products = Product::paginate(); // ProductController  
    

// product/index.blade.php

@foreach($products as $product)
<tr>
  <td>
    {{($products->currentPage() - 1)  * $products->perPage() + $loop->iteration}}
  </td>
<tr>
@endforeach

answered May 15 '23 at 16:00

Azizullah Saeidi

41
5

Add some explanation with code, so that it can help others too for the same or similar problem. A comment has been added as part of the review. – B25Dec May 16 '23 at 03:03

score 0 · Answer 15 · edited May 26 '23 at 08:20

0

@foreach($showUserData as $key => $data) {
 <tr>
 <td>{{$showUserData->firstItem() + $key}}</td>
</tr>
}
@endforeach

This will give you the sequence you need. It starts from 1 and on next page from the last record +1.

edited May 26 '23 at 08:20

tripleee

175,061
34
275
318

answered May 26 '23 at 08:07

Ravi A

1
1

score 0 · Answer 16 · answered Jun 14 '23 at 09:04

0

@php
 $i = ($users->currentPage() - 1) * $users->perPage() + 1;
@endphp

using laravel new

answered Jun 14 '23 at 09:04

Bahyu Sanciko

1
1
2

increment row number with laravel pagination

16 Answers16