Send Email with PHP Code

Question

I'm trying to send an email in PHP that is written with CKEditor, or HTML. When the email is sent the HTML code appears in the email, I know it but the Headers already tried putting immense and none works.

Below is my code to send the email.

function mail_users($titulo, $conteudo){
$query = mysql_query("SELECT `Email`, `Nome` FROM `utilizadores` WHERE `Newsletter` = 'Ativada'");
while (($row = mysql_fetch_assoc($query)) !== false){
 $header .= "MIME-Version: 1.0\r\n";
 $header .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
email($row['Email'], $titulo, "Olá " . $row['Nome'] . ",\n\n" .  $conteudo, $header);
}
}

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

You should do this way..

Move the header outside of the while loop.
You are doing a mistake in concatenation.
Function should be mail() instead of email() [Unless you have written a wrapper for the same]

The right way....

function mail_users($titulo, $conteudo){
    $query = mysql_query("SELECT `Email`, `Nome` FROM `utilizadores` WHERE `Newsletter` = 'Ativada'");
    
    $header = "MIME-Version: 1.0\r\n";
    $header .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
    while (($row = mysql_fetch_assoc($query)) !== false){
        
        mail($row['Email'], $titulo, "Olá " . $row['Nome'] . ",\n\n" .  $conteudo, $header);
    }
}

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Apr 21, 2014 at 11:23

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

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

3 Comments

Shankar Narayana Damodaran Over a year ago

The function should be mail why are using email() ? Did you make that change ?

LuisMiguelGT Over a year ago

i change this to mail($row['Email'], $titulo, "Olá " . $row['Nome'] . ",\n\n" . $conteudo, $headers); but doesn't work..

Shankar Narayana Damodaran Over a year ago

@LuisMiguelGT, So the mail() was the problem :)

ashutosh · Accepted Answer · 2014-04-21 11:40:19Z

0

Try this i think you just have to make header blank each time it enter into the loop.

and check

@mail($email, $subject, $message, $headers);

the last line has all the values accordingly .

function mail_users($titulo, $conteudo){
$query = mysql_query("SELECT `Email`, `Nome` FROM `utilizadores` WHERE `Newsletter` ='Ativada'");
while (($row = mysql_fetch_assoc($query)) !== false){
$header='';
 $header .= "MIME-Version: 1.0\r\n";
 $header .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
@mail($row['Email'], $titulo, "Olá" . $row['Nome'] . ",\n\n" .  $conteudo, $header);
}
}

answered Apr 21, 2014 at 11:40

ashutosh

817 bronze badges

Comments

Satish Sharma · Accepted Answer · 2014-04-21 11:41:11Z

0

try this

function mail_users($titulo, $conteudo)
{
    $header = "MIME-Version: 1.0\r\n";
    $header .= "From: [email protected]";
    $header .= "Content-Type: text/html; charset=ISO-8859-1\r\n";

    $query = mysql_query("SELECT `Email`, `Nome` FROM `utilizadores` WHERE `Newsletter` = 'Ativada'");
    while($row = mysql_fetch_assoc($query))
    {

         mail($row['Email'], $titulo, "Olá " . $row['Nome'] . ",\n\n" .  $conteudo, $header);
    }
}

answered Apr 21, 2014 at 11:41

Satish Sharma

9,6356 gold badges31 silver badges52 bronze badges

Collectives™ on Stack Overflow

Send Email with PHP Code

3 Answers 3

The right way....

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

The right way....

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related