Group and filter multidimensional array by date

Question

I have a movies array that I'm trying to use to display a calendar page based on dates. Here's the array:

$movies = [
    'MOVIE TITLE #1' => [
        'id' => 11990,
        'times' => [
            '2023-06-03' => [
                '11:00am',
                '2:30pm',
                '6:00pm',
                '9:30pm',
            ],
            '2023-06-04' => [
                '12:30pm',
                '4:00pm',
                '7:30pm',
            ],
            '2023-06-06' => [
                '12:30pm',
                '4:00pm',
                '7:30pm',
            ],
        ],
    ],
    'MOVIE TITLE #2' => [
        'id' => 11892,
        'times' => [
            '2023-06-03' => [
                '12:00pm',
                '3:30pm',
                '7:00pm',
            ],
        ],
    ],
];

I have another array that generates the list of dates that have movies playing on them. This is used to populate a form dropdown to show/hide DIVS for each date with movies showing.

I need help with taking the date from that other array to search this array for any movies playing on that date -- so that I can generate a DIV for each date with a list of the movies and times in this format:

2023-06-03 (DIV)

MOVIE TITLE #1
- 11:00am
- 2:30pm
- 6:00pm
- 9:30pm
MOVIE TITLE #2
- 12:00pm
- 3:30pm
- 7:00pm

2023-06-04 (DIV)

MOVIE TITLE #1
- 12:30pm
- 4:00pm
- 7:30pm ...

Can someone provide a basic coding example?

Please always present your sample array data as the copy-pasted text from var_export() so that contributors can instantly use it. — mickmackusa
– mickmackusa ♦, Commented Jun 3, 2023 at 12:50

mickmackusa · Accepted Answer · 2023-06-03 13:14:32Z

1

Iterate over your movies array to access the titles and their respective dates and times.

For each encountered title, filter the dates by your other array of dates. There are many ways to do this filtration.

Finally, push the time elements into the hierarchical result array.

I'll leave the HTML markup generation to you.

Code: (Demo)

$dates = array_flip(['2023-06-03', '2023-06-04']);

$result = [];
foreach ($movies as $title => ['times' => $times]) {
    foreach (array_intersect_key($times, $dates) as $date => $times) {
        $result[$date][$title] = $times;
    }
}
var_export($result);

Output:

array (
  '2023-06-03' => 
  array (
    'MOVIE TITLE #1' => 
    array (
      0 => '11:00am',
      1 => '2:30pm',
      2 => '6:00pm',
      3 => '9:30pm',
    ),
    'MOVIE TITLE #2' => 
    array (
      0 => '12:00pm',
      1 => '3:30pm',
      2 => '7:00pm',
    ),
  ),
  '2023-06-04' => 
  array (
    'MOVIE TITLE #1' => 
    array (
      0 => '12:30pm',
      1 => '4:00pm',
      2 => '7:30pm',
    ),
  ),
)

answered Jun 3, 2023 at 13:14

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

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

1 Comment

Mathew Smith Over a year ago

Thank you for your help, Mick. I need to change up the format of the output -- so I'm going to create a separate question for that.

Collectives™ on Stack Overflow

Group and filter multidimensional array by date

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