douou6696 2016-07-25 00:12
浏览 480
已采纳

用PHP手动计算两个日期之间的周数

I'm trying to calculate the number of months and weeks since a particular date instead of from the beginning of the year.

It shouldn't follow calendar months but should instead count a month as every 4 weeks, and begin from a specified date. I need to be able to display the number of months, and also what week it is (1, 2, 3 or 4).

I want to put in a start date, and have it then count what month and week is it from that start date e.g if the start date is set to Mon 1st August it should show Month 1, Week 1 and so on.

My code is below. I tested it with some different start dates. Here's a list of what the code below generates and what it should display

Jun-20: Should be Week 2 - Shows as Week 0

Jun-27: Should be Week 1 - Shows as Week 3

Jul-04: Should be Week 4 - Shows as Week 2

Jul-11: Should be Week 3 - Shows as Week 1

Jul-18: Should be Week 2 - Shows as Week 0

$monthNumber          = 5;
$monthStartDate       = '2016-06-13';
$currentStartWeekDate = date('l') != 'Monday' ? date("Y-m-d", strtotime("last monday")) : date("Y-m-d"); // get the current week's Monday's date

$weekDateCounter      = $monthStartDate;
$currentWeekNumber    = 0;

while ($weekDateCounter != $currentStartWeekDate){
  $currentWeekNumber += 1;
  $weekDateCounter    = date("Y-m-d", strtotime($weekDateCounter . "+7 days"));
  
  //
  if ($currentWeekNumber == 4){
    $currentWeekNumber  = 0; // reset week number
    $monthNumber       += 1; // increment month number
  }
}

I am really at a loss with this and could use any help!

</div>
  • 写回答

2条回答 默认 最新

  • douhe1864 2016-07-25 01:30
    关注

    Your approach seems overly complicated:

    function weekCounter($startDate,$endDate=null){
    
        //use today as endDate if no date was supplied
        $endDate = $endDate? : date('Y-m-d');
    
        //calculate # of full weeks between dates
        $secsPerWeek = 60 * 60 * 24 * 7;
        $fullWeeks = 
                floor((strtotime($endDate) - strtotime($startDate))/$secsPerWeek);
    
        $fullMonths = floor($fullWeeks/4);
        $weeksRemainder = $fullWeeks % 4; // weeks that don't fit in a month
    
        //increment from 0-base to 1-base, so first week is Week 1. Same with months
        $fullMonths++; $weeksRemainder++;
    
        //return months and weeks in an array
        return [$fullMonths,$weeksRemainder];
    }
    

    You can call the function this way, and capture months and weeks:

    //list() will assign the array members from weekCounter to the vars in list
    list($months,$weeks) = weekCounter('2016-06-07'); //no end date, so today is used
    
    //now $months and $weeks can be used as you wish
    echo "Month: $months, Week: $weeks"; //outputs Month: 2, Week: 2
    

    Live demo

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)