best way to store data from signature widget into mysql db

JJS jjs at krutt.org
Tue Aug 13 16:12:41 EDT 2019


Ok yes, i did not think about that.

Thanks Ralph for pointing me to that.

I will test it.


Kind regards,

Jerry

Op 13-8-2019 om 21:39 schreef Ralph DiMola via use-livecode:
> If everything is in an array then "arrayEncode" the array and store it in a db. Then arrayDecode it when retrieving it from the DB. You may also have to base64Encode/base64Decode to eliminate any binary.
>
> Ex: (not tested)
> Put Base64Encode(arrayEncode(sigArray)) into DBdata
> Put arrayDecode(Base64Decode(DBdata)) into sigArray
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdimola at evergreeninfo.net
>
> -----Original Message-----
> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf Of JJS via use-livecode
> Sent: Tuesday, August 13, 2019 3:23 PM
> To: How to use LiveCode
> Cc: JJS
> Subject: best way to store data from signature widget into mysql db
>
> Hi,
>
>
> i was wondering what the best way would be to store a signature of the signature widget into mysql db, so i can recall it.
>
> 1. figure out how many keys/elements there are in the array, as  it will be different per signature (serialize it as a single string, or create a JSON and store it directly)
>
> or
>
> 2. is it possible to export the signature, which probably is an svg, to an jpg/png so i can store it as BLOB?
>
>
> thanks for any insights.
>
>
> Regards,
>
> Jerry
>
>
> _______________________________________________
> 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




More information about the Use-livecode mailing list