PHP add multiple dates from DatePeriod to array [duplicate]

Question

Can somebody please help me? I want to add dates from DatePeriod() to my array. I have the following code, which works, but it adds only the last row passed from SQL (the SQL query returns more than one start and end date):

while($rowLD = $getDataLD->fetch_assoc()) { 
  $strDateFrom = $rowLD['ld_time_start'];
  $strDateTo = $rowLD['ld_time_end'];
  $periodLD = new DatePeriod(new DateTime($strDateFrom), new DateInterval('P1D'), new DateTime($strDateTo.' +1 day'));
  
}

foreach ($periodLD as $dateLD) {
    $datesLD[] = $dateLD->format("Y-m-d");
}

Thank you.

Related: stackoverflow.com/q/48376582/2943403 , stackoverflow.com/q/18632802/2943403 , stackoverflow.com/q/41126278/2943403 — mickmackusa
– mickmackusa ♦, Commented Aug 8, 2022 at 22:03

CreditCard · Accepted Answer · 2022-08-08 17:49:36Z

0

You are just updating the $periodLD variable, it is not an array. It should be $periodLD[] = "your date period query" .

answered Aug 8, 2022 at 17:49

CreditCard

261 bronze badge

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

5 Comments

Chuche Saku Over a year ago

Does not help, but thank you anyway.

CreditCard Over a year ago

Tell me why it doesn't work, it specifically answers your question. If you have any other errors, you can update your question.

Chuche Saku Over a year ago

I trust you that $periodLD should be defined as an array but that alone doesn't solve my issue. That's why I wrote that it doesn't help.

CreditCard Over a year ago

Then update your description and community is there for you to help.

mickmackusa Over a year ago

Please vote to close duplicates instead of answering them. If you think a question might have been asked on Stack Overflow at any point in the last 14 years of feverish Q&A, please look for a duplicate page to flag with. When you answer duplicates, the Roomba cannot purge the redundant content. This puts unnecessary workload on humans to curate good content on this site. Thank you for your cooperation.

kmoser · Accepted Answer · 2022-08-08 19:09:47Z

0

The problem is that you are overwriting $periodLD every time you assign to it. Since you want to end up with a single array composed of the elements returned by the (multiple) calls to new DatePeriod(), you must merge the period into your existing array:

$datesLD = [];
while($rowLD = $getDataLD->fetch_assoc()) { 
  $strDateFrom = $rowLD['ld_time_start'];
  $strDateTo = $rowLD['ld_time_end'];
  $period = new DatePeriod(new DateTime($strDateFrom), new DateInterval('P1D'), new DateTime($strDateTo.' +1 day'));
  foreach($period as $p) {
    $datesLD[] = $p->format('Y-m-d');
  }
}

edited Aug 8, 2022 at 19:09

answered Aug 8, 2022 at 18:12

kmoser

9,3693 gold badges28 silver badges45 bronze badges

1 Comment

Chuche Saku Over a year ago

Thank you, but it does not work. $period is not an array so it can't be merged.

Collectives™ on Stack Overflow

PHP add multiple dates from DatePeriod to array [duplicate]

2 Answers 2

5 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Linked

Related