Adding days to a specific date inside an array

Question

I have a TABLE events

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` date DEFAULT NULL,
`days` int(2) DEFAULT NULL,
PRIMARY KEY (`id`)

with a number of records.

I generate an array with all unavailable dates

$sql = "SELECT * FROM events WHERE `data` LIKE '".$cYear."-".$cMonth."-%'";
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
while ($row = mysql_fetch_assoc($sql_result)) {
$unavailable[] = $row["data"];
$days[] = $row["days"];
}

The array $unavailable is like this: (2012-08-10, 2012-08-25) The array $days is like this: (3, 2)

I need an array like this: (2012-08-10, 2012-08-11, 2012-08-12, 2012-08-25, 2012-08-26)

Thank you!

qbert220 · Accepted Answer · 2012-08-16 10:05:27Z

1

Here is some code that generates what you want.

<?php

$unavailable = array('2012-08-10', '2012-08-25');
$days = array(3, 2);

$dates = array();
for ($i = 0; $i < count($days); $i++)
{
    $tm = strtotime($unavailable[$i]);
    for ($d = 0; $d < $days[$i]; $d++)
    {
        $dates[] = date('Y-m-d', $tm + $d * 24 * 60 * 60);
    }
}
print_r($dates);
?>

You could move this code into to while loop of your code to prevent creating the $unavailable and $days arrays

answered Aug 16, 2012 at 10:05

qbert220

11.6k4 gold badges34 silver badges33 bronze badges

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

1 Comment

Mugur Ungureanu Over a year ago

"Vote Up requires 15 reputation" I have 8 :(

Collectives™ on Stack Overflow

Adding days to a specific date inside an array

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