PROS! Printing "The Week Of"

[brianb]

Hello,

Through PHP or MYSQL, is there a way to print THE WEEK OF a certain date starting with Monday?

Like this week would be:

THE WEEK OF OCTOBER 14th, 2002

I'd like to also print next week, last week, and the week after next

Any help is appreciated!

[the_Igel]

date() function and a bit of fantasy.
You get the current day-of-week number and subtract that number minus 1 from current date.

[cahva]

You get the week of date a lot easier in mysql.(Im presuming you have a table with datefield)

example:
$query="SELECT WEEK(date) FROM table WHERE id='$id'";

If you want the week to start from monday, use WEEK(date,1).

To get the next week from the date use, date + INTERVAL 7 DAY and after that, the week thing again to get the week.

[gramorris]

I think this should work,

It just gets todays date and then deletes a day until the day equals monday leaving you with that date. The last line just parses the date into a MySQL date format but you could just as easily change it to read out Monday, 20th of March or whatever.

$date0 = mktime("","","",date("m"),date("d"),date("Y"));
$w = strftime("%w",$date0);
if ($w != 1) {
  $date0 = $date0 - (60*60*24);
  $w = strftime("%w",$date0);
	 while (($w != 1) {
		  $date0 = $date0 - (60*60*24);
		  $w = strftime("%w",$date0);
	 }
}
$mondaydate = strftime("%Y-%m-%d",$date0);

[gramorris]

Ah, get rid of the if statement it's not needed. And I think the value for Monday is 1 but it might well depend on the day that is set up as the start of the week, nothing a bit of testing won't fix.

[no1uknowdfw]

$date0 = mktime("","","",date("m"),date("d"),date("Y"));
echo strftime("%W",$date0);

If I read the question correct you need the uppercase "W" not the lowercase... This is to get 1 week for a certain day.

I wrote this function the other day to display current week back to the first of the year and the date of every monday back...
You can modify it to fit your needs...

function listbox_week ($name, $default=0) {
$result="<select name=\"$name\" size=1 class=\"formpulldown\">\n";
$weekx = '0';
for ($weekf=strftime("%U"); $weekf>=1; $weekf--) {
$weekx ++;
$str = '-'.$weekf.' week Monday';
if (($timestamp = strtotime($str)) === -1) {
$weekmsg = "The string ($str) is bogus";
} else {
$weekmsg = "Week ".$weekx." - ".date('F j',$timestamp);
$weekdate = date(m.'/'.d.'/'.y,$timestamp);

				}
				if ($default == $weekx) {$selected="selected";} else {$selected="";} 
					$result.="<option value=\"".$weekdate."\" $selected>".$weekmsg."</option>\n";
				} 
	$result.="</select>\n"; 
return $result; 

}

// Then you can echo it back like this...

echo listbox_week("week", strftime("%U"));