[RESOLVED] fun with dates.

atmorell

Hello.

How can I get all weeks for a specified month with php? (Weeks for August should return: 31, 32, 33, 34, 35) Further more I would like to query a specified week for dates and day names. (Week 31: "31, 1, 2, 3, 4, 5, 6")
I have created/modified a calendar for my needs. But I would like to create links for each week. I tried to put the days for each week in an array, but that is not very useful when a week spans across month.

Best regards.
Asbjørn Morell.

etully

What is your definition of a week? In other words, how did you arrive at the values of 31, 32, 33, 34, 35 ?

If the first day of the year is a Tuesday, do all weeks for that year run from Tuesday to Monday? If not, then how do you determine what the first week of the year is? Can there be a zero-th week of the year? Can the first week of the year only have one day?

atmorell

I looked in my outlook calendar. It is ok if the first/last week of a year starts from e.g Thuesday to Sunday (or e.g only has 2 days). I have created a simple recipe system where you can plan what you will have to eat each day. In the overview you have the normal calendar with one month at a time. But I will like to have the possibility to click on a week to show all the details for each week. (7 days - spanning across month in the first and last week) It is ok if the last or first week of a year is less than 7 days. I don't understand your zero-th week question? :/

Best regards.
Asbjørn Morell.

Weedpacket

Basically, the question is: what is your definition of a "week"? If you're wanting ISO standard weeks, then have a look at [man]date[/man]. Get the week number for the first day of the month, and the week number for the last day, and you should be able to figure out the week numbers in between.

atmorell

My definition of a week is Monday to Sunday. (1-7)

etully

Perfect. Then Weedpacket's advice will work for you since, according to the manual, "ISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0)". That's under the captial "W" option for the date() command.

atmorell

ok.
I need some help building the date string. date(W) returns the week number for the 4th of august (today 🙂 What should be added if I want to print the week number for e.g. 25th of august? I googled it but did not find an answer.

etully

// hour minute second month day year
$x = mktime(0, 0, 0, 8, 25, 2006);

$x will then be a 10 digit number representing the number of seconds from Jan 1, 1970 to Aug 8, 2006. You then plug $x into the date function like this:

$week_number = date("W",$x);

atmorell

Very nice 😉 works perfect! One last thing! How do I get the dates with the week number? Let’s say I want to know the dates for week 45?

atmorell

found it.. give year and weeknumber! and it will return the days.

$day=strftime("%w",mktime(0,0,0,01,01,$year)+($week786400));
$day1=mktime(0,0,0,1,1-$day,$year)+($week786400);
for($count=0; $count<7; $count++) {
$string=strftime("%a %Y-%m-%d",$day1+($count*86400));
echo "$string";
}

Thank you all for your great assistance! Everyone have a great day.

Best regards.
Asbjørn Morell.