Zoom Meetings
‘once'”;
$result = mysqli_query($conn,$query);
$today = date(‘Y-m-d’);
$todayp7 = date(‘Y-m-d’,strtotime($today . ‘ + 7 days’));
if($result)
{
while($row = mysqli_fetch_array($result))
{
$date = $row[‘date’];
if($date < date("Y-m-d"))
{
$meeting_name = $row['meeting_name'];
$regular_day = $row['regular_day'];
if(substr($regular_day,0,6) == "every ") //If the event is every week
{
$regular_day = substr($regular_day,6);
$date_definition = $regular_day;
$new_date = date('Y-m-d',strtotime($date_definition));
} else { //if event is not every week
$date_definition = $row['regular_day'] . ' of this month';
$new_date = date('Y-m-d',strtotime($date_definition));
// if date has passed, get next month's date
if ($new_date < $today)
{
$date_deinition = $row['regular_day'] . ' of next month';
$new_date = date('Y-m-d',strtotime($date_deinition));
}
}
$sql = "UPDATE zoom_fall_2021 SET date = '$new_date' WHERE meeting_name = '$meeting_name'";
$result_update = mysqli_query($conn,$sql);
}
}
}
?>