Web Analytics Made Easy -
StatCounter PHP email converts new line to \r\n?! - CodingForum

Announcement

Collapse
No announcement yet.

PHP email converts new line to \r\n?!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • PHP email converts new line to \r\n?!

    Please help,

    When I sent an email like this:

    test body
    next line
    Mihály Csíkszentmihályi's 89th Birthday! #GoogleDoodle


    it came to my email like this:

    test body\r\nnext line\r\nwww.google.co.uk

    here is my code:
    PHP Code:
    <?php
    mysql_connect
    ("xxx""xxx""xxx");
    mysql_select_db("xxx");
    $EmailTitle mysql_real_escape_string($_POST['EmailTitle']);
    $EmailBody mysql_real_escape_string($_POST['EmailBody']);
    $id mysql_real_escape_string($_POST['id']);

    $query5 mysql_query("SELECT * FROM aarbookts_booking_bookings WHERE id = '$id'");
    $row5 mysql_fetch_array($query5);
        
    $customer_name $row5['customer_name'];

    $to $row5['customer_email'];
    $subject $EmailTitle;
    echo 
    $to;

    $message = <<<EOF
    <html>
      <body>
        <p>
    $EmailBody</p>
      </body>
    </html>
    EOF;
       
    //end of message
        
    $headers  "From: [email protected]\r\n";
        
    $headers .= "Content-type: text/html\r\n";

        
    //options to send to cc+bcc
        //$headers .= "Cc: [email][email protected][/email]";
        //$headers .= "Bcc: [email][email protected][/email]";
        
        // now lets send the email.
        
    mail($to$EmailTitle$message$headers);
       
    $msg "Mass email sent"
    header("Location: send-mass-email.php?msg=$msg"); 
      
    ?>

  • #2
    I assume that is provided by the $_POST['EmailBody']? These should NOT be run through a mysql_real_escape_string. They should instead be run through a str_replace and presumably followed by an nl2br:
    PHP Code:
    $EmailBody nl2br(str_replace("\r\n""\n"$_POST['EmailBody'])); 
    Mysql_real_escape_string is used ONLY for data being placed into a SQL query.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 
    Been gone for a few months, and haven't programmed in that long of a time. Meh, I'll wing it ;)

    Comment

    Working...
    X
    😀
    🥰
    🤢
    😎
    😡
    👍
    👎