What is the paging principle on a webpage?

0 reply content: Assume that the current page is an article page with 10 articles displayed.
The first page is actually getting 1st ~ from the database ~ 10 data records.
The second page is actually the 11 ~ 20 data records.

The database layer uses a mysql syntax called limit .. which can be used to specify the selected data ..
(For specific usage, please do not go into details here)

Mysql on the first page is:
Select * from post limit 0, 10
Obtain 10 records starting from 0th.

Mysql on the second page is:
Select * from post limit 11, 10
Take 10 records from 11th.


Which page does the current page take the get parameter as the page number ..

Suppose the URL is: http://www.something.com /? P = 1
The first page is displayed...

Tips: when using the p parameter value, you must filter out special characters and then splice them into the mysql statement.
Otherwise, the SQL injection vulnerability... Do you mean the page layout of web pages?

I also want to know what the principle is.

(Please fold me to make good use of search engines is the first lesson for programmers.