<?php
//$regex = '/(?P<function_name>.*?)\s*\((?P<parameters>.*?)\)\s*/i';
$regex = '/(?P<function_name>.+)\s*\((?P<parameters>[^)]+)\s*/i';
//$regex = '/(?P<function_name>.+)\s*\((?P<parameters>.*?)\)\s*/i/';
preg_match($regex, 'HOUR(`date`, `abc1234`)', $matches);
print_r($matches);
$params = explode(',', $matches['parameters']);
$chars = array_fill(0, count($params), '` ');
print_r($params);
$params2 = array_map('trim', $params, $chars);
print_r($params2);
- Output for 4.3.3 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.38, 7.0.0 - 7.0.32, 7.1.0 - 7.1.25, 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.27, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- Array
(
[0] => HOUR(`date`, `abc1234`
[function_name] => HOUR
[1] => HOUR
[parameters] => `date`, `abc1234`
[2] => `date`, `abc1234`
)
Array
(
[0] => `date`
[1] => `abc1234`
)
Array
(
[0] => date
[1] => abc1234
)
- Output for 4.3.0 - 4.3.2
- Array
(
[0] => HOUR(`date`, `abc1234`
[1] => HOUR
[2] => `date`, `abc1234`
)
Notice: Undefined index: parameters in /in/eWng0 on line 13
Array
(
[0] =>
)
Array
(
[0] =>
)
preferences:
272.84 ms | 401 KiB | 423 Q