This plugin hasn’t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

Link Data From Another DB

Description

Link data from another database is a plugin that allows your WP users to display user selectable content from a MySQL database. The Admin will set up the SQL query and the User can select results from the query. This plugin was originally created for a real estate website to allow Users to display their properties within their WP author page.

Future ToDos

  1. Add a shortcode method to display looped data, configured by the Admin

Screenshots

  • Location - Manage your linked data
  • Tips Screen - Find useful tips and info
  • DB Config - Set up the second database config information
  • Query Generator - Use this Generator for single queries
  • Manual Generator - Use this Generator for complex queries including JOINs and SUBSELECTs
  • Options - Plugin options, permissions and text
  • Edit Profile - User can select results based on the Admin setup
  • Parse Code in Template - You then parse your data.
  • Parsed Code - Your parsed data displayed

Installation

  1. Upload the link-data-from-another-db folder to the /wp-content/plugins/ directory, or install from the repository
  2. Activate the plugin from the Plugin menu in WordPress
  3. In your Admin account Navigate to Users -> Link Data From DB
  4. Click on the DB Config tab and enter your Database Settings
  5. Click on the Generator or Manual tab to create your query
  6. Click on the Options tab and enter your permissions and other options
  7. Click on Update Options at the bottom
  8. In your template code, reference the plugin with MBlinkData() and parse your data (ex: http://pastie.org/8406961 )
  9. In a User account click on Your Profile
  10. Scroll down to Select Your Listings
  11. Select the results you want to show in your profile
  12. View your page

FAQ

  1. If you have any questions please ask at http://montanab.com/blog/wordpress-link-data-from-another-database/
  2. Want to say thanks? donate

Contributors & Developers

“Link Data From Another DB” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

  1. 0.1 Initial Development
  2. 0.1.0.2 minor text update and images
  3. 0.1.0.3 fixed jQuery and jQuery UI loader and initial tab views for clean installs
  4. 0.1.0.4 added uninstall code to clean the database of plugin entries
  5. 0.1.0.5 added WordPress compatibility and plugin branding
  6. 0.1.0.6 updated pluging description