='".$start_date."' ";
$qry_date.=" and b.medical_entry_date >=str_to_date('".$start_date."','%d-%m-%Y') ";
}
if(isset($end_date) && $end_date!=''){
//$qry_date.=" and checkup_date <='".$end_date."' ";
$qry_date.=" and medical_entry_date <=str_to_date('".$end_date."','%d-%m-%Y') ";
}
?>
Run Date :
Covid Active vs New Case
User :
Week No.
Confirm Cases
Quarantine Case
Discharge Case
sub(new DateInterval('P10W')); //created 30 days interval back
$end = new DateTime();
$end = $end->modify('+7 day'); // interval generates upto last day
$interval = new DateInterval('P1W'); // 1d interval range
$daterange = new DatePeriod($begin, $interval, $end); // it always runs forwards in date
foreach ($daterange as $date) { // date object
$new_week = date("W", strtotime($date->format("Y-m-d"))); // your date
?>