Date in text and numbers

Anon

I'm trying to show a week number and the textual date range for that week in an input and update form.

A user enters their vacation time based on the week that they will be gone.
I'll need to store the $week and the $weekrange.

But how do I get $weekrange without having to hard code the dates?

($weekrange = 'January 21 - January 25'; $week = '4'😉

Reason:

The page I'm building will display all users out of the office this week and next week, and the days of those weeks that they are out.

My problem is getting php to build a pulldown list of the $weekrange without me having to hard code the text match for each $week number.

Thanks,

Steve

Anon

I'm not sure I understand this correctly.

Do you want to create a pulldown list of all the weeks for the year and display the corresponding Monday through Friday dates for each week?

Or do you want the user to enter a date range and then you compute the week number for that range?

Hank

sirgoran

I didn't think I explained it well enough. Sorry.

Here is what we have in mind. A user land on the vacation listing page.

It shows the following for this week and a similar list for next week:

January 21 - January 25
Joe Smith M, T, W
Sally Jones M, T
John Doe TH, F

If they wish to enter their vacation time they click a link.

The pop-up widow has inputs for $name, $weekrange, and $days (of the week)

Currently the $weekrange is hard coded for all of the weeks of the year in a pulldown. What I'm trying to figure out is if there is a way to generate that pulldown dynamically so I don't have to recode it next year. I'd also like to be able to compare the $weekrange (Text) and the $week (number) so that the form will know that when $week = 4 that $weekrange = January 21 - January 25.

The $weekrange does not have to be Monday through Friday but at least Sunday through Saturday or Monday through Sunday.

Thanks for the help,

Steve

sirgoran

What a difference a little sleep and coffee make!

Thank you for the code you sent. Here's how it turned out.

for ($i = 0;;$i++) {
if ($i > 52) {
break;
}

$first_day_of_year = mktime(0, 0, 0, 1, 1, date("Y"));
$week = $first_day_of_year + (6060247$i); //week selected

$weekstart_a = $week-(606024*(date("w", $week)-1));

$weekstart = date("F d", $weekstart_a); //format weekstart for display
$weekend = date("F d", mktime(0,0,0,date("m", $weekstart_a),date("d", $weekstart_a)+6,date("Y", $weekstart_a))); //format weekend for display

echo "<option value='".$i."'>".$weekstart."".$weekend."</option>";
}

I can then also use the code you sent to display the current week and then pull out the info in the database that matches the current week number to display.

In short, Thanks.
Steve