CODEWITHSUNDEEP
phpdate
Tavi
Tavi

Reputation: 103

geting specific dates in the future with php

so my problem is rather simple but the solution keeps evading me. i am trying to get a list of future dates at a set interval that respects week nr in month and day nr in week. for example i need to make a list of dates of the 2nd mondays at 3 months apart.

i have a form where user specifies 2 dates and the interval.

so what i have is something like:

$start_date = "2015-01-07";
$end_date = "2016-01-07";
$period = "+1 month";

then, using this function from this link stackoverflow i get what weeknr my start_date is: (ie: "first monday")

function literalDate($timestamp) {
    $timestamp = is_numeric($timestamp) ? $timestamp : strtotime($timestamp);
    $weekday = date('l', $timestamp);
    $month = date('M', $timestamp);

$ord = 1;

while(date('M', ($timestamp = strtotime('-1 week', $timestamp))) == $month) {
    $ord++;
}

$lit = array(null, 'first', 'second', 'third', 'fourth', 'fifth');

return $lit[$ord].' '.$weekday;
}
$day_number = literalDate($start_date);
$list=array();

then. i'm trying to do this

while(strtotime($start_date) <= strtotime($end_date))
{
  $list[]=$start_date;
  $start_date=date('Y-m-d', strtotime("$start_date $period"));
  $month = date('F', strtotime($start_date));
  $start_date = date('Y-m-d', strtotime($day_number.' of '.$month)); //this always returns 1970-01-01
}

print_r($list);

as asked in comment my expected output is something like 

array(
[0] => 2015-01-07
[1] => 2015-02-04
[2] => 2015-03-04
[3] => 2015-04-01
[4] => 2015-05-06
[5] => 2015-06-03
[6] => 2015-07-01
[7] => 2015-08-05
[8] => 2015-09-02
[9] => 2015-10-07
[10] => 2015-11-04
[11] => 2015-12-02
)

Upvotes: 0

Views: 234

Answers (2)

Sam Battat
Sam Battat

Reputation: 5745

From what I understand, DateInterval should get you what you need:

$start    = new DateTime('2015-01-07');
$start->modify('first day of this month');
$end      = new DateTime('2016-01-07');
$end->modify('first day of this month');
$interval = DateInterval::createFromDateString('first wednesday');
$period   = new DatePeriod($start, $interval, $end);

foreach ($period as $dt) {
    $d = $dt->format("d");
    if($d <= 7){
       echo $dt->format("Y-m-d") . "\n";
    }
}

will display:

2015-01-07
2015-02-04
2015-03-04
2015-04-01
2015-05-06
2015-06-03
2015-07-01
2015-08-05
2015-09-02
2015-10-07
2015-11-04
2015-12-02
2016-01-06

Upvotes: 3

geggleto
geggleto

Reputation: 2625

strtotime() which works in reference of today.

strtotime("+x days");

strtotime

if you need something in relation to another date...

date("Y-m-d", strtotime($yourdate) + 86400 * $days);

Upvotes: -1

Related Questions