How to find what index page a post is on?

There’s no way to do it directly but there’s a way to determine the position of a particular row in a mysql query. You can find out how to do it here- https://stackoverflow.com/questions/3614666/mysql-get-row-position-in-order-by

Once you have the position you can divide it with the value from get_option('posts_per_page') to determine the correct page number.

Related Posts:

  1. Adding additional data to WP_Post object
  2. WP_Query: Why is sticky post not first item in loop?
  3. Displaying the category name of a custom post type
  4. How do I reorder (pop and push) items from WP_Query?
  5. How to exclude latest x posts from a paginated query?
  6. Reverse chronology of post listing
  7. WP_Query to work with custom view
  8. Most viewed post for the last 2 days using WP_Query
  9. Adding Post Counts to Menu (Nav) Programmatically?
  10. This AJAX Code Doesn’t Work – Looking for elegant solution
  11. How to add posts to wp_query result?
  12. Posts for next month
  13. Add a custom option to a page in backend
  14. WP_Query only ONE post, won’t work
  15. Unable to modify(update) posts – Page not found
  16. Replace Main Query With Custom Query
  17. Hide Post comments when displayed via WP_Query
  18. Hiding posts in a list from specified categories
  19. Group posts by year in loop
  20. wp query with dynamic taxonomies and terms?
  21. How to get posts by multiple post slugs? [duplicate]
  22. Blogroll – Different layout for first post
  23. WP_Query do not load specifed number of post
  24. WP_Query: offset ignored when posts_per_page is -1?
  25. How do I use `posts_distinct` correctly?
  26. How can I remove posts of a certain category from homepage after a specified time period?
  27. Automatic value for custom fields for posts
  28. Loop through all product posts?
  29. Get random posts between specific dates / of specific age
  30. Yearly archive page for future year
  31. Display post from current category and same tag?
  32. Ajax load more button in Recent posts widget
  33. WP_Query orderby not working with meta_value_num and menu_order
  34. Custom WP_Query with complex ‘post_status’ argument
  35. is there a way to show the the post title after the image?
  36. How do I correctly set up a WP-Query to only show upcoming event-posts?
  37. Blog post per page setting conflicting with custom WP_Query?
  38. Display post option on frontend
  39. How to filter my search in post if contains a word in title, content or excerpt?
  40. How to return another post than requested
  41. Select only post id and meta value with WP_Query
  42. Random ajax load only works with posts_per_page set to -1
  43. Query posts and return XML
  44. wp_posts table: safely remove unused columns to save database storage
  45. Query Posts by Custom Field
  46. how can i change WP main archives loop to sort by name or title
  47. Using wp_list_pages() after calling query_posts()
  48. Why are my paginated posts always returning the same results?
  49. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  50. Loop doesn’t exclude the specified category in home page
  51. why the same code got different results when using query_posts in functions.php and index.php
  52. Query posts by Author and/or by Tag
  53. Migrate posts from category and sub-category via SQL
  54. How do I insert a after every 5 posts in a WordPress Loop that infinitely loads posts?
  55. WP_Query: Show 10 posts in date order, first three random
  56. Exclude some posts from displaying in wp_query based on some condition
  57. WordPress Loop: How to display recent posts in multiple divs
  58. Random posts that always include a particular post?
  59. Conflict array_splice on loop and query in widget
  60. WP_Query of Category Not Showing First Post
  61. Update field in database for users
  62. Change content off every sixth element
  63. WP_Query get posts in custom database table [duplicate]
  64. WP query taxonomy optimization
  65. WordPress Query – Display 5 posts (same post type), each from a given tag
  66. While loop in functions.php outputting the_title() of each post on frontpage
  67. Show posts from two specific category in WP_Query
  68. How to create loop of posts except post ID defined via ACF field
  69. Displaying all posts from other sites on the network on one site
  70. blog post not accesible on click [closed]
  71. Multisite how to display merged posts from two sites and sort by latest date?
  72. a WordPress connected to 2 database
  73. Using a meta_value or postdate to to query and orderby
  74. Exclude posts in home slider from sections
  75. WP_Query that targets all categories
  76. Fill the exclude array() in get_posts()
  77. Double loop output
  78. Ajaxify Post Sort
  79. Category URL to use same string as Post URL Permalink
  80. Get current user, change users post status to published
  81. Displaying a specific sub-category’s posts from wp_query
  82. Custom layout manager for posts
  83. Display WordPress Post By Date
  84. GUID to related post not in current language
  85. Get results from the main wp_query
  86. How can I display a specific number of post in a category via a url
  87. Advanced Post Display/Pagination/Ordering
  88. Pagination for custom query won’t let me back on page 1
  89. Make assigning post to a specific category equivalent to assigning it to all categories
  90. WP_Query retrieve custom posts but not the post showing
  91. WP_Query based on a custom field result
  92. How to get single post by one author?
  93. List posts related to category on a div [closed]
  94. WP_query sort by custom meta_key “price”
  95. Wp_query WooCommerce products
  96. posts_per_page – Repeats only first posts ‘post__in’ array
  97. query_posts different amount of posts per page [duplicate]
  98. Add custom PHP (no-SQL) filter to WP_query
  99. date_query returning only the most recent post instead of the post published before today
  100. How to make WP_Query faster when getting a post from one year ago?