将此值拆分为插入查询的一部分

Question

Is there any way to achieve the following? I need to take this $query and split it into its various elements (the reason is because I am having to reprocess an insert query). As you can see this will work for regular string blocks or numbers, but not where a number, occurs in the string. Is there a way to say |\d but not where that \d occurs within a ' quoted string '?

$query = "('this is\'nt very, funny (I dont think)','is it',12345,'nope','like with 2,4,6')";

$matches = preg_split("#',|\d,#",substr($query,1,-1));

echo $query;   
print'<pre>[';print_r($matches);print']</pre>';

So just to be clear about expected results:

0:'this is\'nt very, funny (I dont think)'
1:'it is'
2:12345
3:'nope'
4:'like with 2,4,6'.

** Additionally I don't mind if each string is not quoted - I can requote them myself.

Answer 1

Could (*SKIP)(*F) parts that are inside single quotes and match , outside:

'(?:\\'|[^'])*'(*SKIP)(*F)|,

(?:\\'|[^']) Inside the single quotes matches escaped \' or a character that is not a single quote.

See Test at regex101.com

$query = "('this is\'nt very, funny (I dont think)','is it',12345,'nope','like with 2,4,6')";

$matches = preg_split("~'(?:\\\\'|[^'])*'(*SKIP)(*F)|,~", substr($query,1,-1));

print_r($matches);

outputs to (test at eval.in)

Array
(
    [0] => 'this is\'nt very, funny (I dont think)'
    [1] => 'is it'
    [2] => 12345
    [3] => 'nope'
    [4] => 'like with 2,4,6'
)

Not absolutely sure, if that is what you mean :)