<?php
$data = [
[
'blah' => 'reference',
],
[
'A' => 'SMI13',
'B' => '03/12/1940',
'C' => '',
]
];
foreach($data as &$record){
foreach($record as $key => &$val){
//you might want to consider using preg_replace_callback instead:
if(preg_match("/^(((0[13578]|1[02])\/(0[1-9]|[12]\d|3[01])\/((19|[2-9]\d)\d{2}))|((0[13456789]|1[012])\/(0[1-9]|[12]\d|30)\/((19|[2-9]\d)\d{2}))|(02\/(0[1-9]|1\d|2[0-8])\/((19|[2-9]\d)\d{2}))|(02\/29\/((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))))$/",$val)) {
echo "match! $val \n";
$record [$key] = date("Y-m-d", strtotime($val));
}
}
}
var_dump($data);
- Output for 5.6.38, 7.1.0 - 7.1.22, 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
- match! 03/12/1940
array(2) {
[0]=>
array(1) {
["blah"]=>
string(9) "reference"
}
[1]=>
&array(3) {
["A"]=>
string(5) "SMI13"
["B"]=>
string(10) "1940-03-12"
["C"]=>
&string(0) ""
}
}
- 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
match! 03/12/1940
array(2) {
[0]=>
array(1) {
["blah"]=>
string(9) "reference"
}
[1]=>
&array(3) {
["A"]=>
string(5) "SMI13"
["B"]=>
string(10) "1940-03-12"
["C"]=>
&string(0) ""
}
}
preferences:
163.13 ms | 402 KiB | 172 Q