Page principle of database query results

The principle of paging is actually very simple.

Take advantage of pure SQL queries. Just added limit.

SELECT * from Test; Query all the

SELECT * FROM Test limit 10, 5; The query starts from 11 for five consecutive.

Limit 10, 5 means simple. The first parameter refers to how many rows are skipped before. The second is the meaning of how many rows to query.

Then you paged all the results. Determine how many per page you have. The total number of pages mysqli_num_rows (). Final display.

Then it is implemented by the program, the principle is the same, the code details are different.

PS: Is there any other way besides this paging method? Please advise:

Page principle of database query results