including functions in an email

skdzines

I have posted this before and haven't really gotten any responses. I am trying to place products in a shopping cart that have been ordered into the body of an email. I can get it to display the total price of the cart and number of products order by calling $SESSION['items'] and $SESSION['total_price'] like so:

$useremail="$email, webmaster@mysite.com"; 
		$subject="Order Details";
		$header = "From: order@xyzcompany.com\r\n";
		$header .= "X=Mailer: PHP/";
		$body="Here are the details of your order:

	Contact Information:

	$firstName $lastName
	$address  $apt
	$city, $state $zip
	$country
	$phone

	Billing and Shipping Information:

	$bfirstName $blastName
	$baddress  $bapt
	$bcity, $bstate $bzip
	$bcountry

	Number of Items Ordered:  ".$_SESSION['items']."

	Order Total: \$".number_format($_SESSION['total_price'],2)."

	"; 
	mail ($useremail, $subject, $body, $header);

The session variables $SESSION['items'] and $SESSION['total_price'] call the functions calculate_items($SESSION['cart']); and calculate_price($SESSION['cart']); respectively.

however I have a function called display_checkout_cart($cart, $change=true, $images = 1) that queries the db to grab the product Name and price based on the productID.

I have foreach loop to display the productID, name, price, quantity and subtotal for each item and then the overall total at the bottom.

Everything works, except that I don't know how to have the display_checkout_cart function printed in the email that is sent to the user.

Can anyone help me?

Thanks

AstroTeg

I'm not sure I understand why you're not able to use display_checkout_cart($cart, $change=true, $images = 1) in your email code. Does display_checkout_cart() echo/print directly to the browser? If so, I'd swap this function to have it return a string of the formatted output. You'll have to update your cart code to echo this string back to the browser, but it would allow you to manipulate the string for the email.

But its not clear what display_checkout_cart() does and why you're not able to use it in with your email... Can you post some code or give more details?

skdzines

This is the code for the display_checkout_cart function:

function display_checkout_cart($cart, $change=true, $images = 1){
	//display items in shopping cart
	//optionally allow changes (true or false)
	//optionally include images

global $_SESSION;

echo("
	<table width='750' border='0' cellspacing='0' cellpadding='0'>
	<form action='/project/checkout.php' method='post'>
  <tr> 
	<td width='368'><p><font size='1' face='Verdana, Arial, Helvetica, sans-serif'><b>Product Name</b></font></p>
	<p>&nbsp;</p></td>
	<td width='138'><p><font size='1' face='Verdana, Arial, Helvetica, sans-serif'><b>Price</b></font></p>
	<p>&nbsp;</p></td>
	<td width='194'><p><font size='1' face='Verdana, Arial, Helvetica, sans-serif'><b>Qty</b></font></p>
	<p>&nbsp;</p></td>
	<td width='50'><p><font size='1' face='Verdana, Arial, Helvetica, sans-serif'><b>Total</b></font></p>
	<p>&nbsp;</p></td>
  </tr>
");

//display each item as a table row
	foreach($cart as $prod['productID'] => $qty){
	$prodInfo = mysql_fetch_array(mysql_query("select productPrice, productName from products where productID = ".$prod['productID'].""));
	echo ("
	<tr>
		<td><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>".$prodInfo['productName']."</font></td>
		<td><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>\$".number_format($prodInfo['productPrice'], 2)."</font></td>
		<td>");
		//if we allow changes, quantities are in text boxes
		if($change==true){
		echo("
		<font size='1' face='Verdana, Arial, Helvetica, sans-serif'><input type='text' name='".$prod['productID']."' size='2' value='".$qty."'>add/remove</font></td>
		");
		}else{
			echo(" <font size='1' face='Verdana, Arial, Helvetica, sans-serif'>$qty</font> ");
		}
		echo("
		<td><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>\$".number_format($prodInfo['productPrice'] * $qty, 2)."</font></td>
	  </tr>
	  ");
	 }
	 echo("
	 <tr>
	 	<td colspan='4'><hr width='750' noshade><br></td>
	 </tr>
	 ");

	 //display total row
	 echo("
	 <tr> 
				<td width='368'><p>&nbsp;</p></td>
				<td width='138'><p>&nbsp;</p></td>
				<td width='194'><b><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>".$_SESSION['items']."</font></b></td>
				<td width='50'><b><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>\$".number_format($_SESSION['total_price'],2)."</font></b></td>
		  	</tr>
</form></table>"); 
}

I hope this helps.

And yes, when I call the function within the body of the email like this:

$useremail="$email, webmaster@mysite.com";  

        $subject="Order Details"; 
        $header = "From: order@xyzcompany.com\r\n"; 
        $header .= "X=Mailer: PHP/"; 
        $body="Here are the details of your order: 

    Contact Information: 

    $firstName $lastName 
    $address  $apt 
    $city, $state $zip 
    $country 
    $phone 

    Billing and Shipping Information: 

    $bfirstName $blastName 
    $baddress  $bapt 
    $bcity, $bstate $bzip 
    $bcountry 

    ".display_checkout_cart($cart)."

    Number of Items Ordered:  ".$_SESSION['items']." 

    Order Total: \$".number_format($_SESSION['total_price'],2)." 

    ";  
    mail ($useremail, $subject, $body, $header);

It just echoes it in the browser but doesn't add it to the email.

Thanks

AstroTeg

Ok - yeah, you'll need to rip all the echoes out and put in strings. I'd recommend just using one string and concatenating it as needed. Then return the string. Then when you want to display it to the browser, just use 'echo display_checkout_cart(...);' and when you want to include it in an email, just add it to the message body or where ever you want it.

Perfect example of code reuse...

skdzines

When you say just put in strings instead of echo, how? Could you give me an example? I have never used it before.

Thanks

flatpooks

i think he means instead of:

echo "blah blah";

use:

$output = "";
$output .= "blah blah";
$output .= "blee blee";
...

@mail($to,$subject,$output,$headers);

if im reading right
🙂

skdzines

okay, can you answer me this? I can get it to print the strings out and concatenate them. There is formatting such as line breaks and alignment of where I want them placed but only when I have the html tags as part of the string. Like so:

<td width='368'>Product Name
 </td>
<td width='138'>Price
 </td>
<td width='144'>Qty
 </td>
<td width='50'>Total
 </td>
</tr>

That is exactly what prints out in the body of the email. What I want is something like this:

Product Name: Price: Qty: Total:

This is where each products information will be place using the foreach loop to return my output string.

_________________________________________________________
Order Total: 3 $24.50

However when I try to place it like that in the body of my email and then place the output strings in the appropriate place, it ignores the white spaces and puts everything together like this in the email:

Product Name: Price: Qty: Total:
BOYS AND GIRLS CHRISTMAS NATIVITY SET $14.50 3 $43.50
_______________________________________________________________________
Order Total: 4 $48.00

I hope this makes sense to someone.

Thanks again for your help.

Edit: Okay, well even this thing is putting everything together. Just imagine that there isdecent amount of space between the words Product Name:, Price:, Qty:, Total etc...