We help IT Professionals succeed at work.
Get Started

Recommendations on allowing other websites access to mySQL database

Last Modified: 2012-05-11
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.
Watch Question
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE