<?php
$rows = [
['id' => 1, 'name' => 'foo', 'year' => 2017, 'month' => 1, 'value' => 'bar1'],
['id' => 2, 'name' => 'foo', 'year' => 2017, 'month' => 2, 'value' => 'bar2'],
['id' => 3, 'name' => 'foo', 'year' => 2017, 'month' => 3, 'value' => 'bar3'],
['id' => 4, 'name' => 'foo', 'year' => 2017, 'month' => 4, 'value' => 'bar4'],
];
$data = [];
foreach($rows as $row) {
$key = $row['name'] . '_' . $row['year'];
if(!isset($data[$key])){
$data[$key] = array(
'id' => $row['id'],
'name' => $row['name'],
'year' => $row['year'],
);
}
$month = 'month' . $row['month'];
$data[$key][$month] = $row['value'];
}
print_r($data);
- Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 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.19, 8.3.0 - 8.3.7
- Array
(
[foo_2017] => Array
(
[id] => 1
[name] => foo
[year] => 2017
[month1] => bar1
[month2] => bar2
[month3] => bar3
[month4] => bar4
)
)
- 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/KvCD5 on line 3
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/KvCD5 on line 3
Process exited with code 255. - Output for 4.3.2 - 4.3.4
- Parse error: parse error in /in/KvCD5 on line 3
Process exited with code 255.
preferences:
216.23 ms | 401 KiB | 466 Q