mailing multiple records

[reinder]

I've got a question.....I've made sort of a shop....now i want to mail the cart to a destination mail adress....Thats works, but it only mails the last product and not all. The products are in a table called winkelwagen and are shown on the order page with a repeat function.

Now I want the value levnr from the winkelwagen table mailed...its in the form like this:

<input type="hidden" name="produkt" value="<?php echo $row_winkelwagen['levnr']; ?>">

where the name will be mailed like $produkt

So I figured out that I need a foreach function or something like that to insert all the values and not 1. But i dont know where to put it or how to write it....anyone????

[paulnaj]

Show us the code you have used to build the email (the one that only mails the last product).

[reinder]

Here is the whole code in 2 parts 🙂)

<?php session_start();?>
<?php require_once('../Connections/basicoffice.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}



$ip=session_id();
mysql_select_db($database_basicoffice, $basicoffice);
$query_winkelwagen = "SELECT * FROM winkelwagen WHERE `user` = '$ip'";
$winkelwagen = mysql_query($query_winkelwagen, $basicoffice) or die(mysql_error());
$row_winkelwagen = mysql_fetch_assoc($winkelwagen);
$totalRows_winkelwagen = mysql_num_rows($winkelwagen);


mysql_select_db($database_basicoffice, $basicoffice);


$email_webmaster = "[e-mail]";  

if(getenv(HTTP_X_FORWARDED_FOR)) { $IPadres = getenv(HTTP_X_FORWARDED_FOR); } 
elseif(getenv(HTTP_CLIENT_IP)) { $IPadres = getenv(HTTP_CLIENT_IP); } 
else { $IPadres = $REMOTE_ADDR; } 
$hostmask = gethostbyaddr($REMOTE_ADDR); 

if ($submit) {  

if($contactpersoon == "") {  

    $ok = "nee";  

    $error_contactpersoon = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>";  

}  

if($bedrijfsnaam == "") {  

    $ok = "nee";  

    $error_bedrijfsnaam = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>";  

}  

if($adres == "") {  

    $ok = "nee";  

    $error_adres = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>";  

}  

if($postcode == "") {  

    $ok = "nee";  

    $error_postcode = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>";  

}  

if($plaats == "") {  

    $ok = "nee";  

    $error_plaats = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>";  

}  

if($telefoonnummer == "") {  

    $ok = "nee";  

    $error_telefoonnummer = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>";  

}  


if(!eregi("[A-Za-z0-9_-]+([.]{1}[A-Za-z0-9_-]+)*@[A-Za-z0-9-]+([.]{1}[A-Za-z0-9-]+)+", $email)) {  

$ok = "nee"; 
$error_email = "<font face=\"Microsoft Sans-Serif,Arial\" size=\"2\" color=\"FF0000\"><b>*</b></font>"; 
} 



if($ok != "nee") {  



$datum = date("d-m-Y");  

$tijd = date("H:i");  


@$winkelwagen=mail("$email_webmaster", "Contact: $bedrijfsnaam", " 
====================================================================== 
Leveringsnummer: $produkt -----  Aantal:   $aantal
====================================================================== 
Contactpersoon:      $contactpersoon
====================================================================== 
Bedrijfsnaam:      $bedrijfsnaam
====================================================================== 
Adres:      $adres 
====================================================================== 
Postcode:      $postcode
====================================================================== 
Plaats:      $plaats 
====================================================================== 
Telefoonnummer:      $telefoonnummer 
====================================================================== 
Mobiel nummer:      $mobiel 
====================================================================== 
Faxnummer:      $faxnummer 
====================================================================== 
Email:     $email 
====================================================================== 

Note:      $contactpersoon stuurde deze email op $datum om $tijd. 

======================================================================", "From: $contactpersoon<$email>");  

if($winkelwagen == "1"){ 



?>
<link href="style.css" rel="stylesheet" type="text/css">



<br>
<center><table width="450"><td height="1"  bgcolor="#666666">
</td></table>
<table width="450">

<td><a href="voorwaarden.php" class="link">Voorwaarden</a></td>
    <td><a href="producten.php" class="link">Overzicht</a></td>
    <td><a href="winkelwagen.php" class="link">Winkelwagen</a></td>
    <td><a href="bestel.php" class="link">Bestellen</a></td>
	<td><a href="search.php" class="link">Zoeken</a></td></table>
	<table width="450"><td height="1"  bgcolor="#666666">
</td></table></center>
<br>
<br>
<?php  

$ip=session_id();

$query_delete = "DELETE FROM winkelwagen WHERE `user` = '$ip'";
$winkelwagen = mysql_query($query_delete, $basicoffice) or die(mysql_error());
?>

[reinder]

<table width="50%" align="center" cellpadding="5" cellspacing="0"> 
<tr><td align="center"><br>
<font face="verdana" size="2" color="000000"> 
Uw bestelling is verzonden. Wij zullen deze in behandeling nemen en  zo spoedig mogelijk contact met u opnemen.<br>
</font></td></tr> 
</td></tr> 
</table> 
<? 
}else{ 
?> 
<table width="50%" align="center" cellpadding="5" cellspacing="0" style="border: solid #000000; border-width: 0;"> 
<tr><td align="center"><br><font face="verdana" size="2" color="#000000"> 
Uw bericht is NIET verzonden.<br>Er is een fout opgetreden bij het verzenden.<br> 
Wij zullen proberen het probleem zo snel mogelijk te verhelpen.<br> 
Mocht dit probleem na enkele dagen niet verholpen zijn,<br>neem dan contact op met de<a href="mailto:[e-mail]" class="link"> 
Webmaster</a> 
<br>Bedankt voor uw medewerking.</font></td></tr> 
</td></tr> 
</table> 
<? 
    } 

}  

else {  

?> 
<style type="text/css"> 

body {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #333333;
	text-decoration: none;
	background-color: #D1D1D1;
	scrollbar-face-color:#C0C0C0;
	scrollbar-highlight-color:#FFFFFF;
	scrollbar-3dlight-color:#808080;
	scrollbar-darkshadow-color:#000000;
	scrollbar-shadow-color:#808080;
	scrollbar-arrow-color:#FFFFFF;
	scrollbar-track-color:#E0E0E0;
}

.detail {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
	color: #333333;
	text-decoration: none;
	background-color: #B9B9B9;
}
.link {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #666666;
	text-decoration: none;


} 
.contactformulier {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	font-weight: bold;
	color: #FFFFFF;
	text-decoration: none;
}
.sterretje {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 9px;
	color: #FF0000;
	text-decoration: none;
}
.kopachtergrond {
	background-color: #666666;
}
A:visited{ text-decoration: none; color=#666666 } 
A:hover{ text-decoration: none; color=#FFFFFF }

.button { font-family: verdana; font-size: 10px; font-style: normal; line-height: normal; color: #FFFFFF; text-decoration: none; background-color: #666666; border: 1px solid #000000; cursor: hand } 

</style> 

<center><table width="450"><td height="1"  bgcolor="#666666">
</td></table>
<table width="450">

<td><a href="voorwaarden.php" class="link">Voorwaarden</a></td>
    <td><a href="producten.php" class="link">Overzicht</a></td>
    <td><a href="winkelwagen.php" class="link">Winkelwagen</a></td>
    <td><a href="bestel.php" class="link">Bestellen</a></td>
	<td><a href="search.php" class="link">Zoeken</a></td></table>
	<table width="450"><td height="1"  bgcolor="#666666">
</td></table></center>
<br><Br>
<form method="post" action="<? echo"$PHP_SELF"; ?>"> 

  <div align="center">
  <table width="80%">
      <?php do { ?>
      <tr>
        <td width="56%" align="left" bgcolor="#666666" class="kopachtergrond"><font color="#000000" size="1" face="verdana" class="contactformulier"><b><?php echo $row_winkelwagen['produkt']; ?></b></font><br></td>


    <td width="44%" bgcolor="#666666" class="kopachtergrond">
            <input type="hidden" name="produkt[]" value="<?php echo $row_winkelwagen['levnr']; ?>">
      <input type="hidden" name="aantal[]" value="<?php echo $row_winkelwagen['aantal']; ?>"> 
      <span class="contactformulier">Aantal: <?php echo $row_winkelwagen['aantal']; ?></span></td>
  </tr>
  <?php } while ($row_winkelwagen = mysql_fetch_assoc($winkelwagen)); ?>
  </table>
  <table width="30%" cellspacing="0" cellpadding="5"> 
    <tr> 
    <td align="center"> 
    <table cellspacing="0" cellpadding="1"> 

<tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Contactpersoon:</b></font></td> 
    <td><? echo"$error_contactpersoon"; ?></td> 
    <td><input type="text" name="contactpersoon" size="36" maxlength="36" value="<? echo"$contactpersoon"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Bedrijfnaam:</b></font></td> 
    <td><? echo"$error_bedrijfsnaam"; ?></td> 
    <td><input type="text" name="bedrijfsnaam" size="36" maxlength="36" value="<? echo"$bedrijfsnaam"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Adres:</b></font></td> 
    <td><? echo"$error_adres"; ?></td> 
    <td><input type="text" name="adres" size="36" maxlength="36" value="<? echo"$adres"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Postcode:</b></font></td> 
    <td><? echo"$error_postcode"; ?></td> 
    <td><input type="text" name="postcode" size="36" maxlength="36" value="<? echo"$postcode"; ?>"></td> 
    </tr> 

<tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Plaats:</b></font></td> 
    <td><? echo"$error_plaats"; ?></td> 
    <td><input type="text" name="plaats" size="36" maxlength="36" value="<? echo"$plaats"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Telefoonnummer:</b></font></td> 
    <td><? echo"$error_telefoonnummer"; ?></td> 
    <td><input type="text" name="telefoonnummer" size="36" maxlength="36" value="<? echo"$telefoonnummer"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Mobiel:</b></font></td> 
    <td></td> 
    <td><input type="text" name="mobiel" size="36" maxlength="36" value="<? echo"$mobiel"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Faxnummer:</b></font></td> 
    <td></td> 
    <td><input type="text" name="faxnummer" size="36" maxlength="36" value="<? echo"$faxnummer"; ?>"></td> 
    </tr> 

<tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Email:</b></font></td> 
    <td><? echo"$error_email"; ?></td> 
    <td><input type="text" name="email" size="36" maxlength="36" value="<? echo"$email"; ?>"></td> 
    </tr> 



<tr> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
    <td><input class="button" type="submit" name="submit" value="Versturen"></td> 
    </tr> 
    </tr> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
    <td align="center"><br><font face="verdana" size="2" color="#000000">De volgende velden met een <font color="#FF0000"><b>*</b></font> zijn niet juist ingevuld.<br>Controleer het nogmaals.</font></font></td> 
    </tr> 
    </table><br> 
    </td></tr>  

  </table>
  </div>
</form> 
<? 
}  

}  

else {  

?> 
<style type="text/css"> 


body {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #333333;
	text-decoration: none;
	background-color: #D1D1D1;
	scrollbar-face-color:#C0C0C0;
	scrollbar-highlight-color:#FFFFFF;
	scrollbar-3dlight-color:#808080;
	scrollbar-darkshadow-color:#000000;
	scrollbar-shadow-color:#808080;
	scrollbar-arrow-color:#FFFFFF;
	scrollbar-track-color:#E0E0E0;
}

.detail {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
	color: #333333;
	text-decoration: none;
	background-color: #B9B9B9;
}
.link {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #666666;
	text-decoration: none;


} 
.contactformulier {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	font-weight: bold;
	color: #FFFFFF;
	text-decoration: none;
}
.sterretje {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 9px;
	color: #FF0000;
	text-decoration: none;
}
.kopachtergrond {
	background-color: #666666;
}
A:visited{ text-decoration: none; color=#666666 } 
A:hover{ text-decoration: none; color=#FFFFFF }

.button { font-family: verdana; font-size: 10px; font-style: normal; line-height: normal; color: #FFFFFF; text-decoration: none; background-color: #666666; border: 1px solid #000000; cursor: hand } 

</style> 

<center><table width="450"><td height="1"  bgcolor="#666666">
</td></table>
<table width="450">

<td><a href="voorwaarden.php" class="link">Voorwaarden</a></td>
    <td><a href="producten.php" class="link">Overzicht</a></td>
    <td><a href="winkelwagen.php" class="link">Winkelwagen</a></td>
    <td><a href="bestel.php" class="link">Bestellen</a></td>
	<td><a href="search.php" class="link">Zoeken</a></td></table>
	<table width="450"><td height="1"  bgcolor="#666666">
</td></table></center>
<br><Br>
<form method="post" action="<? echo"$PHP_SELF"; ?>"> 
  <div align="center">
  <table width="80%">
      <?php do { ?>
      <tr >
        <td width="56%" align="left" bgcolor="#666666" class="kopachtergrond"><font color="#000000" size="1" face="verdana" class="contactformulier"><b><?php echo $row_winkelwagen['produkt']; ?></b></font><br></td>

[reinder]

        <td width="44%" bgcolor="#666666" class="kopachtergrond">

    <input type="hidden" name="produkt[]" value="<?php echo $row_winkelwagen['levnr']; ?>">
      <input type="hidden" name="aantal[]" value="<?php echo $row_winkelwagen['aantal']; ?>">
<font color="#000000" size="1" face="verdana" class="link"><b> </b></font>
    <span class="contactformulier">Aantal:</span> <span class="contactformulier"><?php echo $row_winkelwagen['aantal']; ?></span></td>
  </tr>
  <?php } while ($row_winkelwagen = mysql_fetch_assoc($winkelwagen)); ?>
  </table>
  <table width="33%" cellpadding="5" cellspacing="0"> 
    <tr> 
    <td align="center"> 
    <table align="left" cellpadding="1" cellspacing="0"> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Contactpersoon:</b></font></td> 
    <td><? echo"$error_contactpersoon"; ?></td> 
    <td><input type="text" name="contactpersoon" size="36" maxlength="36" value="<? echo"$contactpersoon"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Bedrijfnaam:</b></font></td> 
    <td><? echo"$error_bedrijfsnaam"; ?></td> 
    <td><input type="text" name="bedrijfsnaam" size="36" maxlength="36" value="<? echo"$bedrijfsnaam"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Adres:</b></font></td> 
    <td><? echo"$error_adres"; ?></td> 
    <td><input type="text" name="adres" size="36" maxlength="36" value="<? echo"$adres"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Postcode:</b></font></td> 
    <td><? echo"$error_postcode"; ?></td> 
    <td><input type="text" name="postcode" size="36" maxlength="36" value="<? echo"$postcode"; ?>"></td> 
    </tr> 

<tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Plaats:</b></font></td> 
    <td><? echo"$error_plaats"; ?></td> 
    <td><input type="text" name="plaats" size="36" maxlength="36" value="<? echo"$plaats"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Telefoonnummer:</b></font></td> 
    <td><? echo"$error_telefoonnummer"; ?></td> 
    <td><input type="text" name="telefoonnummer" size="36" maxlength="36" value="<? echo"$telefoonnummer"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Mobiel:</b></font></td> 
    <td></td> 
    <td><input type="text" name="mobiel" size="36" maxlength="36" value="<? echo"$mobiel"; ?>"></td> 
    </tr> 
    <tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Faxnummer:</b></font></td> 
    <td></td> 
    <td><input type="text" name="faxnummer" size="36" maxlength="36" value="<? echo"$faxnummer"; ?>"></td> 
    </tr> 

<tr> 
    <td align="right"><font face="verdana" size="1" color="#000000"><b>Email:</b></font></td> 
    <td><? echo"$error_email"; ?></td> 
    <td><input type="text" name="email" size="36" maxlength="36" value="<? echo"$email"; ?>"></td> 
    </tr> 

<tr> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
    <td><input class="button" type="submit" name="submit" value="Versturen"></td> 
    </tr> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
    <td align="center"><br></td> 
    </tr> 
    </table><br> 
    </td></tr> 
  </table>
  </div>
</form> 
<div align="right"><a href="#" class="link" onClick="history.go(-1);">Terug</a>
</div>
<? 
}  

?> 

[paulnaj]

This is where you are building your email abd where alterations will need to be made.

You have the variable '$produkt', but where are the other product items stored?

@$winkelwagen=mail("$email_webmaster", "Contact: $bedrijfsnaam", "  

==================================================
==================== 
Leveringsnummer: $produkt -----  Aantal:   $aantal 
==================================================
==================== 
Contactpersoon:      $contactpersoon 
==================================================
==================== 
Bedrijfsnaam:      $bedrijfsnaam 
==================================================
==================== 
Adres:      $adres  

==================================================
==================== 
Postcode:      $postcode 
==================================================
==================== 
Plaats:      $plaats  

==================================================
==================== 
Telefoonnummer:      $telefoonnummer  

==================================================
==================== 
Mobiel nummer:      $mobiel  

==================================================
==================== 
Faxnummer:      $faxnummer  

==================================================
==================== 
Email:     $email  

==================================================
==================== 

Note:      $contactpersoon stuurde deze email op $datum om $tijd. 

==================================================
====================", "From: $contactpersoon<$email>");   

[reinder]

Well the idea is that all there items are stored in the table winkelwagen. This only contains an levnr (wich identifies wich article it is), produkt (discription of article), user (session_id) and aantal (number of items).

After mailing, it deletes all items of that user.

So it only has to mail the $produkt. But it has to mail them all and not 1....

[reinder]

ANYONE??? Plz? Its the last thing and my page is ready 🙁