循环带有更新日期的SQL插入语句

Question

What do I need to do is run insert the same thing into a database only changing the date.

i.e

INSERT INTO bs_events
(
    eventDate,
    eventTime,
    title,
    spaces,
    description,
    entryFee,
    payment_required,
    max_qty,
    allow_multiple
) 
VALUES (
    '2011-03-02 00:00:00',
    '10:00',
    'Carpet Cleaner 3000',
    '4',
    'This is rad',
    '25.99',
    '1',
    '1',
    '2'
)

So I need to run this loop for a year or month or 2 years and have it add to the database but the date needs to change each day

I've got no idea how I go about making a script to do this so any help would be appreciated

Thanks

Answer 1

Here's an example. It does it all in one query.

$row = array(
    '2011-03-02 00:00:00',
    '10:00',
    'Carpet Cleaner 3000',
    '4',
    'This is rad',
    '25.99',
    '1',
    '1',
    '2'
);

$rows = array();
$end = new DateTime('2012-01-01');
for($date = new DateTime($row[0]); $date < $end; $date->modify('+1 day')) {
    $row[0] = $date->format('Y-m-d H:i:s');
    $rows[] = sprintf("('%s')", implode("','", $row));
}

$query = 'INSERT INTO bs_events
(
    eventDate,
    eventTime,
    title,
    spaces,
    description,
    entryFee,
    payment_required,
    max_qty,
    allow_multiple
) VALUES '.implode(',', $rows);

Note: This works because the row data is known... if you accepting user input, make sure you are checking for SQL injection.