Access Database from multiple sites

  • Resolved gracedman

    (@gracedman)


    1 year, 6 months ago

    Many of our volunteer organizations in different countries are now setting up their own WordPress sites but we all need to use the same Participants Database data. Is it possible to have multiple sites looking at the same database?

    I’ve looked at the WordPress documentation but that seems to be about sharing the entire database. That’s not for us as these are all independent sites.

    I looked at using the API but we really want the entire front end available on the individual sites.

    Is there a way to do this directly in Participant’s database? If not, has anyone done this trying to replicate the tables? Worse comes to worst, we’ll use a frame or even just a link. Thanks

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author xnau webdesign

    (@xnau)

    This is possible in theory, but not something I’ve tried. A skilled WordPress developer could manage it, but otherwise…not really possible.

    Another approach would be to synchronize the databases for each site in the server with a special setup. This is for a skilled developer to do, or possibly your hostimg provider can set this up. It’s very likely all the sites would have to be on the same hosting account for this to work.

    Thread Starter gracedman

    (@gracedman)

    Hi, Roland. As expected, we could not set up database replication on shared web servers so we went the iFrame route. It is mostly working but we found that the “action” parameter has problems. Initially, we had a two page form so used the action parameter to send users to the second page but the second page would not display so we made it a single page form. However, we want to send users to a different Thank You page, one that does not have headers, footers, and menus so better for the iFrame.
    Interestingly, the page specified in the action parameter does not display in the iFrame (it is empty) and none of the notification or thank you emails are sent but we do see the entry in the database. If I used the exact same page on the local site and thus not in an iFrame, it works as expected. Any idea what is happening and how we fix it? I did try using a full URI, i.e., including the site URL, as the action but that did not help. Thanks.

    Thread Starter gracedman

    (@gracedman)

    I found that if I checked Use Alternate Session Method under Advanced Settings, it works. Thanks for a great plugin.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Access Database from multiple sites’ is closed to new replies.