Dynamic Date select boxes

jamie_kerwick

I am designing some monthly reports and need a way to output 2 select boxes (for the start and end dates).

As the reports are monthly the start dates will be the 1st of the Month and the end dates will be the last day of the month.

What i want to do is to dynamically render the select boxes, starting with a fixed date (april 2002), then having an entry for each month up until (and including) the present month.

For example the 1st box should be;

<select name=start_month>
<option value="01/04/2002">01/04/2002</option>
<option value="01/05/2002">01/05/2002</option>
<option value="01/06/2002">01/06/2002</option>
<option value="01/07/2002">01/07/2002</option>
<option value="01/08/2002">01/08/2002</option>
<option value="01/09/2002">01/09/2002</option>
</select>

Any suggestions ??

TIA

Jamie

Weedpacket

have a loop.

$year=2002;
$month=4;
$this_month=date('M')+1; // too lazy to check if that's right.
                         // Whatever the numeric month is
$this_year = date('Y');

...start a select.

while($year<$this_year || $month<$this_month)
{   ...make an option.

if(++$month==13)
{   $month=1;
    ++$year;
}
}
...end the select.

OTTOMH that looks like it would work.

bastien

won't your list grow as time goes by? might be easier to have alist of months and have the user input the year?

Weedpacket

...or at least put the list in reverse order?

$start_year=2002;
$start_month=4;
$month=date('M')+1; // too lazy to check if that's right.
                         // Whatever the numeric month is
$year = date('Y');

...start a select.

while($start_year<$year || $start_month<$month)
{   ...make an option.

if(--$month==0)
{   $month=12;
    --$year;
}
}
...end the select.

jamie_kerwick

Thanks for the reply, i've almost got it working well,
with a few modifications i have got this,

<?
$year=2001;
$month=4;
$this_month=date('m'); // too lazy to check if that's right.
                         // Whatever the numeric month is
$this_year = date('Y');

?>
<select name="test">
<?
while($year<$this_year || ($year=$this_year && $month<=$this_month))
{
    $select_date = mktime(0,0,0,$month,1,$year);
    $select_value = "01/$month/$year";
    ?>
    <option value="<?=$select_date?>"><?=$select_value?></option>
    <?
    if(++$month==13)
    {
        $month=1;
        $year++;
    }
}
?>
</select>

This out puts this html

<select name="test">
<option value="986079600">01/4/2001</option>
<option value="988671600">01/5/2001</option>
<option value="991350000">01/6/2001</option>
<option value="993942000">01/7/2001</option>
<option value="996620400">01/8/2001</option>
<option value="999298800">01/9/2001</option>
<option value="1001890800">01/10/2001</option>
<option value="1004572800">01/11/2001</option>
<option value="1007164800">01/12/2001</option>
<option value="978307200">01/1/1</option>
<option value="980985600">01/2/1</option>
<option value="983404800">01/3/1</option>
<option value="986079600">01/4/1</option>
<option value="988671600">01/5/1</option>
<option value="991350000">01/6/1</option>
<option value="993942000">01/7/1</option>
<option value="996620400">01/8/1</option>
<option value="999298800">01/9/1</option>
</select>

which is OK, except for when the year should be 2002, it instead prints "1" which i am assuming is because $year is being treated as a string which when the $year++ is being done it converts to a number incorrectly as 0 ++.

Any suggestions how to stop this ??

TIA

Jamie

Weedpacket

This line is wrong:

while($year<$this_year || ($year=$this_year && $month<=$this_month))

It should be

while($year<$this_year || ($year==$this_year && $month<=$this_month))

Right now I'm not actually sure why that should make a difference in this case. But the extra condition isn't necessary, anyway - if $year is not <$this_year, then it must be ==$this_year.

while($year<$this_year || $month<=$this_month))

It will keep looping until the year is equal to this year; then, with that condition failing (because $year==$this_year), it will continue to loop until we get to next month (ooh, I missed that!), where it will stop (before printing out an option for it).

jamie_kerwick

yeah i just spotted that the = should have been ==.

I was just being a bit thick about the while loop.
I've changed it to

while ($year < $this_year || $month <= $this_month)

it now works great,

Thanks for your help

Jamie