you could create a script in php that queries your database on each page load. we did something similar for a client where we created a textads script that he has people run ads on their websites. each time a page is loaded on the client website, it queries OUR client's database for teh correct ad info and updates it accordingly.. so what you wanna do is fairly simple.... I could write the code for you, for a price, or you might be able to find something on a script search...
Yeah but that isnt a problem, no one has to know your user name and password. it's set up in a configuration file that no one ever sees. no one will need to know anything other than enough html to copy and paste the html code you give them to run on their website..
everything else would be handled on your website, provided your webhosting can manage php and mysql...
not a problem.
the scripts themselves would be about 2,000 lines of code more or less, which would run on your server under your control. the only thing your affiliates would need is a block of html code to insert into their webpages (about 10 lines of html more or less) and would have ZERO access to any sensitive information..
Everytime you update your plans, have a script to update a text file in you ftp part of your site, or a text file anywhere really. The included script for external site would simple open that file in and print out the data through the browser. This way, no one at all externally can be on the db.
As far as external entry no way is safe, even having a site at all on the net But, that is something you can use without at thrills through the grant priveledges. Would be basic and wouldn't hurt, as those users couldn't do anything to the data anyhow...via insert,update,delete or dump calls, as you would limit them to one table with only select priveledges.
and save this in a called i.js file in the same directory as the html:
document.write("<b> This is great </b> <br>")
document.write("<b> and so is this </b> <br>")
Of course this does require that your affiliates' website visitors have js enabled browsers.
foogee, your method requires the js file to be in the same directory as the html code. this way, i cannot retrieve generate the data in the js file.
the solution i'm looking for as follows:
- affiliate copy and paste html/js code in his website.
- that code will remotely retrieve prices from my msyql db
- hence, everytime i change the prices, the affiliate need not make any change to the code since the prices will be retrieved from my db.