สอบถามการเก็บข้อมูลเป็น Week ของปีนั้นๆ ตั้งแต่ week1 ถึงสิ้นปี ครับ

function weekOfYear($year)
{
	$firstDayOfYear = mktime(0, 0, 0, 1, 1, $year);
	$nextYear = strtotime('+1 year', $firstDayOfYear);
	$nextMonday = strtotime('monday', $firstDayOfYear);
	$nextSunday = strtotime('sunday', $nextMonday);
	$n = 1;
	while (date('Y', $nextMonday) == $year) 
	{
		if ($nextMonday > $firstDayOfYear)
		{
			$array[$n] = array('start_date' => date('Y-m-d', $firstDayOfYear), 'end_date' => date('Y-m-d', strtotime('-1 day', $nextMonday)));
			++$n;
		}
		$nextSunday = ($nextSunday >= $nextYear) ? strtotime('-1 day', $nextYear) : $nextSunday;
		$array[$n] = array('start_date' => date('Y-m-d', $nextMonday), 'end_date' => date('Y-m-d', $nextSunday));
		$nextMonday = strtotime('+1 week', $nextMonday);
		$nextSunday = strtotime('+1 week', $nextSunday);
		++$n;
	}
	return $array;
}
$week = 0;
foreach(weekOfYear(2016) as $key => $val)
{
	++$week;
	echo 'Week #'.$week;
	$str_sql = "SELECT * FROM table WHERE fieldDate BETWEEN '".$val['start_date']."' AND '".$val['end_date']."'";
	/*
	แสดงข้อมูล 
	*/
}

$str_sql = "SELECT * FROM inventory WHERE docdate BETWEEN '".$val['start_date']."' AND '".$val['end_date']."'";