Newsletter

[adhbvklwqdbviabjiawdnbij]

Is there anything I should change on this code? I'll use it to send about 20000 emails... I don't like this one, because while sending the emails, the page keep loading... I kind dont "trust" on this script..

 

index.php

<?php

include('config.php');
include('class.phpmailer.php');
include('email.php');

// Get users info
$getUser_sql_not_sent = "SELECT * FROM emails WHERE sent = '0'";
$getUser_not_sent = mysql_query($getUser_sql_not_sent);
$getUser_num_not_sent = mysql_num_rows($getUser_not_sent);

$getUser_sql_sent = "SELECT * FROM emails WHERE sent = '1'";
$getUser_sent = mysql_query($getUser_sql_sent);
$getUser_num_sent = mysql_num_rows($getUser_sent);

$getUser_sql_all = "SELECT * FROM emails";
$getUser_all = mysql_query($getUser_sql_all);
$getUser_num_all = mysql_num_rows($getUser_all);

$getUser_sql_accessed = "SELECT * FROM emails WHERE accessed = '1'";
$getUser_accessed = mysql_query($getUser_sql_accessed);
$getUser_num_accessed = mysql_num_rows($getUser_accessed);

$money = $getUser_num_accessed * 0.20;
$money_formated = number_format($money, 2, ',', '');

$x = $getUser_num_sent * 100;
$y = $getUser_num_all;
$percentage = $x / $y;
$percentage_formated = number_format($percentage, 0, '', '');

if ($getUser_num_not_sent == $getUser_num_all) {
echo '<form action = "send.php" method = "post">';
echo '<strong>Assunto do Email</strong><br />';
echo $emailSubject;
echo '<br />';
echo '<strong>Corpo do Email</strong><br />';
echo $emailBody;
echo '<br /><br />';
echo '<input name = "send" type = "submit" value = "Enviar Emails" />';
echo '</form>';
} else {
echo "Foram enviados " . $percentage_formated . "&#37; dos emails. " . $getUser_num_accessed . " acessaram o site, bonificação de R&#36; " . $money_formated . " para o Claudius Ibn.";
}

?>

 

<?php 

include('config.php');
include('class.phpmailer.php');
include('email.php');

echo 'Os emails estao sendo enviados, voce pode sair do site que o processo continuara mesmo assim.';

// Get users info
$getUser_sql_not_sent = "SELECT * FROM emails WHERE sent = '0'";
$getUser_not_sent = mysql_query($getUser_sql_not_sent);
$getUser_num_not_sent = mysql_num_rows($getUser_not_sent);

$mail = new PHPMailer();

while ($row = mysql_fetch_array($getUser_not_sent)) {
// Get the current user's email
$emailUser = $row['email'];
// Define mail object and mail parameters
$mail -> From = '[email protected]';
$mail -> FromName = 'Campainha';
$mail -> AddAddress($emailUser);
$mail -> Subject = $emailSubject;
$mail -> Body = $emailBody;
// Send and verify
if(!$mail -> Send()) {
	echo 'Erro: '. $mail -> ErrorInfo;
} else {
	mysql_query("UPDATE emails SET sent = '1' WHERE email = '$emailUser'");
}
sleep(30);
}

?>

 

 

[Freedom-n-Democrazy]

There is a good book on Amazon you should check out.

 

http://www.amazon.com/Wicked-Cool-PHP-Real-World-Difficult/dp/1593271735/ref=sr_1_1?s=books&ie=UTF8&qid=1316837912&sr=1-1

[adhbvklwqdbviabjiawdnbij]

Thanks...

 

How can i make the script run in "background"? How can i make the script send 10 email every 30 seconds?

[Freedom-n-Democrazy]

With this:

 

http://php.net/manual/en/function.sleep.php

[adhbvklwqdbviabjiawdnbij]

Ok, i know how to send one email every 30 seconds, but how to send 10 emails every 30 seconds?

[Freedom-n-Democrazy]

Could you please post your solution so others may benefit from it.