Adding MySQL functions when saving data

megana 18 Aug, 2020
Is it possible to apply MySQL functions when saving data to a database?

For example, in my Save Data function I have added a data override for "comments" with the value: AES_ENCRYPT('{data:comments}', 'mykey')

But when I look at the debug info, this is what it the query ends up looking like:
INSERT INTO `mytable` (`id`, `comments`)  values  ('', 'AES_ENCRYPT('test comment', 'mykey')');
I could just write it with custom code, but that's what I've been doing with v5 so I was hoping v6 would have a better way.

I appreciate any advice!
megana 28 Aug, 2020
Well, I ended up just writing the query manually in a PHP function, but if anyone figures out how to do this type of thing without having to write custom code, let me know please!
This topic is locked and no more replies can be posted.

VPS & Email Hosting 20% discount
hostinger