@ 2017-05-26T16:24:17Z <?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);
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
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:dark mode live preview
160.97 ms | 403 KiB | 173 Q