As @s_ha_dum mentioned in the comments, building an API or some sort of XML or JSON feed (or leveraging one that’s already there, or installing a plugin on whatever system that is, etc) is really your only way of getting at that data remotely. Once you get that going, you can use wp_remote_get to query the API.
To make this question a little more WordPress specific, let’s say you made a JSON feed at domain.com/games.json. In order to get it from within WordPress, you might do something like this:
$response = wp_remote_get( 'http://domain.com/games.json' );
if ( !is_wp_error( $response ) ) {
$data = json_decode( $response->body ) );
# Do something with $data
}
Related Posts:
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- WordPress not reflecting changed of the database
- How to return number of found rows from SELECT query
- How to check if image is already stored in a site’s post database? (network)
- Check if post of title already exists
- $wpdb->delete column values IN ARRAY()?
- How To Make Connection To WordPress Data Base In A Plugin?
- Changing user_nicename
- Does WordPress cache get_user_meta() results?
- WordPress will not operate correctly
- How to Join two tables from separate databases within WordPress
- error importing localhost export file to server
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- How to sort results from a custom database table
- How can I call a row of user specific data from a custom table added to the WP Database
- How to merge local and live databases?
- How to track a users progress through pages by inserting data into WordPress Database?
- Import 10,000 Users into WordPress WITH a specific ID for each user
- WP database error for comments_popup_link()
- if statement on database query
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- No wp-config.php file on local install of wordpress – site still displays
- How to create Sub Sub domain Multi User blogs?
- Different database query in function.php using mysqli
- How to create and work with custom data / tables (i.e., for arbitrary data)?
- Stumped on migration
- Create WP_Query to search for posts by their categories or their parent/child categories
- How can I save unique user data on my site? [closed]
- Update results, Before deleting the related category [closed]
- database sent to a JSON file
- inserting a post from an extern php file but post content doesn’t show on wp site
- new multisite, old db
- Using custom tables for old posts
- Not connecting to database in file with multiple MySQL connections
- Is it best to avoid using $wpdb for security issues?
- WordPress Block developer from exporting Database via PHP
- wpdb prepare insert table doesn’t work
- Should I use WordPress to skin a database website?
- Creating Database Table vs. Adding MetaData to Post & User
- WordPress and MySQL: trying to print data using PHP from user_meta custom field data
- Most commented posts by time period (last 12h, last 24h and etc)
- I can’t update my data through $wpdb
- Known Issues in WordPress When Upgrading PHP to ver 7
- Why when I create a new post I found 2 record related to this post into the posts database table?
- Adding data to custom wordpress database table
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Add row to custom database Table and delete all rows older than 1 day
- select a single val though a table in wordpress
- SQL error with custom query
- What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
- Please help! I have a problem with getting wordpress databas
- Error establishing a database connection (Set-up locally)
- PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
- Using wpdb to connect to a different database is not working
- Multiple WordPress sites with different theme and plugin sharing the same content
- Insert data from form to database
- can’t delete a row from post_meta table
- How to set max users to 17.000
- two wordpress sites, two themes, one database, same content
- Insert double entry in DB
- How to connect database table to each registered wordpress user.
- Let users register weight each day and save it in DB
- MySQL database migration to WordPress
- Host does not allow remote connection, so how do I transfer data to my WordPress site?
- Trying to post information from a remote database to wordpress page
- Custom query_posts() parameter
- How to pass username into form that sends data to database
- How to edit the default database of WordPress [closed]
- Display total count of products in orders of a specific order status
- Execute multiple PHP Snippets causes error?
- Custom form that stores data in mysql database
- Putting form result in my database
- Can’t insert into a database wordpress
- Query both first_name and last_name from wp_usermeta at the same time
- simple wordpress ajax plugin not working when not logged in
- Recent comments from my blogs only
- register_activation_hook isn’t adding table to DB
- How to generate page content from database the right way?
- Query String being Removed Creating a Pagination Issue within a Custom Plugin
- Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
- Converting MYSQL to WordPress $WPDB
- Why is the post meta[] empty when I make a call to the wordpress rest api?
- wordpress media library new uploads don’t write to database
- Split reads to a different connection string
- custom user role wordpress – grant guest access to edit.php without insert/update/delete
- Timthumb.php image gallery not working on Multisite WordPress
- Building a REST API for your web app exposes primary keys of DB records?
- WordPress low speed after migrating to new host
- Submiting with problems on one of the options php wprdpress
- Adding column to wpex_users
- Create form which redirects to site in network?
- Resource 404 error on multisite subdirectory install
- Conditional statement within WP SQL query
- WordPress upload images not displaying
- how to check for wordpress Query errors
- Check if values exists DB
- MySQL Engine vs. Charset
- Query Concatenation
- How to get the last date updated of postmeta?
- add_rewrite_rule image from /images/site2/favicon.ico to /favico.ico