What is the best way to implement ajax based pagination on custom query based templates?

Soumitra Chakraborty wrote a very good tutorial on Getting Started with AJAX & WordPress Pagination. I would recommend following that pattern (in terms of how to use admin_ajax.php in conjunction with your functions.php.

That tutorial will give you a great framework for how to implement ajax pagination by hand.

In terms of your own specific requirements for a custom query (which it sounds like might involve getting data from non-standard tables) you can use the WP_Query class to do some pretty advanced stuff (like what you describe) in your custom function that you define in functions.php.

Related Posts:

  1. How To create ajaxed wp-pagenavi?
  2. Fetching more posts in WordPress via AJAX
  3. AJAX pagination offset returns same post on adjacent pages
  4. Stop loading more posts if none left AJAX
  5. Get Previous/Next Post ID for Posts in Same Category
  6. Loading post like facebook on scrool to bottom [duplicate]
  7. Changing pagination list class
  8. How to show a single post on the front page but have normal paging?
  9. Pagination resolving to first page only
  10. Pagination of RSS2 feed
  11. Modifying WP_LIST_AUTHOR Functions to output all users in a grid (and Paginate)
  12. Problem: ( kriesi ) pagination doesn’t work in homepage [duplicate]
  13. How to ignore or disable nextpage tag?
  14. Category pagination shows same posts
  15. category/category_name pagination 404 error
  16. Search – Ajax – Alter Query Parameters with Pagination
  17. get_query_var(‘paged’) giving same result
  18. Show content only on front page?
  19. Getting 404 on taxonomy page
  20. Why am I getting a 404 on anything past page 1 of my query?
  21. Getting pagination for second loop to work on single.php
  22. 5 posts per page from single category, paginated
  23. WordPress custom URLs for pagination pages
  24. Home page not obeying post per page setting on the first page only
  25. How to add pagination to a single post
  26. WordPress rewrite rules for pagination on search page
  27. Styling the_posts_pagination With Font Awesome
  28. Pagination on 2nd loop
  29. How can I show a multipage post as a single, wrapped post?
  30. Why does pagination go to a blank page when navigating through home.php?
  31. Pagination with $_POST and $_SESSION
  32. wordpress is converting ?page=2 into /2
  33. Pass additional parameter in the URL
  34. Template hierarchy about pagination after front-page.php
  35. Why do next pages load the same content rather then older articles?
  36. Nested Pagination
  37. Add pagination to my custom loop [duplicate]
  38. Pagination stopped working after assigning custom page template to new page (different slug)
  39. Pagination with WordPress default gallery?
  40. Yoast’s rel=“next” & rel=“prev” tag don’t work on static homepage’s paginated pages
  41. How do i improve my custom pagination?
  42. Post Pagination Customization (wp_link_pages) Editing Navigation
  43. Default pagination is broken when use ‘static page’ as ‘front page’
  44. Using paginate_links() to generate “01, 02, 03, 04” paginations
  45. Paginate results from data fetched through array
  46. make a pagination that show posts by date
  47. Pagination with custom query, custom search form, single and pages, ajax and no plugins
  48. Adding pagination on template page wordpress
  49. Pagination on custom post type not working if permalinks set to rewrite url
  50. Theme Option not Working Inside a Function
  51. search with pagination not working as expected
  52. Pagination Not Working on `WP_Query` Archive Page
  53. Cannot go back to the first paginated page using pagination links
  54. How do I make my pagination work?
  55. How to use custom previous/next link ?
  56. Remember form field values with page navigation
  57. How do you choose to display specific posts/pages by parent url
  58. Custom category.php paging shows the same posts
  59. Pagination Links showing incorrect previous page number
  60. How to limit page pagination… again
  61. Paginate Links – Mid Size Less Than 2
  62. tax_query does not work with pagination with custom query (both wp_query and query_posts())
  63. Automatically adding a link to the next page link before ” tag in posts?
  64. Adding paging to get_posts()
  65. Can I paginate this get_attachment query?
  66. How to Show Next-Previous Link Only
  67. WordPress static home page pagination not working
  68. How to create a WordPress gallery with pagination
  69. Broken pagination links on WP 4.9.10 blog pages
  70. Excluding posts without affecting the number of posts per page
  71. get_next_posts_page_link adds Inexistent directories
  72. How to add post page pagination to template part?
  73. Following/Followers Users list Using Ajax Pagination inside Author Profile
  74. why pagination not working in page template
  75. 404 page not found on pagination in home page while navigating to next page
  76. Linking images in WordPress Paginated Post
  77. Pagination in Archives
  78. Only show pagination when post count exceeds show post
  79. Pagination – linking back to base page – Page 1
  80. Custom Pagination shows same posts on each page
  81. Numbered pagination showing all numbers instead of paginated blocks
  82. Show next and previous page number
  83. Search pagination link redirecting to a link that doesn’t work with pagination
  84. Custom Query & Rewritten URL Pagination 404
  85. Search URL gives 404
  86. How to paginate query using get_categories()
  87. Adding pagination to query for custom page
  88. Main page paginate_links issue
  89. WordPress creating 404s under blog tags
  90. Removing template part when not on homepage if / else
  91. Paginate template name
  92. WordPress pagination URL posts not load
  93. How to reduce the number of pages in pagination
  94. Use cookies in pagination
  95. foreach pagination
  96. Always show Next and Previous button in wp_link_pages ?
  97. paged query leads to 404? [duplicate]
  98. Pagination only working on index page not on a template page
  99. Stop pagination when static homepage is set
  100. Is ‘pm’ used by core?