Code The Pixel

CakePHP 4 Print Increment Number With Every Table Row

Asyraf Wahi Anuar - December 22, 2021
Published in CakePHP 2037 Views Email This Article
Estimated reading time: 42 seconds

Increment number in every table row is very useful in some web application projects. This tutorial will show how to set a maximum limit of rows per page with an incrementing number in every row. If we set the maximum number of rows per page is 10, the first page should print the row number from 1 to 10 and on the second page, it should print 11 to 20. 

Defined the maxLimit
In your controller, define the maxLimit as shown below:

$this->paginate = [
	'maxLimit' => 10
];


Print rows number
In your view (eg: index), include the following code:

<?php
$page = $this->Paginator->counter('{{page}}');
$limit = 10; 
$counter = ($page * $limit) - $limit + 1;
?>
        <?php foreach ($articles as $article) : ?>
        <tr>
            <td><?= $counter++ ?></td>


This will print the row number based on the current page.


Cite this article (APA 6th Edition)