3v4l.org

run code in 300+ PHP versions simultaneously
<?php $query = "UPDATE `benefits` SET `ins_d`='6' WHERE `ben_id`='1' OR `patient_id`='1' LIMIT 0,1"; $sql_operators_arr = array("SET", "VALUES", "FROM", "WHERE", "LEFT JOIN", "RIGHT JOIN", "INNER JOIN", "OUTER JOIN", "JOIN", "GROUP BY", "ORDER BY", "LIMIT", "AND", "OR"); $vals = ""; foreach ($sql_operators_arr AS $val) { $re = "/(.*?)( )*(" . $val . ")(.*)/"; $subst = "$1\n$2$3$4"; $query = preg_replace($re,$subst,$query); } echo $query;
Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 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.6
UPDATE `benefits` SET `ins_d`='6' WHERE `ben_id`='1' OR `patient_id`='1' LIMIT 0,1
preferences:
243.66 ms | 404 KiB | 317 Q