Save dates for database within date range

Question

I want to select all the Mondays within date range and save the dates in the database. This is the code I tried. But it save only last date. I want to save all the Mondays. Please can you help me?

$startDate = '2011-08-10';
$endDate = '2011-10-23';

for ($i = strtotime($startDate); $i <= strtotime($endDate); $i = strtotime('+1 day', $i)) {
    if (date('N', $i) == 1) {
       $query = "INSERT INTO class(Day, Date) VALUES('Monday', '".date('Y-m-d', $i)."')";
    }
}

Any reason in `+1 day` increment? Monday happens once a week, true story. — zerkms, Aug 15 '11 at 06:16
duplicates: http://stackoverflow.com/questions/7061802/php-function-for-get-all-mondays-within-date-range/7061841 — realmfoo, Aug 15 '11 at 06:33

Mihai Iorga · Answer 1 · 2011-08-15T06:34:42.073

execute the query in the loop, and not at the end

$startDate='2011-08-10';
$endDate='2011-10-23';
for ($i = strtotime($startDate); $i <= strtotime($endDate); $i = strtotime('+1 day', $i)) {
    if (date('N', $i) == 1){
        $query = "INSERT INTO class(Day, Date) VALUES('Monday','".date('Y-m-d', $i)."')";
        mysql_query($query); // you execute the query here otherwise it will overwrite over and over and only the last query will be executed
    }
}

or bulk

$startDate='2011-08-10';
$endDate='2011-10-23';
$query = "INSERT INTO class(Day, Date) VALUES ";
for ($i = strtotime($startDate); $i <= strtotime($endDate); $i = strtotime('+1 day', $i)) {
    if (date('N', $i) == 1){
        $query .= "('Monday','".date('Y-m-d', $i)."'),";
    }
}
$query = substr($query, 0, -1).";"; // remove the last "," and add ;
mysql_query($query);

mysql supports bulk inserts. That is the case they have been invented for. — zerkms, Aug 15 '11 at 06:21

Save dates for database within date range

1 Answers1