Livecode HTML5 and SQL

[Devin Asay]

That’s good to know, Matthias. So it seems that what you’d have to do is, still do the MySQL I/O in LC Server scripts, but also dynamically construct the HTML output in your LC server scripts, so that the calling HTML5 app could make sense of it. 

Am I interpreting the situation correctly, Matthias?

Devin


> On Apr 29, 2020, at 12:13 PM, matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> I was also thinking about using LC Server or PHP scripts, but if i understand it correctly then  "put URL" or "POST.. to URL" aren't  currently supported in the LC HTML5 engine.
> Only "load URL" is supported and only for http / https.
> 
> Matthias
> 
> 
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
> 
>> Am 29.04.2020 um 20:06 schrieb Devin Asay via use-livecode <use-livecode at lists.runrev.com>:
>> 
>> Colin,
>> 
>> I haven’t tried it myself, but I would think you’d have to write an API layer using LiveCode Server scripting. All of the MySQL reads and writes would take place in your .lc scripts on LC Server. Then it would be simple, RESTful http calls from your HTML5 app. Of course, this all depends upon whether the internet libraries have been ported over to the HTML5 platform. LiveCode Server—I’ve done lots. HTML5 deployment, almost none.
>> 
>> Hope this helps.
>> 
>> Devin
>> 
>> 
>>> On Apr 29, 2020, at 9:49 AM, Colin Kelly via use-livecode <use-livecode at lists.runrev.com> wrote:
>>> 
>>> Anyone got any insightful ways of READING/WRITING to a mySQL table using web-apps developed with Livecode HTML5?
>>> 
>>> 
>>> 
>>> Thanks
>>> 
>>> Col.
>>> 
>>> 
>>> 
>>> -- 
>>> 
>>> Colin Kelly
>>> 
>>> M 07951 920680
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> 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
>> 
>> Devin Asay
>> Director
>> Office of Digital Humanities
>> Brigham Young University
>> 
>> _______________________________________________
>> 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

Devin Asay
Director
Office of Digital Humanities
Brigham Young University