How to implement content from external database into WordPress text page? [closed]
You should write a plugin, or compact the code needed for this in a child theme functions.php
.
About pulling data from external databases: the simplest way is to use php built-in functions.
I would proceed this way:
- Register a shortcode to place your table wherever you want in WordPress, you probably want to pass some values, to select the specific data you want to pull from the database or the look the table should have
- Hook the shortcode to a function, that connects to the external db and queries it, according to your needs, builds a table using the data and outputs it.
Resources:
WordPress Shortcodes,
Html table output via php
Related Posts:
- MySQL Database User: Which Privileges are needed?
- Database synchronization between dev/staging and production
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- Safest way to bulk delete post revisions
- How can I make a WordPress database portable and url independent?
- Why does $wpdb return strings for mysql integer values?
- Dealing with Many Meta Values, 30+
- When is it appropriate to create a new table in the WordPress database?
- Is it possible to switch the data layer within WordPress?
- store simple data in get_option()
- How to delete outdated, wrongly sized images in _wp_attachment_metadata?
- Have multiple local wordpress installs share a wp-content folder and database
- Cloning and syncing a WordPress website
- What actions affect files, DB, or both?
- Add search Value to wp_list_table pagination
- How to fix unchanged URLs in Database after running serialized search and replace script?
- Merging WordPress posts from different databases
- Should non-WordPress data get its own DB?
- Who is responsible for data sanitization in WordPress development?
- Search and replace special characters (å,ä,ö) for image attachments only in database
- Localhost to Staging to Development Dynamic WP-CONFIG
- Setup 3 Sites To Connect To 1 Database and Share Data
- Uknown meta entries in wp_postmeta
- creating new field on mysql
- Why user_pass column in wp_users table is varchar(64)
- Can local WordPress installs share /wp-content/ folder and database?
- Delete/Replace words from X to Y in post content
- SymmetricDS in dev + prod workflow?
- A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
- WPCLI search and replace in a particlar site dir effect another site-dir
- Merging development site with live site
- One WP Database outside localhost and two connections
- Get id from database
- Share WordPress Database
- MySQL Database User: Which Privileges are needed?
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Oracle SQL query for Date format
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- Database connection close
- How to create bulk page and content? [closed]
- Importing posts from old website to new conflicting post ID’s?
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- WordPress for a very large website
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- Retrieve and display data from custom db table in admin area?
- How to execute mulitple statement SQL queries using $wpdb->query?
- Store and Encrypt Contact Form 7 Submissions in Database? [closed]
- Clean database from unused tables
- How wordpress accesses its own database
- Using table lock with wp_insert_post?
- Migrating database / content of non-CMS site to WordPress
- Should I remove transients from the wp_options table?
- Show last modified date of database
- What generates these very slow postmeta queries? [closed]
- How to migrate a website based on a custom database to wordpress?
- How to scan barcode and store data into a database [closed]
- Fetching values from database for select box
- WP CLI Core install – blank database
- fastest replacement DB
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- When to use custom DB tables or add_option?
- Have working sql query… trying to adjust it to use $wpdb
- Best host for running large mem and processor intensive WordPress sites?
- Strange characters added to the database
- Database Update Required – Update from command-line
- After database migration, theme mods don’t show [closed]
- Custom search query by category id
- Website displays old version of page
- Image link issues after importing a database backup to my local web server
- multiple wordpress installs w/shared user database but separate content databases
- Updating seperate database when post attachment is changed
- add featured image dialog box disappear
- Displaying table data on a page
- WordPress Database – wp_usermeta and the correct number of session_tokens rows
- How to get a list of articles related to a particular category from my other WordPress website?
- Whats the best practise on how to store json data from a custom settings page?
- /wp-admin not accessible after migrating to local host (no plugin issue)
- set_transient fails if the value has more than 60.000 characters
- WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
- Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
- How to optimize wp_option table?
- How can I get $wpdb to show MySQL warnings?
- About wp database hooks (error establishing connection)
- Custom Form Input not saving to Database
- Database for JQuery Autocomplete field
- Create Tables in WordPress
- WordPress Failed to Login (DB Error)
- Check if values exists DB
- ERROR: “Table Prefix” must not be empty
- How do you build a database-centric site in WP?
- WordPress: Interact with Database Query Data and Login
- Attach posts based on category and position
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- wp-config was suddenly updated
- Changes to code not displaying
- Order of search results based off of a backend custom field and also in alpha order
- How to find fresh (last modified) and sql backup?