mySQL Host access

[Mike Bonner]

I wonder if Andres Dblib could be modified so that it could be used on both
ends.  On the client side, use the where, columns etc functionality to
build up an array, (dbA) encode it, and post it to a page where its
decoded, copied to the dbA variable (after you "start using.." andres
stack) and then its a single call to interact with the database. (ok so a
bit more complicated, you'd have to set the default connection, and pass in
whethere you were doing an insert, update, or whatever) but overall I think
it would be do-able. (and there is a gpl version of the library)  It would
just have to be modded to handle the arrayencode, and posting.  And
decoding on the far side.

On Thu, Jan 7, 2016 at 12:15 PM, Peter Haworth <pete at lcsql.com> wrote:

> Thanks Matthias, definitely seems like php on the server is the way to go.
> I guess designing the interface protocol between the LC app and the php
> scripts is my next step.
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
> On Thu, Jan 7, 2016 at 10:17 AM, Matthias Rebbe | M-R-D <
> matthias_livecode_150811 at m-r-d.de> wrote:
>
> >
> >
> > > Am 07.01.2016 um 18:34 schrieb Peter Haworth <pete at lcsql.com>:
> > >
> > > 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”
> > >
> >
> > if i remember right you could use %.%.%.% instead of the ip address to
> > allow all ip addresses to remotely connect to the MySQL DB.
> > But i wouldn´t do that. I would create a php or lc script on the server
> > which makes all the communication with the MySQL db and then let the
> > Desktop App call the php/lc file on the server. The php/lc file would
> then
> > return the needed data to the Desktop App.
> >
> > It´s much safer then to allow remote connections to the MySQL DB.
> >
> > Matthias
> >
> > > 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>