Link to home
Start Free TrialLog in
Avatar of jimdgar2
jimdgar2Flag for United States of America

asked on

Recommendations on allowing other websites access to mySQL database

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.
ASKER CERTIFIED SOLUTION
Avatar of TAOSA
TAOSA
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial