sending database info with mail()

[rtown]

just curious as to how I could send multiple database records through mail()...have to wrap all associated records for a customer in my db and send it as an order invoice in table form. Also I am posting to my sending script from the checkout page of my shopping cart, is there any way to take all the info from the checkout page instead of querying the db, they aren't in form elements, they are just echoed variables from the db for the specified customer and their session.

any ideas would help...checked out lots of sites, but none touch base on mail from a database or complex mail bodies.

[dinger]

Use a variable $message as the message body of your email.

before sending the email, loop through the records you need to add to the email.

here is some pseudocode that may help you.

$message="Thank you for your recent order.\n\n"
for(i==0;i < count($arrayOfRecords; i++)
{

$message="$message.$arrayOfRecords\n";

}

mail($UserEmail,"Thank you for your order", $message);


The syntax is probably not correct, but the logic should be.


Chris

[rtown]

had someone post this idea to me, mostly cause some mail apps not renderin HTML....

---

you may just send a HTML email with your checkout page (or just a part of that page) to your customer.

#################################

<?php

// Build the HTML document $htmlDoc for your checkout page and kkep the part of the page you want to send as $htmlEmail. ($htmlEmail just contain the information needed for the invoice)

// send the email
$to = "[e-mail]";
$from = "[e-mail]";
$subject = "Invoice";
$body = "Thanks! Here is blablablabla... $htmlEmail I hope you blablablabla";
$headers="Content-Type:text/html;CHARSET=iso-8859-8-i\r\n";
$headers.="From:".$from."\r\n";
mail($to, $subject, $body, $headers);

// send the checkout page to the customer browser
echo $htmlDoc

?>

---

the only thing is I don't know I would store the pages as variables, can anyone catch and possibly expand what he is trying to explain for the $htmlDoc $htmlEmail and how to declare those.