How to send multiple emails at once using php mail?

[londres9b]

I want to send multiple emails from php with one unique script.
The emails are from a mysql database table.

How can I achieve this?

[Atli]

By using the mail() function.

All the information you could ever want on this subject is only a Google search away.

[londres9b]

I appreciate your help but either you didn't read what I posted or you ignored it..

I know how to use mail() function, I know how to send to multiple email addresses using mail() function.

But you didn't read the most important part - and it was in bold! -

The emails are from a mysql database table.

I need to retrieve the emails from the mysql table and then use the mail() function to send the emails.

How to do this?

P.S. Maybe should be on MySql topic...

[Atli]

Retrieving the addresses from the MySQL database is fairly simple. You just need to build a SQL query that will select them all (a simple SELECT query should do, but I don't really know you database well enough to say that for sure), and use the mysql_query function to execute it. Then you just loop through the results and send an email for each one. (The manual has excellent examples that show how that works.)

And as you already know how to send an email, this should be fairly straight forward. If you run into any problems, post your code here and we will try to help solve them.

P.S.
If you are new to database interaction in PHP, it may be a good idea to read through a couple of tutorials. PHP and MySQL is probably one of the most written about software combo on the internet, so you should have no trouble finding something you like :)

[londres9b]

I know how to retrieve the emails but I don't know how to loop through them and email each one.. I've searched but haven't find nothing on this.

[Atli]

Look at example #2 in the mysql_query entry in the manual. The lines inside the while loop is where you would put your mail() code.

If you change the SQL query in that example so that it gives you a list of email addresses, each iteration of the while loop will give you a new email address. You simply put the email code inside the loop and use the email address the loop provides.

Try it. If it doesn't work, post what you tried here and we will guide you through it.

[agbb0cg]

you should also sleep() the while for a couple of secs every 5/10 emails sent... ;)

[Dormilich]

if you’re out for some more advanced code, some mail libraries also suport batch sending of emails (including the DB queries to get the data).

[londres9b]

Thanks! I got it!

@agbb0cg

I've looked at sleep() but how can I implement it on my script?

[londres9b]

Here's my code:

<?php
 
//connect to database
 
$query = sprintf("SELECT * FROM mail");
 
$result = mysql_query($query);
 
while ($row = mysql_fetch_assoc($result)) {
    $email = $row['Email'];
    mail($email, 'My Subject', $message);
}
?>

[agbb0cg]

<?php
 
//connect to database
 
$query = sprintf("SELECT * FROM mail");
 
$result = mysql_query($query);
 
$count = 1;
while ($row = mysql_fetch_assoc($result)) {
    $email = $row['Email'];
    mail($email, 'My Subject', $message);
    if ($count % 5 == 0) {
      sleep(5); // this will wait 5 secs every 5 emails sent, and then continue the while loop
    }
    $count++;
}
?>

[londres9b]

@agbb0cg
thanks ! :)


@dormilich
No it's just something simple, but thanks :D


@Atli
Thanks for your help :)