Esempi in PHP per DonationEmails::SendCampaignDeleteDateWiseEmail

Esempio n. 1

File: deleteCampaignList.php Progetto: sanketdhotre/PetAppAPI

$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();
}