MySQL json field

[igor]

Hi! Just trying Wappler for the 1st time and loving it so far. However, there is one feature that I can’t seem to get working. I have a MySQL database with some json fields in it. I would like to be able to use these fields as objects and update them. So far I am able to select the field but I can only get the output as a string.

Is there any way to maintain the json object or convert the string output to an object and back again to a string when updating?

[s.alpaslan]

good question…

[George]

That is a very good question, altought I think it can be already done, we were looking to implement this more natively, so that all conversion ms happen automatically.

Maybe @patrick can advise for current solution, I think it can be done with data formatters, that will handle the conversion.

[aschoijett]

Hi George,

Can you comment on this?

Many thanks,

Alex

[aschoijett]

Hi George,

Any thoughts on reviving this topic?

Many thanks,

Alex

[mebeingken]

Maybe this will help in the interim

Server Connect API that consumes JSON

Thanks for confirming ! My problem lied somewhere else after more troubleshooting. I wasn’t using the proper method to dump data into mysql. In case someone else runs into the same question… It’s as simple as setting a value in server connect to {{$_GET.stringify()}} or {{$_POST.stringify()}} And save it to a MySQL JSON field. Not sure if stringify() is shipped by default in wappler or if it was a custom formatter though. So just in case… <?php namespace lib\core; functi…

[aschoijett]

Thx Ken

[bpj]

Hi Alex,
Stringify would need to be a formatter (as Ken suggests through the linked post), just in case you have other uses for formatters, instructions to create your own can be found here:

Creating Custom Formatters (PHP and client-side)

I have been trying to supplement the native formatters in Wappler and found that most things can be added by using custom formatters. What I found, though was the technique for this was hidden in answers to specific questions so thought a short tutorial may help some: Server-side (php) In dmxConnectLib/lib/formatters create a file, call it something like customformatters.php (do not alter the native files as it could be overwritten with updates) Add the relevant code: the function name shoul…

[aschoijett]

Many thanks!