Dates in a week

[alix]

Hi.

I have 2 dates, the beginning and end date of a week, in format yyyy-mm-dd.

I need to register in a mysql table a row for each day of that week and I can't seem to figure out how to do it.

Can anybody help me ?

Thanks in advance!!!

[risoknop]

<?php

$monday = '2009-08-03';
$monday = strtotime($monday); // convert to timestamp

$week = array();
for ($i = 0; $i < 7; $i++) {
    $timestamp = mktime(0, 0, 0, date('m', $monday), date('d', $monday) + $i, date('Y', $monday));
    $key = date('D', $timestamp);
    $value = date('Y-m-d', $timestamp);
    $week[$key] = $value;
}

echo '<pre>';
var_dump($week);
echo '</pre>';

// now you can loop through $week with foreach and build INSERT query
// then execute it to insert all rows to the table at once

[alix]

<?php

$monday = '2009-08-03';
$monday = strtotime($monday); // convert to timestamp

$week = array();
for ($i = 0; $i < 7; $i++) {
    $timestamp = mktime(0, 0, 0, date('m', $monday), date('d', $monday) + $i, date('Y', $monday));
    $key = date('D', $timestamp);
    $value = date('Y-m-d', $timestamp);
    $week[$key] = $value;
}

echo '<pre>';
var_dump($week);
echo '</pre>';

// now you can loop through $week with foreach and build INSERT query
// then execute it to insert all rows to the table at once

That worked great!!! Thanks!!!

[crmalibu]

You could also do

insert into mytable (thedate) values ('2009-05-09' + INTERVAL 3 DAY)