Create JSON data from PHP MYSQL

Suite and Optimus Suite 5
#1

Hi,

I am shifting from XML to JSON.

Is there a way/example that i can create DHTMLX GRID JSON data from PHP MYSQL.

Regards.

Ndegwa

#2

You can use connectors, similar as for XML.
On server side - use JSONDataConnector

docs.dhtmlx.com/connector__php__ … ector.html

on client-side

#3

You can use Fractal library and create your own transformer.

I am currently experimenting with dhtmlx grid and created dhtmlx transformer converting Laravel models to json streams in a form dxdmlx grid can understand.

Did one Transformer class and one Serializer class. Total of about 20lines of PHP and works like charm