07 DB Into mass emailer

[nemboy55]

Hey guys I have an 07 GunZ Database my old one with about 8-9k Emails
Would anyone have a script or program to send Theys emails out :O?

 

[qet123]

You must be registered to see links

You must be registered to see links

I have no knowledge about sql and php, but i would do a script that sens my message to all via collecting their email from db.

 

[Dave]

SELECT Email FROM Account, loop through it and send the mail to the email.

 

[qet123]

$data = mysql_query("SELECT Email FROM Account") 
<?php
 $to = $data;
 $subject = "Hi!";
 $body = "Hi,\n\nHow are you?";
 if (mail($to, $subject, $body)) {
   echo("<p>Message successfully sent!</p>");
  } else {
   echo("<p>Message delivery failed...</p>");
  }
 ?>

Is this right ? SuperWaffle?

 

[wesman2232]

Use a while statement to loop through all results from the DB

 

[Secured]

The Bellow Script will send the exact same message to everyone.

<?php

//run query to get emails
$query = mssql_query('SELECT Email FROM Account');

$data = array();

while($row = mysql_fetch_array($query)) {
    $data[] = $row['email'];
}

//will seperate emails by comma so they can all be sent as once
$to = implode(", ", $data);

//from
$from = "no-reply@yourwebsite.com";

//reply_to
$reply_to = "whodoyouwanttheusertoreplyto@yourwebsite.com";

//Email Headers
$headers  = "From: " . strip_tags($from) . "\r\n";
$headers .= "Reply-To: ". strip_tags($repy_to) . "\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";

//Email Subject
$subject = "Test mail";

//Message May Include HTML sense its content type is defined as text/html in header
$message = "<b>Hello!</b><br /> This is a simple email message.";

mail($to,$subject,$message,$headers);

?>

I coded this without testing so ya, but I for that amount of emails I would use, PHPMailer or something that works well with sending bulk emails.

EDIT:
If you want to send customized messages to every user (like username in email) you can do so by,

<?php

//run query to get emails
$query = mssql_query('SELECT * FROM Account');

//from
$from = "no-reply@yourwebsite.com";

//reply_to
$reply_to = "whodoyouwanttheusertoreplyto@yourwebsite.com";

//Email Headers
$headers  = "From: " . strip_tags($from) . "\r\n";
$headers .= "Reply-To: ". strip_tags($repy_to) . "\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";

//I would put subject here if its not different for every user else u can put it in the while() loop.
$subject = "Test mail";

while($row = mysql_fetch_array($query)) {
    //Email Subject
    $message = "<b>Hello!</b><br /> This is a simple email message. <br />Your username is". $row['UserID'];
    mail($row['email'],$subject,$message,$headers);
}

?>

 

[trunksx]

send just 30 emails you will get blacklisted for the spam filters

 

[Dawson]

This is a really bad idea, and if I got a mass e-mail spam I would stay away from whatever content that e-mail is trying to advertise. Scumbag way to get your info out. Never mass e-mail.