mailing list

itworks

i have a client that want's to be able to send a kind of newsletter to all of the users that are registred in his site, my guess is that i have to use a loop but i'm kind of confused how to make one with with the mail function.

any help, please?

thanks in advance.

cgraz

$subject = "subject here";
$msg = "message";
$headers = "From: [email]you@yourdomain.com[/email]";


$query = mysql_query("SELECT email FROM table");
   while($row = mysql_fetch_array($query)) {

  $to_email = $row["email"];

  mail($to_email, $subject, $msg, $headers);

}

Cgraz

Frederick

set the email in a loop and the mail function

$subject = "Subject here";
$replyto = "email address";
$message = "Whatever";

while($row = mysql_fetch_array($result)) {
$email = "".$row["email"].",";
}

mail("$email","$subject",'$message","From:$replyto");

I have had to do the same thing before. This will get your started.

itworks

thanks a lot!!

i feel kinda stupid for making a question that has such a simple answer, but i'm new to this and real new to the mail thing, i still don't know how it is formated, can you believe it?

anyway thanks! 🙂

itworks

i have another question if you would be so kind to answer, how can i format an email message (in html) so that i can put images, text and links to use in this function?

thanks in advance!

cgraz

just put your html in a php variable and send like normal. However, don't use relative paths for anything. When the user opens his email, he's not on your server, so the relative paths will do no good. Use full paths. And for html email, you must use the following headers:

$headers  = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

Cgraz

itworks

thanks a lot cgraz!

so if i want to include an image that i have in my server i just use http://www.mydomain.com/image.jpg, right? ok i got it.

thanks again.

itworks

this is more like a mass mail that allows the administrator of the site to send an email to all users, for this i can use the loop code you gave me, right?

but what if the administrator want's to send an attached file with the email with the monthly catalogue, what changes do i have to put in the code to send an attachment?

thanks in advance.

cgraz

I think you just set the mail headers, but I'm not sure cause I've never actually done it myself. Have a look around www.php.net/mail or search these forums. I know I've seen this question asked before. You should be able to find an answer.

Good luck.

Cgraz

Leonardo_Dantas

I sending email through the function mail(). However, when an email does not exist or when it does not arrive in its destination, no message of error is returned has as to make it ???if an email not to arrive at its destination it to return for me, equal to outlook makes.

Thanks,
!Leonardo Dantas.

itworks

thanks to all, i have it running well now!

rklapwijk

the result mail() gives is only if php could send the request to send the email. If the result is true, it doesn't mean the email actually has been send or received. As far as i know it's not possible with mail().