我有一个这样的字符串 -
我试过使用explode,但它不起作用:
$str = "field1.id as field1,
DATE_SUB(field2, INTERVAL (DAYOFMONTH(field2)-1) DAY) as field2,
field3.name as field3";
需要用,
将其拆分为数组,如下所示:
$requiredArray = array(
0 => field1.id as field1,
1 => DATE_SUB(field2, INTERVAL (DAYOFMONTH(field2)-1) DAY) as field2
2 => field3.name as field3
);
我试过使用explode,但它不起作用:
$requiredArray = explode(', ', $str);
// doesn't work as "DATE_SUB(field2, INTERVAL ..." also gets exploded
有什么技巧/想法吗?
preg_match_all('#\(.*?\)|[^,]+#', $str, $matches); var_dump($matches[0]);
的方式实现。 - Mark Baker