How to display content from external db with relevant urls

Have a look at this question for a fairly simple solution.

Basically, create a plugin to contain your code, add a rewrite rule to intercept any requests that match your custom url, and parse or pass whatever data they contain to your plugin, which can then use those variables to produce whatever output you need.

I also suggest using the wpdb class to do your database queries.

Related Posts:

  1. get_results using wpdb
  2. Count & Display Database Queries
  3. Export wordpress table to excel
  4. How best to inject ads between posts in the loop?
  5. Change SQL get_results to search for posts with custom term in custom taxonomy
  6. Change all http to https in mysql databse?
  7. WooCommerce – Query for ordered products
  8. PHP variable in WordPress database query
  9. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  10. Query WordPress database by registered date and role
  11. How to fix unchanged URLs in Database after running serialized search and replace script?
  12. How to prevent WordPress from retrieving data for the last 10 posts in the database?
  13. Query from a different database than the default
  14. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  15. Select Multiple meta_value from WP DB; Single Query
  16. CRUD operations using WordPress database API
  17. Critical error in final stage of website launch – URLs are BROKEN!
  18. Hook directly into query execution
  19. Advanced SELECT query with condtional statements
  20. Select two sums with single get_var statement
  21. Replace/Mute/Stop Search Query
  22. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  23. wp search-replace (not executing)
  24. cache specific data?
  25. How Can I Put Meta_Compare in the Database-Query?
  26. How to paginate information obtained from a query to a custom table?
  27. Historic WordPress database connection
  28. Check if an option exists and get its value in one hit
  29. WordPress site URL changed; how to fix it without database access?
  30. Query multiple tables at once?
  31. $wpdb->query can’t insert data
  32. Custom WordPress Table wpdb
  33. Best practice to limit results in get_row()?
  34. Connecting to a different database
  35. SQL query to set posts in bulk based on the post content
  36. Query Column of Specific ID from Database Table
  37. Custom search query by category id
  38. How to display data from db in select list [closed]
  39. How can I query the db to access current post information?
  40. Compare User meta_value with Product meta_value
  41. How to insert a value to decimal type field using wpdb->prepare?
  42. Join Query on WP_USERMETA Table
  43. Insert NULL value using prepare()
  44. Job and Employee Performance Tracking with Product Safety
  45. WordPress Database Query works in phpMyAdmin but not in the code
  46. wpdb query to insert images in to post/page gallery
  47. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  48. Performance bug – slow DB query
  49. How to optimise this database query?
  50. How can we speed up wp_get_nav_menu_items()?
  51. Extracted CSV as Array for Custom Query Loop
  52. Should I Use only wpdb Class to Write Custom Queries?
  53. Generating an HTML table from an array based on dynamic key values
  54. Moving Site: Is Re-downloading Files After Changing URLs necessary?
  55. Pulling values from a sepcific row in table
  56. Using class id from array for query
  57. Update references to pictures on website after moving to new URL
  58. database search feature
  59. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  60. SQL query to rewrite all media URLs to end with .webp
  61. How do I find users by password?
  62. Display custom data based on URL slug
  63. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  64. Oracle SQL query for Date format
  65. Using wpdb to connect to a separate database
  66. Database connection close
  67. Importing posts from old website to new conflicting post ID’s?
  68. Exporting revisions
  69. How to use multiple database in wordpress?
  70. Is removing orphaned wp_postmeta records safe?
  71. What ALL can cause “Another update is currently in progress.”? [closed]
  72. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  73. Trigger Plugin database update after git pull
  74. Query string parameters from custom fields, inconsistent results
  75. SQL Error wp_commentmeta – incorrect table definition
  76. Change WordPress prefix for only one table?
  77. Two websites one database, administrator not working on second website
  78. How to get the SQL of the changes made to the database from an update or upgrade?
  79. How can i add custom fields into the contact form 7 [closed]
  80. WordPress and a secondary database?
  81. Remove empty rows from the database
  82. Check if post id exist in table than only update instead of inserting new row
  83. Detail explanation of wordpress database fields and metatag list [closed]
  84. After database migration, theme mods don’t show [closed]
  85. Remote database connection and local development
  86. Website displays old version of page
  87. A change in URL slug in database returns 404, how can I do auto-redirect?
  88. Displaying table data on a page
  89. muliple wordpress installs (network) on different databases
  90. Whats the best practise on how to store json data from a custom settings page?
  91. Recovery – Restore Database after moving folder location locally
  92. How to optimize wp_option table?
  93. Database for JQuery Autocomplete field
  94. Catchable fatal error in formatting.php
  95. Wrong url for the images while using same database for two WordPress installations
  96. Sending WordPress database information to cross domain the safe way?
  97. How can i maintain permalink structure and avoid a 404 error when loading external content?
  98. Attach posts based on category and position
  99. wp-config was suddenly updated
  100. Weird WP -Cli Error Connection Refused