3v4l.org

run code in 300+ PHP versions simultaneously
<?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));
Output for 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.6 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
array(1) { ["main_sql"]=> string(431) "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 " }
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 array(1) { ["main_sql"]=> string(431) "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 " }

preferences:
148.52 ms | 403 KiB | 189 Q