How to send email to Multiple recipients that are in database table?

Question

I have the below code. I usually send an email to one recipient. My question is how can I modify for it to send to multiple recipients that are in my database.

Suppose I have a table called "tblemails" and a column called "email".

Note:

I also dont want to show all address to each member of my list (something like using Bcc).

Please Help?

<?php
ini_set( 'display_errors', 1 );
error_reporting( E_ALL );
$from = "sender@gmail.com";
$to = "receiver@gmail.com";
$subject = "Online order";
$message = "You just ordered";
$headers = "From:" . $from;
mail($to,$subject,$message, $headers);
?>

I assume (going by the e-mail subject) each e-mail is going to be different, so use a loop. Or if you're going to be sending a lot of e-mails, perhaps use a bulk mail service. — Jonnix, Aug 27 '19 at 11:12
You can't using the simple php native approach. Instead you need to use a smtp client implementation. Using that you can name as many recipients as you like (and as that smtp server you are using allows). — arkascha, Aug 27 '19 at 11:12

score 2 · Answer 1 · answered Aug 27 '19 at 11:14

2

I am sure you can fetch the email data from the database,

You can update header string as

$headers .= 'BCC: '. implode(",", $emailData) . "\r\n";

$emailData - Should be 1-D array which should contains all email ids. ref

answered Aug 27 '19 at 11:14

Rahul

18,271
7
41
60

score 1 · Answer 2 · answered Aug 27 '19 at 11:58

1

you can use while loop

$a = mysqli_query($con,"SELECT email FROM table");
while($row = mysqli_fetch_array($a)){$email = $row['email'];mail($email,$subject,$msg,$header);}}

answered Aug 27 '19 at 11:58

am tech science

11
2

Muhammed Shihabudeen Labba A · Accepted Answer · 2019-09-01T00:39:19.013

0

I hope you know how to fetch the email ids from the database.

$link = mysqli_connect("localhost", "root", "password", "DBName"); 

$sql = "SELECT * FROM tableA"; 
if ($res = mysqli_query($link, $sql)) { 
   if (mysqli_num_rows($res) > 0) { 
      while ($row = mysqli_fetch_array($res)) { 
         $recipients[] = $row['email'];
      }
   }
}

$to = 'some@email.com';
$bcc = implode(',', $recipients);
$headers .= 'From: noreply@company.com\r\n'; //here you can set sent from
$headers .= 'BCC: '.$bcc. '\r\n'; 
mail($to,$subject,$message, $headers);

edited Sep 01 '19 at 00:39

answered Aug 27 '19 at 11:17

Muhammed Shihabudeen Labba A

587
6
21

I don't know how to fetch the email ids from the database am still a beginner in PHP could you please help.. your method is working for me when i insert the recipients manually – HUBE Aug 27 '19 at 13:12
@HUBE Please check the code now. If it works, please accept the answer. – Muhammed Shihabudeen Labba A Aug 27 '19 at 14:36
Sorry for late reply, thank you its working but how do i add sent from Email? – HUBE Aug 29 '19 at 11:05
@HUBE, added the header code for 'From'. Please let me know whether it helps – Muhammed Shihabudeen Labba A Aug 29 '19 at 11:39
@ Muhammed It does not show the email I have set... I see the sent From "my database name" in the emails. – HUBE Aug 30 '19 at 19:14
Oh, that is really strange! I have just edited my answer with a new line code. – Muhammed Shihabudeen Labba A Sep 01 '19 at 00:40
@ Muhammed can you give me your email please? – HUBE Sep 01 '19 at 06:29
Is it allowed here to share personal details? Anyway here is my email if it helps, mslabba@hotmail.com – Muhammed Shihabudeen Labba A Sep 01 '19 at 13:54

How to send email to Multiple recipients that are in database table?

3 Answers3