I have a chart using Chart JS and The Labels is Monday, Tuesday, Wednesday, Thursday, Friday
and then this is my code
<?php foreach($connect->query(
"SELECT Process_Date,
COUNT(*)
FROM tb_main
WHERE DATE(Process_Date) = '2022-03-28 00:00:00'
GROUP BY Process_Date
LIMIT 1") as $row) {
echo $row['COUNT(*)'];}?>,
this code is repeated 5 times (to fill data every day).
I want to change that (‘2022-03-28 00:00:00’) Automatically every week. Example :
This week Monday until Friday is 2022-03-28 – 2022-04-01. and then the next week is automatically change to 2022-04-04 – 2022-04-08.
is it Possible?