使用MYSQL和PHP将星期几转换为当月的日期

Question

Spent a while searching and couldn't find any answers. Really simple question I hope.

In my database I have a string column dayOfWeek.

I use this to track what day of week weekly events are scheduled for. Usually I match the dayOfWeek to the current day using PHP and display the correct events.

What I want to do is show a calendar into the future which makes a list of the future dates of the weekly recurring event.

For example, if the event takes place on Tuesday, and Feb 2017 has Tuesdays on the 7th, 14th, 21st, and 28th. I'd like to use PHP to display as such.

I know strtotime() is used to do the opposite, find a day from the date, but can the opposite be done easily?

Sorry if my question is poorly worded or missing information.

Answer 1

USE CASE FOR FEB 2017 TUESDAYS

$n=date('t',strtotime("2017-02-01")); // find no of days in this month
$dates=array();
for ($i=1;$i<=$n;$i++){
     $day=date("D",strtotime("2017-02-".$i)); //find weekdays

    if($day=="Tue"){
        $dates[]="2017-02-".$i;
    }
}
print_r($dates);

http://phpfiddle.org/main/code/s8wq-xx44