best way to store data from signature widget into mysql db

Ralph DiMola rdimola at evergreeninfo.net
Tue Aug 13 15:39:03 EDT 2019


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





More information about the use-livecode mailing list