@ 2014-07-22T23:16:36Z <?php
function isQuotedString($token)
{
return in_array($token[0], array('"', "'")) && $token[0] == $token[strlen($token) - 1];
}
function getQueryTokens($query)
{
static $expr = '/("(?:[^"\\\\]*(?:\\\\.[^"\\\\]*)*)"|\'(?:[^\'\\\\]*(?:\\\\.[^\'\\\\]*)*)\')/';
$tokens = [];
foreach (preg_split($expr, $query, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY) as $token) {
if (isQuotedString($token)) {
$tokens[] = $token;
continue;
}
$tokens = array_merge($tokens, preg_split('/\?/', $token, -1, PREG_SPLIT_DELIM_CAPTURE));
}
return $tokens;
}
var_dump(getQueryTokens("SELECT * FROM foo WHERE 'a' = b AND f = ? AND q IN (?)"));
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 5.4.0 - 5.4.45 , 5.5.24 - 5.5.35 , 5.6.7 - 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 array(5) {
[0]=>
string(24) "SELECT * FROM foo WHERE "
[1]=>
string(3) "'a'"
[2]=>
string(13) " = b AND f = "
[3]=>
string(11) " AND q IN ("
[4]=>
string(1) ")"
}
Output for 4.4.2 - 4.4.9 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 Parse error: syntax error, unexpected '[' in /in/Wv2r9 on line 11
Process exited with code 255 . Output for 4.3.0 - 4.3.1 , 4.3.5 - 4.3.11 , 4.4.0 - 4.4.1 , 5.0.0 - 5.0.5 Parse error: parse error, unexpected '[' in /in/Wv2r9 on line 11
Process exited with code 255 . Output for 4.3.2 - 4.3.4 Parse error: parse error in /in/Wv2r9 on line 11
Process exited with code 255 . preferences:dark mode live preview
264.02 ms | 401 KiB | 359 Q