skip to Main Content

How can I use DataTable and php?

I'm currently building a basic search utility for my site. However I'm stuck on DataTables and inserting php. At present, I have an array with simulated data (ie Title and Description), and at a later stage I'll replace the simulated…

VIEW QUESTION

Translate JSON TO TABLES using JSON TABLE and Nested Path

select JT.* FROM JSON_TABLE ('{ "general": { "product_key": "501088", "group_subtype_id": 1, "group_subtype_name": "Wheel Speed Sensor", "variant_id": 6, "variant_name": "DF22", "rb_customer_id": 287383 }, "partnumbers": [ { "partnumber": "F04FD009BD", "pn_type": "Series OEM", "mat_status": "00 - planned", "properties": [ {"property_id":4,"property_name":"ASIC P/N","value_id":38,"value":"8905502648"}, {"property_id":5,"property_name":"ASIC type","value_id":56,"value":"TLE4942"},…

VIEW QUESTION
Back To Top
Search