Sending a dynamic table to email

[Dorkmind]

Hi guys, i have a shopping cart made in php, now it works very well but i have a problem with sending its content to my email. So basicly when a customer chooses all the stuff he wants to buy i need it to send me the cart content to my email.

 

Here si the while loop :

while($row=mysql_fetch_array($query))
								{
									$subtotal=$_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];
									$totalprice+=$subtotal;
									?>
									
                                    	<tr>
                                        	<td><?php echo $row['name'] ?></td>
                                            <td><input type="text" name="quantity[<?php echo $row['product_id']?>]" size="5" value="<?php echo $_SESSION['cart'][$row['product_id']]['quantity'] ?>"/></td>
											<td><?php echo $row['price']?>€</td>
                                            <td><?php echo $_SESSION['cart'][$row['product_id']]['quantity']*$row['price']?>€</td>
                                            
                                            </tr>
                                            <?php
								}

So how could i copy the content of the cart that is created in this while loop and send it to email. I used

<form action="checkout.php" method="post">

<textarea name="message">Full price: <?php echo $totalprice; ?></textarea>

</form>

Which send me a total price but i can't figure out how to send all the bought products with it.

[Barand]

While you are constructing the table for your page, store the HTML in a variable that can be added to your email message.

[Dorkmind]

how do you mean that

[Barand]

Something like this

$tabledata = '';
while($row=mysql_fetch_array($query))
{
    $subtotal=$_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];
    $totalprice+=$subtotal;
    $tabledata .= <<<ROW
        <tr>
            <td>{$row['name']}</td>
            <td><input type="text" name="quantity[{$row['product_id']}]" size="5" value="{$_SESSION['cart'][$row['product_id']]['quantity']}"/></td>
            <td>{$row['price']}€</td>
            <td>$subtotal</td>
        </tr>
ROW;
}

[Dorkmind]

so can you please tell me where to put that while loop you wrote inside my while loop or under it.

<h1 align="center"> Cart </h1>
<form method="post" action="cart.php">

<table align="center">

	<tr>
    	<th>Name</th>
        <th>Quantity</th>
        <th>Price 1</th>
        <th>Price all </th>
     </tr>
     
     <?php
	 
	 	$sql="SELECT * FROM Products WHERE product_id IN (";
						
							foreach($_SESSION['cart'] as $id => $value)
							{
								$sql.=$id.",";
							}
							
								$sql=substr($sql, 0, -1).") ORDER BY name ASC";
								$query=mysql_query($sql);
								$totalprice=0;
								if(!empty($query)){
								while($row=mysql_fetch_array($query))
								{
									$subtotal=$_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];
									$totalprice+=$subtotal;
									?>
									
                                    	<tr>
                                        	<td><?php echo $row['name'] ?></td>
                                            <td><input type="text" name="quantity[<?php echo $row['product_id']?>]" size="5" value="<?php echo $_SESSION['cart'][$row['product_id']]['quantity'] ?>"/></td>
											<td><?php echo $row['price']?>€</td>
                                            <td><?php echo $_SESSION['cart'][$row['product_id']]['quantity']*$row['price']?>€</td>
                                            
                                            </tr>
                                            <?php
								}
								}
								else{
									echo "<p> Your cart is empty </p>";
								}
								?>
                              
       
								<tr>
                                	<td> 
                                     For pay: 
									 <?php echo $totalprice ?> €
                                     
                                    </td>
                                </table>
                                
     
           
          
               <h2 align="center"><br/><button type="submit" name="submit"> Refresh cart</button></h2>
               
                                
                                
                
                
                 </form>
                 </tr>
                 </table>
                 
                 <h3 align="center"><p> To remove from cart, set to 0.</p></h3>
                 

[Dorkmind]

So i fixed it

$Productname=array();
$Quantity=array();
$Allprice=array();

while($row=mysql_fetch_array($query))
								{	
									$subtotal=$_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];
									$totalprice+=$subtotal;
									?>
									
                                    	<tr>
                                        	<td><?php echo $row['name'] ?></td>; 
                                            <td><input type="text" name="quantity[<?php echo $row['product_id']?>]" size="5" value="<?php echo $_SESSION['cart'][$row['product_id']]['quantity'] ?>"/></td>
											<td><?php echo $row['price']?>€</td>
                                            <td><?php echo $_SESSION['cart'][$row['product_id']]['quantity']*$row['price']?>€</td>
                                            
                                            </tr>
                                            
                                            <?php $Allprice[$i]=$_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];?>
                                            <?php $Productname[$i]=$row['name'];?>
                                            <?php $Quantity[$i]=$_SESSION['cart'][$row['product_id']]['quantity']?>
                                            <?php
                                         
    											$i++;			
                                            
								}

but now i have another problem i would like to send them to my email.

 

so i made a form

<form method="post" action="checkout.php">
                  	 
                             <?php echo print_r($Productname,true) ?>
                                <?php echo print_r($Quantity,true) ?>
                                <?php echo print_r($Allprice,true) ?>
                                <input type="submit" value="Buy">
                                </form>

and checkout looks like that

<?php
mail('my_mail@mail.com',$_POST['$Productname'], $_POST['$Quantity'], $_POST['$Allprice']);
?>
<p>Your products where bought.</p>

but it does not work,

 

i tried it with :

<textarea name="message"><?php echo print_r($Productname,true) ?></textarea>

and then i was calling message in my chechout.php,

but the problem is it displays the input window with my array inside it, on my cart.php,

but i don't want that i want,

when user presses buy, it would send me the arrays  without displaying them again on my website. Thank you in advance

Edited November 19, 2014 by Dorkmind

[Dorkmind]

Anyone?

[mac_gyver]

go back and re-read what Barand first suggested -

 

While you are constructing the table for your page, store the HTML in a variable that can be added to your email message.

 

what this means is to construct the HTML in a php variable (i.e. replace the echo statements with code that adds the html to a php variable.) when you are done constructing the HTML in the php variable, you can do whatever you want with that php variable. you can echo it on your page to display the html to the visitor or you can use it in the email message body to send the html in the email.