Quick question about mail()

[ded]

I have a database file with about 10k email addresses.  Is it good to have a php program to scan through the database 1 record at a time and do the mail() for each record?  Is there a better way to do this?

 

Regards,

DED

[deansatch]

Yes. But you will have to make the script run in small portions depending on your host. If you run all 10k mail()'s in one go, your host will probably stop the script and give you a warning.

[landavia]

I have a database file with about 10k email addresses.  Is it good to have a php program to scan through the database 1 record at a time and do the mail() for each record?  Is there a better way to do this?

 

Regards,

DED

no.. that would be same as BOMB MAIL if you do that..

but if the reason are reasonable.. that's perhaps do

[dvd420]

Hi,

 

Don't you think scanning the db for each record will increase the overhead. Rather you should query the db only once, then use a loop through the result set array for sending out the mail. like, if you are using mySQL then:

 

.
.
.
$query = "SELECT firstname, lastname, address FROM mailing_list;";

//execute the query once, $result is an array
$result = mysql_query($query, $link);

//Loop for the results
while ($row = mysql_fetch_assoc($result))
{
    // Prepare the message here
    $msg = "Dear ".$row['firstname'] . $row['lastname'];
    $msg. = "More stuff here";
    mail($row['address'], 'My Subject', $msg);
}

 

[richrock]

You could use sleep() to create a pause inbetween each email sent.  The only problem is that the timing would be the same, and some isp's see this as spamming.

 

I'm not sure how the hosting would react to 10k emails being sent by one person.  I have mailing list capabilities on my hosting, but it's limited to 1,500 per list.

 

my 2c worth.

[dvd420]

Hi,

 

When I was using this approach to mail, I did two things to overcome the SPAM issue...

 

make the pause interval variable

.
$count = ($count + 1) % 10;
sleep( $count * $interval);
.

 

 

and the second thing was, to change the "From" address, message body & Subject line along with the sleep interval.

 

We can just add some dot(.)s or any char at the end of these strings.