[RESOLVED] Sending html email (generated by php query)

garfx

I have just created a shopping cart and I would like to send my user the receipt of there order by email. The receipt is generated by a mysql query and is displayed within a table. I have worked out how to send a html using simple HTML code as my “$message” variable:

$success = mail($to, $subject, $message, $headers);

But I can not get it to send my mysql query result displayed in a table.

How can i create the result of my mysql query and make it a simple variable i.e $message.

please help
G

fean0r

I made a function for my emails, I think it will help you get started.

# Email System
function c4email($email_to, $title, $message)
{
# Checking Vars
if (!$email_to) { c4error("You must define an email address."); }
if (!$title) { c4error("You must define an email title."); }
if (!$message) { c4error("You must define a message."); }
# Set Email Headers
$headers  = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .="From: YOURSITE.co.uk <sales@YOURSITE.co.uk>\r\n";
$messagen="
<BODY BGPROPERTIES='fixed' BACKGROUND='http://www.YOURSITE.co.uk/img/xmasback.jpg'>
<FONT FACE='MS Sans Serif,Courier,System' COLOR='#003300'>
$message
</font></body>";
# Send Mail
if(mail($email_to,$title,$messagen, $headers)) {
}
}

$message="<table><---insert table code + data--></table>";

garfx

thanks for the quick reply

i'm using something similar to that.. the problem i have is that $messagen would be the table below would this work?

G
$messagen="
<table width=100% border=0 cellspacing=10 cellpadding=0>

  <tr> 
    <td valign=top>ITEM</td>
    <td align=right>QTY</td>
  </tr>
  <tr> 
    <td height=1 colspan=2 valign=top bgcolor=#666666></td>
  </tr>
  <?php
		MYSQL_CONNECT("$host","$user","$pass");

mysql_select_db("$db");

$query = "SELECT *, titles.id AS tid, orders06.id AS oid FROM version INNER JOIN artists ON version.artist_id = artists.id INNER JOIN formats ON version.format_id = formats.id INNER JOIN titles ON version.title_id = titles.id  INNER JOIN orders06 ON version.id = orders06.version_id WHERE orders06.basket_id = '$_SESSION[basket]'";

    $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present

if (mysql_num_rows($result) > 0)	{
	while($row = mysql_fetch_object($result)) { 

	echo "

<tr> 
  <td valign=top><div class=artist>$row->artist</div>
   <div class=title> $row->title</div>
    $row->format - £$row->price (each)

	</td>
  <td align=right valign=top align=right>  $row->qty
  </td>
</tr>

	";

	//// work out the total price for each item (qty*price)

$orderprice = $row->qty*$row->price;
	$totalprice += $orderprice;
	}} 

?>
  <tr> 
    <td height=1 colspan=2 valign=top bgcolor=#666666></td>
  </tr>
  <tr> 
    <td >PRICE</td>
    <td align=right>&pound;<?php echo number_format ($totalprice, 2); ?></td>
  </tr>
  <tr> 
    <td height=1 colspan=2 valign=top bgcolor=#666666></td>
  </tr>

</table>";

fean0r

This might be alittle messy but should work

Do the query loop outside of the code before you add to to $message or $messagen.

Add this to your loop (remove echo)

$purchases= "<tr><td valign=top><div class=artist> ".$row->artist."</div><div class=title> ".$row->title."</div> ".$row->format". - £".$row->price." (each)</td><td align=right valign=top align=right>". $row->qty."</td></tr>".$purchases."";

Then echo $purchases into your table.... I dont know if thats a backwards way of doing it but it will prob work.

garfx

thank you

works a treat!