Sending Mass emails

Shaun · 09-27-2007, 10:43 PM

I'm writing a script to send out an email to over 2.5k of subscribed users, and am unsure on the best approach to do so, the following is what i have so far

PHP Code:


			
<?php
    $data  = Sql::query("SELECT * from newsletter WHERE validated = 1");
        
    while($newsletter = mysql_fetch_array($data))
    {
        if($i>0){
            $bcc .= ", ";
        }
        $bcc .= $newsletter['email'];
        $i++;
    }
    $subject = "Newsletter - " . $title;
    $contents = "Testing email system";
        $headers = 'From: admin@domain.net.au' . "\r\n" .
        'Reply-To: admin@domain.net.au' . "\r\n" .
        'X-Mailer: Mailing System - PHP/' . phpversion() . "\r\n";
    $headers .= 'Bcc: ' . $bcc . "\r\n";
    $to = "No Reply <noreply@domain.net.au>";
    mail($to, $subject, $contents, $headers);
?>

Any help on this would be great :D

Wildhoney · 09-27-2007, 11:05 PM

Well, BCC, as you are doing there, is clearly the best way. It won't be a user-side action so you have no real worries about the speed of returning ~2,500 e-mails from the database.

What exactly are you asking? As in my opinion you're going about it right the way as it is.

Shaun · 09-28-2007, 12:04 AM

I was just checking to see if that was the best way to do it, im yet to try it on the mail list database

Wildhoney · 09-28-2007, 12:33 AM

Definitely the best way that I can see. The only other way is to issue the mail() function ~2,500 times which would be a complete disaster!

Shaun · 09-28-2007, 03:01 AM

lol yep.

I just hope the mail() function can handle the thrashing of 2.5k emails being pumped into it