Hey,
How can I send emails to all emails on my database? E.g. here is my format of MYSQL.
MYSQL -- Table = users --- column = email. I need to send emails to everyone of the email on column "email".
Thanks if anyone can help me out.
+3
A:
Simple ready to use PHP script for sending mail from mysql data
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT email FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
sendMail($row[0]);
}
mysql_free_result($result);
function sendMail($to){
$subject = 'the subject';
$message = 'hello';
$headers = 'From: [email protected]' . "\r\n" .
'Reply-To: [email protected]' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);
}
?>
JapanPro
2010-09-25 12:27:41
After mytable theres "email".
Raymond
2010-09-25 12:57:23
mytable is your table name, email is your column of email , you can replace by your name.
JapanPro
2010-09-25 13:08:21
:O You scripted for free~! :)
Aditya Menon
2010-09-25 13:42:03
its will be paid if voted up or accepted as answer, ha ha:)
JapanPro
2010-09-25 13:46:17
There we go :) hope that helps
Raymond
2010-09-25 22:05:09
A:
Do you know how to pull data from MySQL? if so, you should just execute the mail() function for each row.
mkroman
2010-09-25 12:29:03
A:
The code that JapanPro suggested is great! However, I have read over the internet about doing this. If there is loads of emails to be sent it will take a long time and possible slow down your server and clog it up. I would recommend doing it in intervals. So like in sets of 10 or 20.
This is only based on the information I have read. And I can se where they are coming from.
hart1994
2010-09-25 22:20:20