Pagination(JS/SQL/PHP)—How to select fixed-length subset of the general results to display in a single page

Parameters:
1.Items per page (offset): indicates how many posts display in a single page. For now, this will be a static number, but may later become an item in preferences.

2.Page number: determines how many multiples of the offset we exclude from the result set before selecting items.

3.Post list:

Return: array of results associated with the selected ids, to be parsed in JS.

Notes: this will be split into two parts. The first, in JS, will collect the relevant ids from the general list provided by the list retrieval function, and use an AJAX call to send them as an array to a PHP page. The PHP will cycle through these ids and pull the associated data from the database, returning an array of results that’ll be parsed by the JS.