As long as your results are ordered, you can use this method with any number of filters. You'll have to get creative on how to add the filters, because you don't want to create 2^10 SQL statements for every combination of filters.
The solution would be to pick 1 or 2 fields you can order your results by and then apply your filters as well. You can query the next page based on the field you are ordering your data by.
Example query for employees where the filter is the department and whether they are on vacation and order by birthdays
#page 1
SELECT * FROM employees
WHERE
department != 'finance' AND
on_vacation = false
ORDER BY birthday DESC
LIMIT 10
# page 2
SELECT * FROM employees
WHERE
department != 'finance' AND
on_vacation = false AND
birthday <= $last_birthday_on_page_1
ORDER BY birthday DESC
LIMIT 10
Hope that helps
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
As long as your results are ordered, you can use this method with any number of filters. You'll have to get creative on how to add the filters, because you don't want to create 2^10 SQL statements for every combination of filters.
The solution would be to pick 1 or 2 fields you can order your results by and then apply your filters as well. You can query the next page based on the field you are ordering your data by.
Example query for employees where the filter is the department and whether they are on vacation and order by birthdays
Hope that helps