Tom and Peter: Also, please note that: Best practice involves NOT sending a complete query, which I use in the demo. It’s not so bad, since I require a password as a sent parameter, and since it is intended that the query be generated by livecode in a protected script (not in an input field that anybody can access). It’s not a horrible security issue, but easily breakable by someone monitoring wifi or other network traffic or using a keylogger, etc. But, for critical information, you should modify the php code to use placeholders for the sql parameters and use ssh protocols to send the commands. I will implement this at some time soon, but don’t have it now.
Glad to share when I get it done. Best, Bill > On Aug 11, 2015, at 11:54 AM, William Prothero <proth...@earthednet.org> > wrote: > > Tom and Peter: > Here is a link to a working stack, that includes the php scripts, so you can > see what’s involved. > https://www.dropbox.com/s/zeldbpafcnno3x5/Db Access.zip?dl=0 > <https://www.dropbox.com/s/zeldbpafcnno3x5/Db%20Access.zip?dl=0> > This link won’t last forever, so I’ll plan on keeping it active for a week. > Good luck, > Bill > >> On Aug 11, 2015, at 11:24 AM, tbodine <bod...@bodinetraininggames.com> wrote: >> >> Hi Bill. >> >> Thanks for those insights. I'm not sure which route I'll take yet, but I >> would welcome access to your php script collection. >> >> Thanks, >> Tom Bodine >> >> >> On 8/10/2015 8:12 PM, Wprothero [via Runtime Revolution] wrote: >>> Tom: >>> I use Navicat to manage my databases. It will access a variety of online >>> databases, and works with SQLite too. I use it all the time. >>> In my app work, I use livecode with POST commands to php that talks to >>> an online mySQL database. PHP is totally robust and won’t fail on you, >>> and it’s built into most Apache installations. On Mac, there is also a >>> great free tool called MAMP, which allows you to run a complete web >>> server with php on your local machine, for debugging. Again, Navicat is >>> your friend and will save you hours of wondering whether your data >>> actually got into the db or not. >>> >>> I read that storage of images in a mySQL database isn’t recommended. >>> But, I have stored them in SQLite db’s and it worked fine. Haven’t tried >>> it on mySQL. >>> >>> I will send you some php scripts, if you are interested. Contact me >>> offline. >>> Best, >>> Bill >> ============================================= >> >> *Bodine Training Games LLC* >> >> 8417 Hallet St., Lenexa, KS 66215 USA >> >> www.bodinetraininggames.com / 913-492-7709 >> >> >> >> >> >> -- >> View this message in context: >> http://runtime-revolution.278305.n4.nabble.com/Choosing-a-database-and-LC-tools-tp4694777p4694819.html >> Sent from the Revolution - User mailing list archive at Nabble.com. >> _______________________________________________ >> 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 _______________________________________________ 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
