Is it possible to query from external database? [duplicate]

You can use wpdb to setup a new connection.

Add something similar to this below in your functions.php and you can then query just like you would normally but using the new connection.

$second_db = new wpdb(DB_USER, DB_PASSWORD, $database_name, DB_HOST);
$results = $second_db->get_results($your_query);

references:

https://wordpress.stackexchange.com/a/1673/86845

https://stackoverflow.com/a/36759606/3204142

Related Posts:

  1. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  2. How to make an activities stream mixing posts and comments?
  3. What is an efficient way to query based on post_meta?
  4. SQL query equivalent to WP User Query
  5. how to retrieve specific product attribute value in an sql query?
  6. WP_Query Performance Issues with meta_query
  7. Get the post permalink within the loop but without additional DB query
  8. Filter WordPress posts by between parameter
  9. How to correctly pass values to wpdb->prepare()?
  10. List of the years with posts presented
  11. Optional Meta Query
  12. Editing the default wordpress search
  13. WP Query related posts by tags
  14. Order by summing multiple values
  15. Include data from custom table in WP_Query
  16. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  17. List of ways to access WordPress database?
  18. How to set up hierarchical relationships without using plugins / meta query
  19. Query where ANDing slug values not working
  20. Slow Query On Search
  21. How to SQL query posts IDs by categories AND authors?
  22. Any way to use FETCH_KEY_PAIR with $wpdb?
  23. How to get meta key list efficiently?
  24. Translating WP query into to SQL query
  25. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  26. Include post_status check within $wpdb query
  27. wpdb get_results() returns only 2 rows
  28. WP_Query always returning the last custom post
  29. When should you use WP_Query vs query_posts() vs get_posts()?
  30. Pagination with custom SQL query
  31. How to query for most viewed posts and show top 5
  32. Using OR conditions in meta_query for query_posts argument
  33. Add indexing to meta_value in wp_postmeta
  34. Custom WP_Query order by post_meta and (author) user_meta
  35. WP_Query for WooCommerce Products
  36. Get posts by menu ID
  37. Slow SQL_CALC_FOUND_ROWS Query
  38. Export wordpress table to excel
  39. Perform query with meta_value date
  40. Recommended way to drop a pending query (in pre_get_posts)?
  41. Change SQL get_results to search for posts with custom term in custom taxonomy
  42. How to find if a post with custom_field == X exists?
  43. WP_query category__in not working, only pulls from first category
  44. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  45. SQL User Query by Multiple Roles using PHP
  46. Query WordPress database by registered date and role
  47. What’s faster? One big query, or several smaller ones?
  48. Meta Query for specific months
  49. Different string for specifed post type on posts listing at homepage
  50. if/else on custom query gives 200 OK when condition not met?
  51. Select from wp_post and multiple meta_value from wp_postmeta
  52. Order by custom table and multiplication
  53. Sort users by “birthday” using WP_User_Query
  54. only delete post within query / for each statement (front end)
  55. unable to retrive parent page information
  56. How to detect if query is runned from widget?
  57. Show all data in database table and make it into an interactive table
  58. How to get list of posts from permalinks?
  59. database query with more than a couple meta hangs and doesn’t complete
  60. Check return value of get_posts
  61. Transient api Caches confused
  62. How can I override one post and make it display content for another post?
  63. Debugging wp_query orderby for taxonomy
  64. Get a list of posts by specific category
  65. How to check the array values, what WP_Query has brought to me?
  66. How to add custom meta to ‘pre_get_terms’?
  67. Shortcode for custom query not returning results when attributes are added
  68. Using Transients
  69. Should I reset $wp_query?
  70. how to write wordpress query for multiple metakeys checking?
  71. Get specific ACF key and value from all posts – no access to DB
  72. Randomly select one of last 3 posts
  73. How to display data from db in select list [closed]
  74. I am officially missing something about transient posts
  75. Start Query from 2nd Post without offset
  76. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  77. How Can I Always Display A Particular Post First Using WP_Query?
  78. WP_Query() not working as expected
  79. How to query users by post count no less than 10
  80. WP_Query about meta_key and its array value
  81. Create global array to compare inside a query
  82. Ignoring ‘a’ when sorting posts
  83. direct query to post_meta table
  84. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  85. Filter posts/pages by user_role array
  86. Optimising amount of calls to custom fields
  87. WP Query to order posts by multiple meta fields
  88. add_query_vars does not work
  89. Retrieve posts in custom post type and specific taxonomies
  90. WP_Query with several meta_query-statements and order by meta_value
  91. Custom post types loop on a page template
  92. Parsing External Table Arguments
  93. difference between methods of query
  94. wpdb LIKE request shows all database data
  95. Query posts by meta value and sort by another meta key
  96. how to use transient method?
  97. Custom WP_query in Jnews theme returns thousands of posts
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. How to use meta_query to retrieve posts from multiple custom post type
  100. Rewrite URL custom search query