MPDF仅对每页的结果求和

Question

I would like if its possible to show the sum of the records get it from database but from only per page.

So i insert all values into database and show it at the mpdf page and at the last page i show the total from all values into database but i would like to show per page the sum of the records only showed per page. I guess its kinda impossible, i seriously dont know how to do it. Any help would be appreciated.

Page1: value1 value2 total_page1

Page2: value1 value2 value3 total_page2

PS: The values are from database.

Cumps.

Answer 1

To accomplish something like that in SQL, you need to use aggregation. For example, a count of results per page might look something like this:

SELECT page_number, COUNT(*) AS numResults
FROM myTable
GROUP BY page_number;