send cart content in email

raffael3d

I have a webshop. People will out their form and add their address.

mail($email, $subject, $MailMsg, $mailheaders); 

$MailMsg = "
  $clientname
   $address";

now in the "mailMsg" I also want to include the products that the person ordered, but how can I add the content of a "while" into there?

I have no problems displaying it but how can I add it simply to the email?

here is how I get the data from the database.

$result = mysql_query("select * from shop WHERE sessionid='$sessionId'") or die ("could not read news database");
	if ($result)
	{
    while ($row = mysql_fetch_array($result))
    { 
print ($row["nummer"]);
 print ($row["title"]);
}}

thanks

remnant

One way would be to setup a variable in the while loop:

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

    print ($row["nummer"]); 
    print ($row["title"]); 

$receipt .= $row['number'] . " " . $row['title'] . "\n";
}

That will put each item in $receipt and will display one row after the otehr. Example

1 Item1
2 Item 2
etc...

raffael3d

thanks a lot, works great, only that the \n thing seems not to work which means it doesn't put the items on a new line.
any ideas why it's not working?

thanks.

remnant

is this an HTML formatted e-mail? If so, just replace \n with <br>

If it's a plain text email, maybe try \r instead.

raffael3d

actually it's just plain text and I know that the \n thing should work. I now also tried r but doesn't work either.

maybe the problem is that the $receipt string is sent through the URL of the browser window as I sent it via the variable there.

remnant

Oh, you're using the GET method?

I'm not sure if that would work or not, I'd need to see the source to help you further.

raffael3d

<?
// Data ist collected from database

$result = mysql_query("select * from shop WHERE sessionid='$sessionId'") or die ("could not read news database");
	if ($result)
	{

// variables put together in receipt to be sent later via email

	$receipt .= $row['qty'] . "   " . $row['nummer'] . " " . $row['title'] . "  " . $row['preis'] . "  " . $row['preis_total'] . "  " . $row['preis2'] . "   " . $row['preis_total2'] . " \r\n "; 

//using this button the data is sent in the url to the form where the user enters the shipping address:
		print("<a href=\"" . $_SERVER["PHP_SELF"] . "?order&result4=" . $result4[0] . "&result5=" . $result5[0] . "&receipt=" . $receipt ."&sid=" . $sessionId . "\">Go to address form</a>");


// the form where the user enters the infos
<form enctype="multipart/form-data" method="POST" action="<?php echo $PHP_SELF . "?send&result4=" . $result4 . "& result5=" . $result5 . "&receipt=" . $receipt ."&sid=" . $sessionId . "\""?>>


// the email is put together and sent

mail($email, $subject, $msg, $mailheaders); 

$msg = " $receipt ";

remnant

I would re-think the way your logic works. Maybe instead of using a link to pass the information use the POST method with hidden fields.

Barring that suggestion, maybe if you put single quotes around the variable when you pass it, it may work. For instance

You have &receipt=" . $receipt ."
Try &receipt='" . $receipt ."'