php email send list from mysql database

Question

I am trying to create an email send list from a mysql database that will only send to the recieptant if it is the correct day, i want an individual email send per person, i can do it no problem if they are all in the "To: " field. Here is what I have no

 <?
 $freq=date("N");

//get email address's

$result = mysql_query("SELECT * FROM email_list ");

while($row = mysql_fetch_array($result))
{

 if($row['period']=="daily"){     
 $to="To: ".$row['name']." <".$row['email'].">\r\n";
 $subject="Your exchange rate update";
 $headers  = 'MIME-Version: 1.0' . "\r\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
 $headers .="To: ".$row['name']." <".$row['email'].">\r\n";
 $headers .= "From: ME <[email protected]>" . "\r\n";
 mail($to, $subject, $email, $headers);
 }
 if($row['period']==$freq){
   $to="To: ".$row['name']." <".$row['email'].">\r\n";
 $subject="Your exchange rate update";
 $headers  = 'MIME-Version: 1.0' . "\r\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
 $headers .="To: ".$row['name']." <".$row['email'].">\r\n";
 $headers .= "From: name <[email protected]>" . "\r\n";
 mail($to, $subject, $email, $headers);
     }

}   
 ?>

No emails are sent and get no error messages.

are you running the code in local or in web server?

Damian SIlvera
– Damian SIlvera

2012-09-06 15:23:16 +00:00
Commented Sep 6, 2012 at 15:23 — Damian SIlvera
– Damian SIlvera, Commented Sep 6, 2012 at 15:23

Mike Brant · Accepted Answer · 2012-09-06 15:22:57Z

1

You don't put "To:" into the string that is passed as first parameter to mail().

answered Sep 6, 2012 at 15:22

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1652443 Over a year ago

when i take out the "if" statements, the code works perfect, with the "if" statements nothing works

Mike Brant Over a year ago

Ahh.. yes per one of the other answers, you are only retrieving the email filed from the DB with your query, you are not selecting the 'period" field, so there would be no value in $row['period']

raidenace · Accepted Answer · 2012-09-06 15:28:07Z

1

You are only selecting email field from table, but while generating the mail headers To address, you are trying to access both $row['name'] and $row['email'].

$row['name'] might be giving an undefined index warning, messing up headers and subsequent email sending.

UPDATE: I see that you have updated the query to select * instead of select email. As a tip, instead of silently updating the question like so, please update it with comments and also let the folks know if any of the change you did helped/changed the behavior based on the original code posted.

It becomes hard when someone looks at the code posted in the question and finds that the answers posted are totally not related to it..

edited Sep 6, 2012 at 15:28

answered Sep 6, 2012 at 15:23

raidenace

12.8k1 gold badge34 silver badges35 bronze badges

2 Comments

user1652443 Over a year ago

i just made the mistake when i posted it :(

raidenace Over a year ago

no problemo :) - after select * it is still not working? If not basically what is happening is that period is being stored in a different format in your database than what is derived using date(N) What value does $row['period'] have?

Doug Molineux · Accepted Answer · 2012-09-06 15:22:13Z

0

When you SELECT email the $row array will only contain $row["email"]

Also try to echo the response of the mail function, and turn error reporting on:

error_reporting(-1);

You are also going to need a functioning mail server on the system this code is running on:

http://php.net/manual/en/function.mail.php

answered Sep 6, 2012 at 15:22

Doug Molineux

12.5k26 gold badges96 silver badges144 bronze badges

Comments

Salketer · Accepted Answer · 2012-09-06 15:23:09Z

0

You select "email" only. $row['period'] is empty since it is not selected in your query. So both if are False, thus no e-mail is sent.

answered Sep 6, 2012 at 15:23

Salketer

15.8k2 gold badges32 silver badges64 bronze badges

Comments

Abid Hussain · Accepted Answer · 2012-09-06 15:24:53Z

try this

<?
 $freq=date("N");

//get email address's

$result = mysql_query("SELECT * FROM email_list ");

while($row = mysql_fetch_array($result))
{

 if($row['period']=="daily"){     
 $to=$row['name']." <".$row['email'].">\r\n";
 $subject="Your exchange rate update";
 $headers  = 'MIME-Version: 1.0' . "\r\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
 $headers .="To: ".$row['name']." <".$row['email'].">\r\n";
 $headers .= "From: ME <[email protected]>" . "\r\n";
 mail($to, $subject, $email, $headers);
 }
 if($row['period']==$freq){
   $to=$row['name']." <".$row['email'].">\r\n";
 $subject="Your exchange rate update";
 $headers  = 'MIME-Version: 1.0' . "\r\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
 $headers .="To: ".$row['name']." <".$row['email'].">\r\n";
 $headers .= "From: name <[email protected]>" . "\r\n";
 mail($to, $subject, $email, $headers);
     }

}   
 ?>

Collectives™ on Stack Overflow

php email send list from mysql database

5 Answers 5

2 Comments

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related