Searching an external database

  • Hello. My organization, the Tennessee Valley Interstellar Workshop (https://tviw.us) has a need to set up a search of an external MySQL database. This would be entirely separate from the internal WordPress database (we created the external database separately so it could be shared with other organizations). I know we could set up another instance of wpdb with the information for our external database, but I’m not familiar enough with WP Data Access to know if it would be possible to add access to an external database solely for the purposes of searching records and displaying the results. The database isn’t very complex; the searches would be fairly simple SQL queries.

    Is this something WP Data Access could be configured to do, use an external database rather than the internal one? If not, do you know of any other data search and display possibilities that could use an external database from within WordPress? Thanks for any information you can provide!

    We are using WP 5.3.0, soon to upgrade to 5.3.1.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 16 through 18 (of 18 total)

  • Hi Peter,

    I was able to resolve the permission issues and get the tables pushed through from the MySQL side. Rereading what you had described in earlier posts finally clicked for me. Your site videos are great.

    Kind regards,
    Kary

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Great Kary! ?? And thanks for the compliment!

    Best regards,
    Peter

    Hi Peter,<br />
    I installed the plugin, had a little ‘figuring out’ moment until I realized that the plugin requires full privileges for the user to connect remotely and managed to add the remote database table (I only need 1 table), but I have no idea how to allow a visitor to enter a search criteria in a form and display the search results on front end.<br />
    Does the plugin have easy option for me to create a form on front end where visitor can enter search number (Product Code) and display the search results?<br />
    If I can do this with the plugin please let me know where should I check the documentation for what I need or do I need to purchase the premium version?<br />
    Thanks,<br />
    Joseph

Viewing 3 replies - 16 through 18 (of 18 total)
  • The topic ‘Searching an external database’ is closed to new replies.