Week Of (Calendar) Select boxes

[Cogen]

Hello everyone,

I'm trying to create a web page that has two select boxes. One of the text boxes will display years (5 years in the past, 5 in the future) in the format "2003". That's the easy part.

When the user selects the year, I want the other textbox to display all of the weeks in that year. For instance ... "Mon Nov 3 - Sun Nov 9" would be one of the options. I can either reload the page or use javascript to do it automatically, but the problem is getting the values for that select box. I would like to have the value of the options be timestamp values.
I was thinking about somehow figuring out a timestamp value for every Monday of the year specified, and adding to the timestamp value to display the Sunday value (not sure if this is the best way or not).
Does anyone have any suggestions? I'm struggling on how to do this.

[weekender]

you need strtotime

//get first day of year
$start = strtotime ("1 January 2000");
//while the year is still 2000
while(date("Y", $start) == "2000"){
//get the timestamp of the next monday
$monday = strtotime ("next Monday", $start);
//then the following sunday
$sunday = strtotime ("next Sunday", $monday);
//set the start date for the next loop
$start = $sunday;
echo date("l \\t\h\e jS", $monday) . " to " . date("l \\t\h\e jS", $sunday) . "<BR>"; 
}

this will print

monday the 1st to sunday the 6th
monday the 7th to sunday the 13th

etc etc

hope this helps

adam

[Cogen]

Thanks for the reply weekender, it seems like a good solution, but it's not working for me. For some reason when I run the loop, it skips every second Monday. Even with a simple test like below, it skips the first Monday ... Any idea's why it would do that?

This:
$start = strtotime ("1 January 2003");
$monday = strtotime ("next Monday", $start);

echo "Start =".date("D M j", $start)."<br />";

echo "First Monday =".date("D M j", $monday);

Produces this:
Start =Wed Jan 1

First Monday =Mon Jan 13

[LordShryku]

I think what you really need is
$monday = strtotime ("this Monday", $start);

[Cogen]

LordShryku ... thank you also for the reply, but something weird is happening when I try that ... it crashes my browser (on 2 different machines, although obviously the same server) . It's almost like it starts a never ending loop, but the code looks fine to me. Does anyone see anything wrong with this code?

//get first day of year 
$start = strtotime ("1 January 2003"); 

//while the year is still 2003 
while(date("Y", $start) == "2003"){ 
	//get the timestamp of the next monday 
	$monday = strtotime ("this Monday", $start); 
	//then the following sunday 
	$sunday = strtotime ("this Sunday", $monday); 
	//set the start date for the next loop 
	$start = $sunday; 
	echo date("D M j", $monday) . " to " . date("D M j", $sunday) . "<BR>";  

}

[LordShryku]

Worked fine for me....

And that's running off of an old crappy IBM laptop....

[Cogen]

Now it's really strange if it works for you and not me. Just for testing purposes, I tried taking the code to a different site other then the one I'm currently working on, and made a testing php page that only preformed that code without anything else. I got very interesting output ...

It started out giving me the correct output
Mon Jan 6 to Sun Jan 12
Mon Jan 13 to Sun Jan 19
Mon Jan 20 to Sun Jan 26
Mon Jan 27 to Sun Feb 2
Mon Feb 3 to Sun Feb 9

.. but as soon as it hit Sun Oct 26, something went wrong ...
Mon Oct 6 to Sun Oct 12
Mon Oct 13 to Sun Oct 19
Mon Oct 20 to Sun Oct 26
Sun Oct 26 to Sun Oct 26
Sun Oct 26 to Sun Oct 26
Sun Oct 26 to Sun Oct 26
Sun Oct 26 to Sun Oct 26
Sun Oct 26 to Sun Oct 26

.. it never increments past that date which is why the page never loads properly. Any ideas what what cause that?

[LordShryku]

Try this instead. Uses math instead of strtotime for the calculations. strtotime is only used to get the first Monday of the year.

$start = strtotime("this Monday", strtotime("2003-01-01"));

while(date("Y",$start) == "2003") {
   $end = ($start + (60*60*24*6));
   echo date("D M j", $start)." to ".date("D M j", $end)."<br>";
   $start = ($end + (60*60*24));
}

[Cogen]

Thank you LordShryku. Your code works perfectly. I don't know if it's a bug in PHP, or something setup wrong on my server, but I think I know what the problem was...

Oct 26 2003 just happens to be the day this year when daylight saving time requires the time to be put back one hour, therefore that day actually spans 25 hours, which obviously is causing problems. Your code is not effected because earlier in the year the time is put ahead 1 hour, therefore it balances the timestamps out.

Thanks again 🙂 !

[LordShryku]

My code isn't affected because I'm in AZ. We don't have daylight savings here 🙂

[Cogen]

haha ... I guess that explains why you didn't have any problems with the original code either, yet it didn't work for me. :p