Wordpress/PHP Get days between two dates and create array

Question

I have a custom-post-type for Vacationperiods where there are some custom fields of type Datepicker to set start and end date. Now I want to get all the days between these to dates and add them to an array.

function get_vacation_dates(){
global $post;

  $args = array(
    'post_type' => array('vacationperiods'),
    'post_status' => array('publish'),
    'order' => 'ASC'
  );

  $posts = get_posts($args);
  $vac = [];
  foreach ($posts as $post){

    $vacationTitle = get_field('name', $post->ID);
    $startDate = get_field('vacation_start', $post->ID);
    $endDate = get_field('vacation_end', $post->ID);

    // GET ALL DAYS/DATES
    for ($i=$startDate; $i<=$endDate; $i+=86400) {  
        $days = date('Y-m-d', $i);
    }       

    $duration = dateDiff($startDate, $endDate);

    $vac[] = [
        'name' => $vacationTitle,
        'start' => $startDate,
        'end' => $endDate,
        'duration' => $duration,
        'days' => $days
    ];



  }

  echo json_encode($days);

  die();
}

This approach does not work, it gives me "days: '1970-01-01'" - but as mentioned before I want to get all days listed as an array, something like "days: ['2018-09-13', '2018-09-14', etc..]

How can I achieve that?

convert date into strtotime.

Gufran Hasan
– Gufran Hasan

2018-09-13 08:06:16 +00:00
Commented Sep 13, 2018 at 8:06 — Gufran Hasan
– Gufran Hasan, Commented Sep 13, 2018 at 8:06

Gufran Hasan · Accepted Answer · 2018-09-13 08:21:41Z

3

The strtotime() function parses an English textual DateTime into a Unix timestamp (the number of seconds since January 1 1970 00:00:00 GMT).

Something like this:

$days = array();
    // GET ALL DAYS/DATES
        for ($i=strtotime($startDate); $i<=strtotime($endDate); $i+=86400) {  
            $days[] = date('Y-m-d', $i);
        }

edited Sep 13, 2018 at 8:21

answered Sep 13, 2018 at 8:07

Gufran Hasan

9,4297 gold badges45 silver badges57 bronze badges

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

6 Comments

ST80 Over a year ago

For some reason, this only gives me the endDate as result :-/

Gufran Hasan Over a year ago

Do you mean last date of loop?

ST80 Over a year ago

Yes exactly, the last date of loop

Gufran Hasan Over a year ago

Actually, $days is a variable. it overrides with last value. It should be define an array or as you want.

Gufran Hasan Over a year ago

Define $days as an array $days = array();. see updated answer.

|

Collectives™ on Stack Overflow

Wordpress/PHP Get days between two dates and create array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related