- var_dump: documentation ( source)
- json_decode: documentation ( source)
<?php
$json = <<< 'JSON'
{"main_sql":"select now(), col2, col3 as col3$_key_ , round(sum(col4)/%placeholder1%) as f_sum_col4$_key2, round((sum(col5)/%placeholder1%/1000000)*8) as f_sum_col5$_key3 from table1 where col6 != 'string1' and col8 NOT like '%STRING2%' and col9 like '%STRING3%' and col7 > %placeholder1% group by col2, col3 having ((sum(col4)/%placeholder1%) > 100000) or ((sum(col5)/%placeholder1%/1000000)*8) > 1000 order by f_sum_col5$_key3 DESC limit 100 "}
JSON;
var_dump(json_decode($json, true));