Get timestamps out of week no. and year.
Today i had a problem i only had a week number and a year. And i needed timestamps to get all results from a database in that week.
So, i searched on google and found this as first result:
http://tzzz.wordpress.com/2006/08/14/8/
The code he provided wasn’t exactly what i have been looking for but in the comments there was a result that was very close.
function getFirstDayOfWeek($year, $weeknr){ $offset = date('w', mktime(0,0,0,1,1,$year)); $offset = ($offset < 5) ? 1-$offset : 8-$offset; $monday = mktime(0,0,0,1,1+$offset,$year); return strtotime('+' . ($weeknr - 1) . ' weeks', $monday); }
Now i changed this code to provide me the first and last day of the week:
function getFirstDayOfWeek($year, $weeknr){ $offset = date('w', mktime(0,0,0,1,1,$year)); $offset = ($offset < 5) ? 1-$offset : 8-$offset; $monday = mktime(0,0,0,1,1+$offset,$year); $sunday = mktime(0,0,0,1,7+$offset,$year); $day['first']=strtotime('+' . ($weeknr - 1) . 'weeks', $monday); $day['last']=strtotime('+' . ($weeknr - 1) . ' weeks', $sunday); return($day); }
This solved my entire problem, so i could search my database with weeks without having it to store it in the database. That would be a solution that would cost me to much data.
