$sql = mysqli_query($con, $lastDate); $NGODetails = array(); while ($rowdata = mysqli_fetch_assoc($sql)) { $NGODetails[] = $rowdata; } //mysqli_close($con); //print_r ($NGODetails); foreach ($NGODetails as $value) { $con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $campaign_id = $value['campaign_id']; $campaignName = $value['campaignName']; $ngoName = $value['ngoName']; $ngoOwnerEmail = $value['email']; $lastDateOfCampaign = $value['lastDate']; $postedDateOfCampaign = $value['postDate']; //send email $objCampaignDeleteDetails = new DonationEmails(); $objCampaignDeleteDetails->SendCampaignDeleteDateWiseEmail($campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $lastDateOfCampaign, $postedDateOfCampaign); } //delete todays campaign list try { $sql = "DELETE FROM campaign WHERE lastDate = 'currentDateTime'"; $isRemoved = mysqli_query($con, $sql); if ($isRemoved) { echo "Campign Successfully Deleted"; } else { echo "ERROR_WHILE_REMOVING"; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); }