Fetch data from another site, but the same database

If you intend the process to be portable, then don’t use the database. Modify the theme to reply with either raw-html or php-serialized data and just do an http crossload.

If this is a one-time install and you don’t care at all about portability, then just hardcode the query.

I’ve done both at one point or the other, there isn’t much difference in implementation time. The queries occasionally have to be redone after an upgrade.

Related Posts:

  1. Copying database tables to new database
  2. Is it fine to have foreign key as primary key?
  3. Detecting errors generated by $wpdb->get_results()
  4. wpdb update add current timestamp not working
  5. Custom form that store input in database
  6. Restoring WordPress posts from database only
  7. Displaying content from one WP site on separate WP site
  8. Lost the `wp_options` table: what’s the best way to restore the site?
  9. Issue with wp_insert_post and post_content field error Could not update post in the database
  10. wp_posts – guid update
  11. Performance Gains of Relational DB Setup
  12. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  13. store simple data in get_option()
  14. How might I retrieve a featured post image from an external WP site and display it as a link back?
  15. What are conventions about the schema of the $table_prefix
  16. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  17. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  18. storing database in version control
  19. Is deleting orphaned wp_options entries safe?
  20. How to build a movie database with wordpress?
  21. What’s the most efficient database method to add and query usermeta?
  22. How to solve slow WordPress site caused by attachment_metadata
  23. Sub-domain or 2nd, temporary different domain?
  24. How do i get user data from a custom table in the wordpress database by user ID?
  25. Converting WordPress into Android or iPhone app
  26. Safe way to find last inserted id in a table?
  27. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  28. Database slowdown after update to 3.4.1
  29. WooCommerce sku location in DB
  30. How to insert data into MySQL database from the form created in WordPress site
  31. Emoji support and MariaDB 10.0.30-
  32. WordPress DATABASE Update Manually?
  33. Which is more efficient? Using usermeta, or creating a new MySQL table?
  34. Can I have multiple database users within WordPress?
  35. How do I copy a wordpress database?
  36. Export all content from wordpress
  37. Modify Database in Multi-Site wp_usermeta table
  38. Form Data not getting stored in WordPress database
  39. Hook directly into query execution
  40. Structure of postmeta meta_value for woocommerce product download
  41. $wpdb doesn’t like to store arrays
  42. Connect to a remote database for wordpress in my own hosting server
  43. WordPress ‘repairing database’ in a constant error loop?
  44. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  45. Importing CSV into database table not working?
  46. Check if an option exists and get its value in one hit
  47. Change options table prefix only
  48. Problems with moving my WordPress site to another domain/server
  49. Is it important to have integers inserted using %d rather than %s?
  50. Export a custom Mysql database product catalog to WordPress
  51. Any risk to changing WP table col CHARACTER_MAXIMUM_LENGTH?
  52. Global__r connection timed out
  53. Connect to database in the header of my WordPress website
  54. Should I store critical css in the database or in my theme’s filesystem?
  55. WordPress url transformation script
  56. Location of WP default mySQL tables creation file?
  57. Is it risky if I update all url in the database due to my site url changed?
  58. Select From wpdb – Author/User Directory page
  59. Just created a WordPress Table can’t get $wpdb get row to work – need help
  60. Need help fixing sql syntax error after WP 3.2 upgrade
  61. Need help with creating a searchable user data by name or specific number like ID
  62. $wpdb->insert not inserting all rows
  63. Intentionally corrupt WordPress database
  64. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  65. How can I find user role in Mysql?
  66. How would I see which wordpress posts have a revision history without opening each one?
  67. Creating a custom form with ability to query and submit to SQL
  68. Troubles when I want to connect to another DB
  69. Intermittent Yet Problematic Error – “Error Establishing A Database Connection”
  70. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  71. Featured image from custom to WordPress database
  72. WordPress Database Query works in phpMyAdmin but not in the code
  73. Error: SHOW FULL COLUMNS FROM `pt_participant`
  74. update to a new template without loosing any data
  75. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  76. How to save dropdown slection by a user in the DB
  77. Form display in new page
  78. Accessing Information From Vendor Database On The Basis Of Customer Query
  79. spambot registering without providing email or password, bypassing registration process
  80. Connection of mysql DB with wordpress
  81. Locally installing wordpress. Database problem
  82. I have my full special database from xampp how can i use this on wordpress?
  83. Halting data inserts for future refresh of post?
  84. Possible to restore wordpress database from mysql56 and sqlite files?
  85. Correct permissions for SQLite database
  86. Processing a lot of $wpdb isn’t insert all the data
  87. How do i get value from wp_postmeta?
  88. Local host to server import problem
  89. Restoring .sql backup results in “Error establishing a database connection”
  90. Link to handle $_GET request
  91. “MySQL server has gone away” since update to 3.8
  92. featured image not showing up with mysql_connect
  93. Getting deleted users in database
  94. Options of accessing wordpress data from mobile app
  95. Getting data from a table using a query
  96. Database interaction (private-public) [closed]
  97. SQL query to rewrite all media URLs to end with .webp
  98. Many images in wp-content/uploads folder that are not in Media Library
  99. Order of search results based off of a backend custom field and also in alpha order
  100. How to find fresh (last modified) and sql backup?