PHP send email with loop data

Question

Hi I want to send loop data with php mail function here is my code:

foreach ($data['query'] as $row){
    echo $row->name;
    echo "<br>";
    echo $row->time;
    echo "<br>";
    echo $row->dosage;
    echo "<br>";
    echo $row->frequency;
    echo "<br>";
    echo $row->quantity;
    echo "<br>";
}

$to = "[email protected]";
$subject = "My subject";
$txt = "Hello world!";
$headers = "From: [email protected]";
mail($to,$subject,$txt,$headers);

Can anybody told me how I can attach foreach loop data to email message body, I mean instead of sending this text (Hello World!) in body I want to send loop data.

Mihai Iorga · Accepted Answer · 2012-09-08 08:32:26Z

1

Concatenate the $txt:

$txt = "";
foreach ($data['query'] as $row){
    $txt .= $row->name;
    $txt .= "<br>";
    $txt .= $row->time;
    $txt .= "<br>";
    $txt .= $row->dosage;
    $txt .= "<br>";
    $txt .= $row->frequency;
    $txt .= "<br>";
    $txt .= $row->quantity;
    $txt .= "<br>";
}

$to = "[email protected]";
$subject = "My subject";
$headers = "From: [email protected]";
mail($to,$subject,$txt,$headers);

answered Sep 8, 2012 at 8:32

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

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

2 Comments

h_h Over a year ago

Only one problem left that <br> is not working in sent mail can you help?

Mihai Iorga Over a year ago

you have to set headers as HTML or add $txt .= "\n"; instead of <br>

thecodeparadox · Accepted Answer · 2012-09-08 08:32:38Z

1

Purely String Concatenation like below:

   $str = ''; 
   foreach ($data['query'] as $row){
      $str .= $row->name;
      $str .= "<br>";
      $str .= $row->time;
      $str .= "<br>";
      $str .= $row->dosage;
      $str .= "<br>";
      $str .= $row->frequency;
      $str .= "<br>";
      $str .= $row->quantity;
      $str .= "<br>";
    }

    $to = "[email protected]";
    $subject = "My subject";
    $headers = "From: [email protected]";
    mail($to,$subject,$str,$headers);

    $str = ''; // empty the $str again

answered Sep 8, 2012 at 8:32

thecodeparadox

87.2k22 gold badges143 silver badges164 bronze badges

Comments

JvdBerg · Accepted Answer · 2012-09-08 08:33:54Z

I think this is what you are after:

    $to = "[email protected]";
    $subject = "My subject";
    $txt = "Hello world!";
    $headers = "From: [email protected]";

    foreach ( $data['query'] as $row ) {
      $txt = $row->name;
      $txt .= "<br>";
      $txt .= $row->time;
      $txt .= "<br>";
      $txt .= $row->dosage;
      $txt .= "<br>";
      $txt .= $row->frequency;
      $txt .= "<br>";
      $txt .= $row->quantity;
      $txt .= "<br>";

      mail( $to, $subject, $txt, $headers );
    }

This sends a mail for every loop. It is unclear from your question if you want that. You can als collect all data, and send it as 1 email:

$to = "[email protected]";
$subject = "My subject";
$txt = "";
$headers = "From: [email protected]";

foreach ( $data['query'] as $row ) {
  $txt .= $row->name;
  $txt .= "<br>";
  $txt .= $row->time;
  $txt .= "<br>";
  $txt .= $row->dosage;
  $txt .= "<br>";
  $txt .= $row->frequency;
  $txt .= "<br>";
  $txt .= $row->quantity;
  $txt .= "-- end of row<br>";

}

mail( $to, $subject, $txt, $headers );

Tarun · Accepted Answer · 2012-09-08 08:40:50Z

0

<?php
$dataArray  =   array('name','time','dosage','frequency','quantity');
$txt        =   '';
foreach ($data['query'] as $row)
{
    foreach($dataArray as $key=>$data)
    {
       $txt .= ($row->$data.'</br>');
    }
}

$to = "[email protected]";
$subject = "My subject";
$txt = "Hello world!";
$headers = "From: [email protected]";
mail($to,$subject,$txt,$headers);

?>

answered Sep 8, 2012 at 8:40

Tarun

3,1754 gold badges33 silver badges52 bronze badges

Collectives™ on Stack Overflow

PHP send email with loop data

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related