troubleshooting Question

Recommendations on allowing other websites access to mySQL database

Avatar of jimdgar2
jimdgar2Flag for United States of America asked on
Web ServicesWeb Development SoftwareWeb Frameworks
1 Comment1 Solution406 ViewsLast Modified:
I would like some advice on how to best solve the following issue.

I have a web site which displays data based on search criteria. The data is extracted from a mySQL database on a hosted server. As long as it's my web domain displaying the data there are no problems.

But, I now have clients who want to have this search engine reside on a web page in their domain and extract data from my database. This raises these problems (that I can think of): 1) I would have to provide them a password into the database, 2) they would have to maintain the code and mirror any updates/changes I make.

The best solution for me is to have them put a link on their page which (discreetly) directs users to my page. I display the data and then provide a link back to the client's page. I could then maintain/control everything. The downside is that my web page won't look like theirs and users may be bothered by the discontinuity (if they notice).

Someone suggested using an iframe, but I'm not sure if this would work or be the best solution.

Thanks for any suggestions.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros