<?php include('config/main_function.php'); require("PHPMailer/class.phpmailer.php"); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $date_now = date('Y-m-d'); $sql = "SELECT l.effective_date , lm.member_id FROM `tbl_certification_lot_member` lm LEFT JOIN tbl_certification_lot l ON lm.certification_lot_id = l.certification_lot_id;"; $res = mysqli_query($connection, $sql); while ($row = mysqli_fetch_assoc($res)) { $last_date = new DateTime($row['effective_date']); $last_date->modify('+1 year'); echo $last_cer_date = $last_date->format('Y-m-d'); $effective_date = new DateTime($row['effective_date']); $effective_date->modify('+1 year'); echo $expire_cer_date = $effective_date->format('Y-m-d'); echo $sql_up = "UPDATE tbl_member SET last_cer_date = '$last_cer_date' ,expire_cer_date ='$expire_cer_date' WHERE member_id = '{$row['member_id']}'"; $res_up = mysqli_query($connection, $sql_up); }