3v4l.org

run code in 300+ PHP versions simultaneously
<?php $pattern = "/(SELECT|FROM|WHERE|LEFT JOIN|ORDER BY)(.+?)(?= SELECT|FROM|WHERE|LEFT JOIN|ORDER BY|$)/im"; $sql = "Select id, nome FROM table as t WHERE t.id = 123 LEFT JOIN t2 ON t2.id = t.id ORDER BY t.name "; preg_match_all($pattern, $sql, $arr); var_dump($arr);
Output for 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.0 - 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(3) { [0]=> array(5) { [0]=> string(7) "Select " [1]=> string(16) "FROM table as t " [2]=> string(17) "WHERE t.id = 123 " [3]=> string(29) "LEFT JOIN t2 ON t2.id = t.id " [4]=> string(15) "ORDER BY t.name" } [1]=> array(5) { [0]=> string(6) "Select" [1]=> string(4) "FROM" [2]=> string(5) "WHERE" [3]=> string(9) "LEFT JOIN" [4]=> string(8) "ORDER BY" } [2]=> array(5) { [0]=> string(1) " " [1]=> string(12) " table as t " [2]=> string(12) " t.id = 123 " [3]=> string(20) " t2 ON t2.id = t.id " [4]=> string(7) " t.name" } }
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(3) { [0]=> array(5) { [0]=> string(7) "Select " [1]=> string(16) "FROM table as t " [2]=> string(17) "WHERE t.id = 123 " [3]=> string(29) "LEFT JOIN t2 ON t2.id = t.id " [4]=> string(15) "ORDER BY t.name" } [1]=> array(5) { [0]=> string(6) "Select" [1]=> string(4) "FROM" [2]=> string(5) "WHERE" [3]=> string(9) "LEFT JOIN" [4]=> string(8) "ORDER BY" } [2]=> array(5) { [0]=> string(1) " " [1]=> string(12) " table as t " [2]=> string(12) " t.id = 123 " [3]=> string(20) " t2 ON t2.id = t.id " [4]=> string(7) " t.name" } }

preferences:
160.97 ms | 403 KiB | 173 Q