$mail->SetFrom(MAIL_FROM, 'SEffervescence IIITA'); $mail->From = MAIL_FROM; //From Address -- CHANGE --^M $mail->FromName = "Effervescence IIITA"; //From Name -- CHANGE --^M $mail->AddAddress($subscriberEmail, ""); //To Address -- CHANGE --^M if(!$mail->Send()) { return 0; } return 1; } */ function getInactiveUsers() { $sql = "SELECT * FROM `users` WHERE isactive=0 AND isdeleted=0 ORDER BY `added_on` DESC LIMIT 151,200"; $result = DatabaseHandler::GetAll($sql); return $result; } function updateIssent($username) { $sql = "UPDATE users SET issent=1 WHERE username=:username"; $params = array(':username' => $username); $result = DatabaseHandler::Execute($sql, $params); } $iUsers = getInactiveUsers(); for ($i = 0; $i < count($iUsers); $i++) { echo $iUsers[$i]['email'] . "<br/>"; sendAccountConfmail($iUsers[$i]['username']); updateIssent($iUsers[$i]['username']); } sendAccountConfmail('testingAgain'); updateIssent('testingAgain');
<?php require_once "config/config.php"; require_once "models/database.php"; require_once "api/contentFunctions.php"; require_once "api/sessionFunctions.php"; require_once 'api/mailFunctions.php'; require_once "business/Database_handler.class.php"; require_once "business/Link.class.php"; function getInactiveUsers() { $sql = "SELECT * FROM `users` WHERE isactive=0 AND isdeleted=0"; $result = DatabaseHandler::GetAll($sql); return $result; } $iUsers = getInactiveUsers(); for ($i = 0; $i < count($iUsers); $i++) { echo $iUsers[$i]['email'] . "<br/>"; sendAccountConfmail($iUsers[$i]['username']); // sendAccountConfmail('test'); }