Livecode HTML5 and SQL

[Pi Digital]

Hi Colin

I have a library I’ve created for HTML5 and php for LiveCode Deployment. Pm me at sean at pidigital.co.uk

Sean Cole
Pi Digital Productions Ltd


eMail Ts & Cs


> On 29 Apr 2020, at 20:00, matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> If "post... to url" and "put URL..."  would work, then it should work with HTLM5.
> 
> But currently only load URL is supported.
> 
> But to be true, i am not sure about "load URL.."  
> I´ve used load URL only for downloading files in the past.  I am not sure if the command can also be used with parameters in the URL. But why shouldn't it work.
> 
> 
> I´ve did a quick test today without parameters in the URL  to just load an URL and display the returned data in a field.
> 
> This script
> 
> local tMyURL
> 
> on mouseup
> 
> put "start" into fld 1
> 
> put "https://www.google.com <https://www.google.com/>" into tMyUrl
> 
> load URL tMyUrl with message "myUrlDownloadFinished"
> 
> END MOUSEUP
> 
> 
> 
> on myUrlDownloadFinished
> 
> answer "Download Complete" &return &return &the cachedURLS with "Okay"
> 
> set the text of fld 1 to url tMyURL
> 
> end myUrlDownloadFinished
> 
> 
> 
> worked in the IDE, but not in HTML5. While "start" was displayed in field 1, the returned data of the cached URL wasn't.
> 
> But maybe i am missing something.
> 
> Matthias
> 
> 
> 
> 
>> Am 29.04.2020 um 20:19 schrieb Devin Asay via use-livecode <use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>>:
>> 
>> 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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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
> 
> 
> 
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
> 
> _______________________________________________
> 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