Create PHP script that will convert MySQL array to JSON formatted needed.
Simple and quick project, I need to convert a MySQL array to JSON formatted as specified.
MySQL Array example :
[{"campaign_id":"4","variant_id":"6","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"7","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"11","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"12","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"13","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"15","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"17","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"4","variant_id":"25","triggers":"{"frequency":"168","exit":"standard","scroll":"100"}"},{"campaign_id":"16","variant_id":"31","triggers":"{"frequency":"72","exit":"standard","scroll":"100"}"},{"campaign_id":"17","variant_id":"32","triggers":"{"frequency":"72","pages":"6","scroll":"75"}"}]
Result Formatted needed:
{
"campaigns": [{
"campaign_1": {
"variant_1": { "scrollConfig": true, "scroll_val": 50, "exit": true },
"variant_2": { "scrollConfig": true, "scroll_val": 50, "exit": true }
},
"campaign_2": {
"variant_1": { "specificPage": true, "page": "[login to view URL]" },
"variant_2": { "specificPage": true, "page": "[login to view URL]" }
},
"campaign_3": {
"variant_1": { "pageCount": true, "count": "3" }
},
"campaign_4": {
"variant_1": { "timedCount": true, "timer": 30 },
"variant_2": { "timedCount": true, "timer": 30 }
}
}]
}