Date display in both text and numbers

sirgoran

I am looking to display the week number in the year and the range of days that are within that week number.

$weekrange = 'January 21 - January 25';
$week ='4';
$days = ' M, T, W, etc.';

A user will enter the $weekrange from a pulldown for the time they will be on vacation and then the $days they will be out.

The resulting display would be as follows:

January 21 - January 25
Joe Smith M, T, W

I also want to be able to show the same for the following week in the next column.

How do I resolve the $weekrange without hard coding it?

Is there a way for PHP to know that week number '4' is January 21 - January 25?

Thanks,

Steve

Anon

Steve,

see if this will work:

$weekselected = 24; //user selection

$first_day_of_year = mktime(0, 0, 0, 1, 1, date("Y"));
$week = $first_day_of_year + (6060247$weekselected); //this get a date in the week selected

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

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

echo "Week ".$weekselected.": Begins on Monday:".$weekstart." and Ends on Sunday: ".$weekend;

-Paul

Anon

While it may be a little time-consuming to set-up (unless you can find it somewhere), using a MySQL database would make doing this pretty easy with a simple PHP query. Check out the MySQL documentation - look under this section: 3.3.4.9 Using More Than one Table. They provide a query that will give you exactly what you want (at least concerning the elapsed number of days between two dates).

sirgoran

What a difference a little sleep and coffee will do!

Hank sent me a bit of code, and with it I was able to come up with what I needed. The following is what I ended up with.

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>";
}

Thanks for the help and pointing me in the correct direction.

Steve