PHP填充数组空洞
我有一个数组，其中包含每年、每周存储的值，这些值来自我的数据库。结果可能如下所示：
Array
(
[2018] => Array
(
[40] => 1
[41] => 1
[47] => 1
[48] => 1
[52] => 1
)
[2019] => Array
(
[1] => 1
[2] => 1
[3] => 1
[4] => 1
)
)
or
Array
(
[2018] => Array
(
[48] => 1
[49] => 1
)
[2019] => Array
(
[3] => 1
[4] => 1
)
)
如您所见，有几周没有数据。我想填满数组，所以所有星期都在那里。以最后一个数组作为演示，期望的结果是：
Array
(
[2018] => Array
(
[40] => 1
[41] => 1
[42] => 0 < added
[43] => 0 < added
[44] => 0 < added
[45] => 0 < added
[46] => 0 < added
[47] => 1
[48] => 1
[49] => 0 < added
[50] => 0 < added
[51] => 0 < added
[52] => 1
)
[2019] => Array
(
[1] => 1
[2] => 1
[3] => 1
[4] => 1
)
)
Array
(
[2018] => Array
(
[48] => 1
[49] => 1
[50] => 0 < added
[51] => 0 < added
[52] => 0 < added
)
[2019] => Array
(
[1] => 1
[2] =>
[3] => 1
[4] => 1
)
)
所以，数组应该：
填补两个（不连续）数字之间的空洞
如果有下一年，则填充年份数组直到结束
如果有上一年且第一周没有数据，则填写新一年的第一周
我怎样才能做到这一点？
慕勒34288722回答
-
ABOUTYOU
我认为最有效的方法是使用联合运算符。这应该这样做： <?php $data = array( "2018"=> array( "40" => 1, "41" => 1, "47" => 1, "48" => 1, "52" => 1 ), "2019"=> array( "1" => 1, "2" => 1, "6" => 1, "7" => 1 ) ); foreach($data as $year=>$array){ $keys = array_keys($array); $min = min($keys); $max = 52; if(!isset($data[$year+1])){ $max = max($keys); } $data[$year] = $data[$year] + array_fill($min,$max-$min+1, 0); ksort($data[$year]); } print_r($data); ?>输出：Array( [2018] => Array ( [40] => 1 [41] => 1 [42] => 0 [43] => 0 [44] => 0 [45] => 0 [46] => 0 [47] => 1 [48] => 1 [49] => 0 [50] => 0 [51] => 0 [52] => 1 ) [2019] => Array ( [1] => 1 [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 1 [7] => 1 )) -
慕盖茨4494581
您可以使用一组数组函数，例如array_fill()和array_replace()来实现这一点。解释见评论$array = [ '2018' => [ '40' => 1, '41' => 1, '47' => 1, '48' => 1, '52' => 1 ], '2019' => [ '3' => 1, '4' => 1 ],];$result = []; // initialize result array$years = array_keys($array); // Get given years$first_year = min($years); // Get first year$last_year = max($years); // Get last yearforeach ($array as $year => $value) { // Loop thru each year array $weeks = array_keys($value); // Get weeks $start = 1; // Set first week $weeknum = 52; // Set number of weeks if ($year === $first_year) { // If first year, change number of weeks $start = min($weeks); $weeknum -= $start - 1; // number of weeks is 52 - the first week number - 1 } if ($year === $last_year) { // If last year, change number of weeks to last given week $weeknum = max($weeks); // Weeks will be 1 - last given week } $result[$year] = array_replace(array_fill($start, $weeknum, 0), $value);}var_dump($result);这样做的第一个目标是填充基于年份的数组。如果是第一年，则创建第一个给定周到第 52 周的数组如果是去年，则创建第 1 周到最后一周的数组如果在中间的某个地方，请创建第 1 周到第 52 周的数组然后用相同的键替换现有的数据数组
随时随地看视频慕课网APP
PHP