How to send array via email?

Question

I have problem to send array from database via email. I´m sure may people have got the same problem. I don´t know how to explain more but here is some script.

$sql="SELECT * FROM tb_xxx WHERE id_prd = '$ref_id_prd'";

        $result=mysql_db_query($dbname,$sql);
        while ($rs=mysql_fetch_array($result)) {

            $ref_id_prd=$rs[ref_id_prd];
                        $prd=$rs[prd];
                        $price=$rs[price];

text="$prd <br>$price";
}


$recipient = $iemail;
$subject = "my subject";

$headers = "From: [email protected] \n";
$headers .= "Reply-To: [email protected] \n";
$headers .= "MIME-Version: 1.0 \n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1 \n";


   $msg = $text;

   mail($recipient, $subject, $message, $headers);

write the vars in to a string, send the string.

user557846
– user557846

2012-01-26 21:20:59 +00:00
Commented Jan 26, 2012 at 21:20 — user557846
– user557846, Commented Jan 26, 2012 at 21:20

Michael Berkowski · Accepted Answer · 2012-01-26 22:00:30Z

3

You need to accumulate all the array values into a single string for the message body.

$text = "";
while ($rs = mysql_fetch_array($result)) {

        $ref_id_prd=$rs[ref_id_prd];
        $prd=$rs[prd];
        $price=$rs[price];

        // Use .= to append to the current value
        $text .= "$prd <br>$price\n";
}

To send it, use $text as the message body:

mail($recipient, $subject, $text, $headers);

Note, you will need to do additional formatting on the line below to get it looking the way you want in your HTML email:

$text .= "$prd <br>$price\n";

For example, you could make a list of products:

$text = "<ul>\n";
// inside the while loop...
$text .= "<li>$prd: $price</li>\n";
// After the loop, close the list
$text .= "</ul>"

Update: How to build it into an HTML table:

$text = "";

// Open the table:
$text .= "<table>\n";
// Table header...
$text .= "<thead><tr><th>Product</th><th>Price</th></tr></thead>\n";
// Open the table body
$text .= "<tbody>\n";

while ($rs = mysql_fetch_array($result)) {

        $ref_id_prd=$rs[ref_id_prd];
        $prd=$rs[prd];
        $price=$rs[price];

        // Build table rows...
        $text .= "<tr><td>$prd</td><td>$price</td></tr>";
}
// Close the table
$text .= "</table>";

edited Jan 26, 2012 at 22:00

answered Jan 26, 2012 at 21:20

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

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

2 Comments

Alex Over a year ago

Could you tell my how to put it in table ?

Alex Over a year ago

oh good, now I could finish my project by you, thanks again !

Shankar Narayana Damodaran · Accepted Answer · 2012-01-26 21:23:02Z

0

Replace your $message variable with $msg

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

answered Jan 26, 2012 at 21:23

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Collectives™ on Stack Overflow

How to send array via email?

2 Answers 2

Update: How to build it into an HTML table:

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Update: How to build it into an HTML table:

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related