How to add record sequence number field in SQL query?

Question

Laravel

There is a request:

$users = DB::table('users')
->whereBetween('votes', [20, 100])
->orderBy('votes', 'desc')
->paginate(10);

It returns:
4
7
1
5
15
and id.
How to add a boolean field 'rank' and get:
1 - 4
2 - 7
3 - 1
4 - 5
5 - 15
At the same time, when entering the second page, you need to display 'rank' from 10

Answer 1

$i = ($page_num*10)-1;

foreach(){
$i++;
echo $i;
}

Well, or https://laravel.com/docs/5.3/pagination#paginator-...

Answer 2

With such a request, it will return all columns to you. Therefore, if you have an ID field in your table, then you can output it as

foreach($users as $user){
    echo $user->id;
}

or in template

@foreach($users as $user)
    {{ $user->id }}
@endforeach

if you only want 2 columns from query then add select like this

$users = DB::table('users')
->select('id', 'rank')
->whereBetween('votes', [20, 100])
->orderBy('votes', 'desc')
->paginate(10);

Answer 3

$i = 1;
    if ($data->currentPage() > 1){
        $i = (30 * ($data->currentPage()-1))+1;
    }

The number specified in ->paginate(30).