Peter, I do this on my server. I keep the php on my server. Then I only have to allow access from "localhost' because the php is being run on the server. The php is accessed with "post" command from livecode. If you need an example, I can send you a sample stack, with some sample php. Bill
William Prothero http://es.earthednet.org > On Jan 7, 2016, at 9:34 AM, Peter Haworth <p...@lcsql.com> wrote: > > It seems that to access a mySQL database on my web host's servers from a > Livecode program, I have to configure "Allowable hosts" in the database > configuration. That can be an ip address or a domain name such as "@. > mydomain.com" > > The program in question will be used by perhaps a half dozen users, all > from their home computers and likely using different internet providers so > it appears every time I give the program to a new user, I will have to add > either their ip address (if it's fixed) or a domain as above. > > Is this common practice when accessing mySQL on a host server? If so, is > there a better way to set about accessing a mySQL database in these > circumstances, perhaps using php scripts on the server instead of accessing > the db directly with the LC database functions? > > Pete > lcSQL Software <http://www.lcsql.com> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode