php - Display the first and last day of a (calendar) week

one text

Solution:

See a test of this here: https://www.tehplayground.com/c2dOYxxwIa9LDscW

while($row = $statement->fetch()) {
$thedate = $row['Date'];
$dow = date('w', strtotime($thedate)); // the day of the week of the date - number based - zero is sunday
$dowsun = date('Y-m-d', (strtotime($thedate) - ($dow * 60*60*24))); // first day of that week (sunday)
$dowsat = date('Y-m-d', strtotime($thedate) + ((6-$dow) * 60*60*24)); // last day of that week (saturday)

/* for example:
   if $row['WEEK(Date)'] = "2021-06-08" which is a Tuesday
   $dowsun = "2021-06-06" which is a Sunday
   $dowsat = "2021-06-12" which is a Saturday
   with this answer you get the full week that contains the target date
*/
   echo "<tr>";
   echo "<td>".$row['WEEK(Date)']."</td>";
   echo "<td>".$row['Date']."</td>";

Source