How to format string to date from array in foreach loop?

Question

I have the following code that works perfect with a pre-formatted DateTime array:

foreach ($ranges as $range) {
    while ($range['start'] <= $range['end']) {
        $date = $range['start']->format('Y-m-d');
        $dates[$date] = (isset($dates[$date]) ? $dates[$date] : 0) + 1; 1;//define new $dates array
        $range['start']->modify('+1 day');
    }
}

$sold_out = array_filter($dates, function($n) { return $n >= 7; });

echo implode(',', array_keys($sold_out));

But, my production array is not "pre-formatted" as DateTime

In the linked Fiddle you can see we are linking to a native array where the values are 'strings' http://phpfiddle.org/main/code/zni4-enk5

This produces an 'Exception: Call to a member function format() on string'
on the line where we step through the dates:
$range['start']->modify('+1 day');

To test change the array target from $ranges to $ranges2:
Example: foreach ($ranges2 as $range) {

Is the problem not properly being able to set the values as DateTime?

GOAL: Output comma delimited dates that share a date that intersects x number of times within the provided date ranges.

Miroslav Glamuzina · Accepted Answer · 2019-02-23 01:01:18Z

2

You may use DateTime's createFromFormat() to convert these values to DateTime values.

DateTime::createFromFormat('Y-m-d', '2019-02-18');

foreach ($ranges2 as $range) {
    $range['start'] = DateTime::createFromFormat('Y-m-d', $range['start']);
    $range['end'] = DateTime::createFromFormat('Y-m-d', $range['end']);
    while ($range['start'] <= $range['end']) {
        $date = $range['start']->format('Y-m-d');
        $dates[$date] = (isset($dates[$date]) ? $dates[$date] : 0) + 1; 1;//define new $dates array
        $range['start']->modify('+1 day');
    }
}

Hope this helps,

edited Feb 23, 2019 at 1:01

answered Feb 23, 2019 at 0:53

Miroslav Glamuzina

4,5872 gold badges23 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Burndog Over a year ago

Remember we are dealing with variables and not able to change the native array where each date is a String ($ranges2 = array(...).

Collectives™ on Stack Overflow

How to format string to date from array in foreach loop?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related