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.