dropdown population

Dillenger

Hi,

How would I go about creating a dynamically generated DropDown menu, that displays the date for every monday of the year?

AstroTeg

Ok.

So where are you stuck at?

Dillenger

I just don't know how to make a while statement, where it will select every monday... is that even possible?

Installer

If you're looking for how to determine the dates of the Mondays, something like this:

$startMonday = mktime(12, 0, 0, 9, 13, 2004);
for ($i = -16; $i <= 16; $i++) {
    $date[$i] = date('m/d/y', $startMonday + ($i * 7 * 24 * 60 * 60));
    echo $date[$i] . '<br />';
}

will give you them, with the weeks offset from your starting date as the keys. Use noon to avoid daylight time problems.

Installer

I forgot you wanted all the Mondays of the year. This will get them:

$startMonday = mktime(12, 0, 0, 9, 13, 2004);
$sequence = 0;
for ($i = -52; $i <= 52; $i++) {
    $date[$i] = date('m/d/y', $startMonday + ($i * 7 * 24 * 60 * 60));
    if (substr($date[$i], -2) == '04') {
        $monday[++$sequence] = $date[$i];
    }
}
foreach ($monday as $key => $value) {
    echo $key . ' - ' . $value . '<br />';
}

(With the week numbers as the array keys.)

Dillenger

Hey, thanks for your help. I've edited your code below, so that it works for what i'm doing, one more question is, how could I make it so that the dates that have already passed will no longer show up in the drop down... also, once it gets to 2005, do i just need to change that 2004 number, and the new dates will show up?

$startMonday = mktime(12, 0, 0, 9, 13, 2004); 
		$sequence = 0; 
		for ($i = -52; $i <= 52; $i++) { 
   		 $date[$i] = date('M d, Y', $startMonday + ($i * 7 * 24 * 60 * 60)); 
    	 if (substr($date[$i], -2) == '04') { 
        	$monday[++$sequence] = $date[$i]; 
			} 
		} 
		echo"<select name='issue_date' size='1' class='boxes'>";
		foreach ($monday as $key => $value) { 
			echo"<option value='$value'>$value</option>";
		}
		echo"</select>";

Installer

If you want, for example, the next 52 weeks of Mondays, you could change the "for" conditions to go from 0 to 52 and leave out the boolean for '04. It would probably work best if you put in a routine to find the nearest Monday to the current date and start from there. For just the '05 dates, yeah, you could change the '04 bit. You'd want it done automatically so you don't have the hassle of changing your code every year. 🙂

When I come back later today I'll check to see if you need some more help getting it implemented. Meantime, maybe someone else has some ideas for you.

hth