Untitled

INSERT INTO table_name (id, name, slug, week_start, week_end) VALUES

<?php

 

$start = '2010-06-12 00:00:00';

$id = 2;

$length = 150;

for ($i=2;$i<=$length; $i++) {

        $timeStamp      = strtotime($start);

        $weekStart      = $timeStamp + (24 * 60 * 60 * 7 * $i);

        $weekEnd        = $weekStart + (24 * 60 * 60 * 7);

        $FweekStart = date("Y-m-d H:i:s", $weekStart);

        $FweekEnd       = date("Y-m-d H:i:s", $weekEnd);

        ?>

       

        (<?php echo $id;?>,'<?php echo date("D d F Y", $weekStart);?>','<?php echo strtolower(date("d-F-Y", $weekStart));?>','<?php echo $FweekStart; ?>','<?php echo $FweekEnd; ?>'),

       

        <br/>

       

        <?php $id ++;?>

 

<?php } ?>