Send Email To all Email Adress Inserted Into MYSQL Database Using PHP

Question

I want to send newsletter to my subscribers. The email adress of my subscribers are inserted into MYSQL database.

This below coding i am using to send.

<?php if(isset($_POST['send'])){
$servername = "localhost";
$username = "#";
$password = "#";
$dbname = "db_table";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT ALL email FROM db_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {while($row = $result->fetch_assoc()){
$emails = $row["email"];
}
} else {
}
$conn->close();

$email_to = "$emails";
$headers = "From:" . "noreply@website.in";
$subject = "Newsletter";
$message = 'Hello There,

This is and Test email.

Thank you';
mail($email_to,$subject,$message,$headers);
}
?>

But this is not working. Any help?

I'm not able to understand `SELECT ALL email..` what you trying to do — Saty, Apr 20 '16 at 10:14
i have 15+ emails in my database and i want to send emails to those email addresses. — Rahul, Apr 20 '16 at 10:19
Use this to get all email `while($row = $result->fetch_assoc()){ $email_array[] = $row["email"]; } } $emails = implode(",",$email_array);` — Saty, Apr 20 '16 at 10:20

score 0 · Answer 1 · answered Apr 20 '16 at 10:18

0

Try something like this. I am assuming your code is working for one email.

if ($result->num_rows > 0){
   $email_array = array();
   while($row = $result->fetch_assoc()){
       $email_array[] = $row["email"];
   }
}
$emails = implode(",",$email_array);

answered Apr 20 '16 at 10:18

Niklesh Raut

34,013
16
75
109

score 0 · Answer 2 · answered Apr 20 '16 at 10:20

Try something like that:

 <?php if(isset($_POST['send'])){
 $servername = "localhost";
 $username = "#";
 $password = "#";
 $dbname = "db_table";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
 }

 $sql = "SELECT email FROM db_table";
 $result = $conn->query($sql);

 if ($result->num_rows > 0) {while($row = $result->fetch_assoc()){

      $email_to = $row["email"];
      $headers = "From:" . "noreply@website.in";
      $subject = "Newsletter";
      $message = 'Hello There,

      This is and Test email.

      Thank you';
      mail($email_to,$subject,$message,$headers);

 }
 } else {
 }
 $conn->close();


 }
 ?>

Send Email To all Email Adress Inserted Into MYSQL Database Using PHP

2 Answers2