Foreach loop within $message of PHP mail() function

Question

I have a loop that enters each non-empty text field into a database:

foreach ($guests as $guest) {

    if ($guest !== "") {
        mysql_query("INSERT INTO guestlists (guest, night, date) VALUES('$guest', '$night', '$date') ") or die(mysql_error());
    }
}

I'd like to also print each of these names into an email, which I presume somehow containing the output within the $message variable in mail(). How is this best achieved?

On a side note, changing from by editing $headers is proving very temperamental. What is the proper way of doing this?

Pavel Strakhov · Accepted Answer · 2012-06-13 22:14:59Z

5

For example:

$names = array();
foreach ($guests as $guest) {
    if ($guest !== "") {
        mysql_query("INSERT INTO guestlists (guest, night, date) VALUES('$guest', '$night', '$date')") or die(mysql_error());
        $names[] = $guest;
    }
}
$message = "Guests: ".implode(", ", $names).". ";

I hope you're sure that $guest, $night, $date variables are already passed through mysql_real_escape_string function.

answered Jun 13, 2012 at 22:14

Pavel Strakhov

40.8k6 gold badges93 silver badges131 bronze badges

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

4 Comments

Sebastian Over a year ago

Thanks for your reply. Is there any way of using <br> as the separator?

Pavel Strakhov Over a year ago

Of course. Just replace ", " to "<br>" in implode call.

Sebastian Over a year ago

I tried that but my email didn't render the HTML. Is this a problem with my client? Or could '\r' work?

Pavel Strakhov Over a year ago

Create another question and provide the code you're using to send emails in it.

Collectives™ on Stack Overflow

Foreach loop within $message of PHP mail() function

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related