在PHP中获取两个日期之间每月的所有日期

Question

我如何在数组中获取两个日期之间每个月的所有天数，格式如下：

$dateStart = "2016/12/14"; 
$dateFin =   "2017/04/21"

[2016/12/14 - 2016/12/31] => 17 days
[2017/01/01 - 2017/01/31] => 31 days
[2017/02/01 - 2017/02/28] => 28 days
[2017/03/01 - 2017/03/30] => 31 days
[2017/04/01 - 2017/04/21] => 21 days

- Younes Zaidi

Answer 1

你可以使用函数cal_days_in_month和DateTime类来实现，具体操作如下：

<?php
$dateStart = new DateTime("2016/12/14");
$dateFin = new DateTime("2017/04/21");
$firstDay = $dateStart->format('Y/m/d');
$lastDay = $dateStart->format('Y/m/t');
$totalMonths = $dateStart->diff($dateFin)->m + ($dateStart->diff($dateFin)->y*12);
$result = [];
for ($i = 0; $i <= $totalMonths; $i++)
{
    if ($i != 0){
        $dateStart->modify('first day of next month');
        $firstDay = $dateStart->format('Y/m/d');
        $dateStart->modify('last day of month');
        $lastDay = $dateStart->format('Y/m/t');
    }

    $nextDate = explode('/', $firstDay);

    $totalDays = cal_days_in_month(CAL_GREGORIAN, $nextDate[1], $nextDate[2]);
    if ($i == 0){
        $totalDays -= $dateStart->format('d');
    } else if ($i == $totalMonths) {
        $totalDays = $dateFin->format('d');
    }

    $result["$firstDay - $lastDay"] = $totalDays;
}

var_dump($result);

虽然没有改进，但是提供了你所要求的内容。

例行程序得到改进，请查看以下：

$dateStart = new DateTime("2016/12/14");
$dateFin = new DateTime("2017/04/21");
$totalMonths = $dateStart->diff($dateFin)->m + ($dateStart->diff($dateFin)->y*12);
$result = [];
for ($i = 0; $i <= $totalMonths; $i++)
{
    if ($i != 0){
        $obj = $dateStart->modify('first day of next month');
    }

    $firstDay = $dateStart->format('Y/m/d');
    if ($i == $totalMonths){
        $lastDay = $dateFin->format('Y/m/d');
    } else {
        $lastDay = $dateStart->format('Y/m/t');
    }
    $firstDayObj = strtotime($firstDay);
    $lastDayObj = strtotime($lastDay);
    $totalDays = (int) ceil(($lastDayObj - $firstDayObj) / 86400);
    $totalDays = ((int) $dateStart->format('d') == 1) ? $totalDays + 1 : $totalDays;
    $result["$firstDay - $lastDay"] = $totalDays;
}

var_dump($result);

//array(5) { ["2016/12/14 - 2016/12/31"]=> int(17) ["2017/01/01 - 2017/01/31"]=> int(31) ["2017/02/01 - 2017/02/28"]=> int(28) ["2017/03/01 - 2017/03/31"]=> int(31) ["2017/04/01 - 2017/04/21"]=> int(21) }

- capcj

---

我会改进它，稍等片刻 :) - capcj

请检查我的改进。 - capcj

我认为必须再增加一次循环，所以我不得不在totalMonths中加1以获得精确的结果。 - Lokesh Das

Answer 2

要获取两个日期之间的天数差异，可以这样做：

function daysDiff($d1, $d2) 
{
    $x1 = days($d1);
    $x2 = days($d2);

    if ($x1 && $x2) {
        return abs($x1 - $x2);
    }
}

function days(DateTime $x) 
{
    $y = $x->format('Y') - 1;
    $days = $y * 365;
    $z = (int)($y / 4);
    $days += $z;
    $z = (int)($y / 100);
    $days -= $z;
    $z = (int)($y / 400);
    $days += $z;
    $days += $x->format('z');

    return $days;
}

$d1和$d2应该是DateTime类型的，我从这里复制了这段代码: http://php.net/manual/es/function.date-diff.php#117691 并进行了小修改，用类型提示代替了使用get_class验证变量类型。

- lloiacono

Answer 3

强大的函数获取两个日期之间的差异

在这里检查演示

function dateDifference($date_1, $date_2, $differenceFormat = '%a')
{
    $datetime1 = date_create($date_1);
    $datetime2 = date_create($date_2);

    $interval = date_diff($datetime1, $datetime2);

    return $interval->format($differenceFormat);
}

- Joe Black

Answer 4

请根据上述描述尝试执行以下代码片段作为解决方案。

$start_date = new DateTime('2016/12/14');
$start_date=$start_date->modify('+1 day');
$end_date = new DateTime('2017/04/21');
$end_date = $end_date->modify('+1 day');

$interval = new DateInterval('P1D');
$daterange = new DatePeriod($start_date, $interval ,$end_date);
$month_days=array();
foreach($daterange as $date)
{
  $date_month=$date->format('m');
  $month_days[$date_month][]=$date->format('Y/m/d');
}
$result=array();
foreach($month_days as $days)
{
  $begin=reset($days);
  $end=end($days);
  $result[$begin.'-'.$end]=count($days);
}
echo '<pre>';
print_r($result);

- Rubin Porwal