Hjælp til ordrebekræftelse i en shop!
Jeg er ved at færdiggøre en shop med php, men den kode jeg bruger sender ordreoplysningerne pr. mail til kunderne, uden at man kan se oplysningerne på browseren. Jeg kunne godt tænke mig at jeg f.eks. sendte e-mail med fakturaen i pdf automatisk, og kunden også selv kunne printe ud med link til pdf-filen ved ordrebekræftelsen på browseren. Derudover har jeg en ide om at lave et kundelogin, som gemte deres ordre osv. Er der en, som har lyst til at hjælpe mig?Min kode er:
Chechout 2 af 3:
<?php
session_start();
//connect to the database
$connect = mysql_connect("xxxxx", "xxxxx", "xxxxx")
or die ("Hey loser, check your server connection.");
mysql_select_db("designunltddk_shop");
if ($_POST['same'] == 'on') {
$_POST['shipfornavn'] = $_POST['fornavn'];
$_POST['shipefternavn'] = $_POST['efternavn'];
$_POST['shipadresse1'] = $_POST['adresse1'];
$_POST['shipadresse2'] = $_POST['adresse2'];
$_POST['shippostnr'] = $_POST['postnr'];
$_POST['shipby'] = $_POST['by'];
$_POST['shiptelefon'] = $_POST['telefon'];
$_POST['shipmobil'] = $_POST['mobil'];
$_POST['shipemail'] = $_POST['email'];
}
?>
<table width="385" height="472" border="0" valign="top" align="left" cellspacing="0" cellpadding="0">
<tr valign="bottom" align="left">
<td width="385" height="23" colspan="3"><font class="indholdoverskrift"></font><font class="undermenubottom">Godkendelse - trin 2 af 3</font></td>
</tr>
<tr valign="middle" align="center">
<td width="385" align="center" valign="top"><font class="undermenu1_5"></font>
<form method="post" action="checkout3.php"><table width="385" border="0">
<tr>
<td width="385" align="right"><table width="195" border="0" align="left">
<tr valign="top">
<td height="23" colspan="2" align="left" class="undermenu1_5"><b>Fakturerings adresse</b></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Fornavn:</td>
<td width="85%" height="23"><input type="text" name="fornavn" maxlength="15" size="15" value="<?php echo $_POST['fornavn']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Efternavn: </td>
<td width="85%" height="23">
<input type="text" name="efternavn" maxlength="50" size="15" value="<?php echo $_POST['efternavn']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Adresse:</td>
<td width="85%" height="23">
<input type="text" name="adresse1" maxlength="50" size="15" value="<?php echo $_POST['adresse1']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Adresse:</td>
<td width="85%" height="23"><input type="text" name="adresse2" maxlength="50" size="15" value="<?php echo $_POST['adresse2']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Postnr.:</td>
<td width="85%" height="23">
<input type="text" name="postnr" maxlength="4" size="4" value="<?php echo $_POST['postnr']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
By:</td>
<td width="85%" height="23"><input type="text" name="by" maxlength="50" size="15" value="<?php echo $_POST['by']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Telefon:</td>
<td width="85%" height="23">
<input type="text" name="telefon" size="8" maxlength="8" value="<?php echo $_POST['telefon']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Mobil:</td>
<td width="85%" height="23">
<input type="text" name="mobil" maxlength="8" size="8" value="<?php echo $_POST['mobil']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
E-Mail:</td>
<td width="85%" height="23"><input type="text" name="email" maxlength="50" size="15" value="<?php echo $_POST['email']; ?>"></td>
</tr>
</table>
<table width="190" border="0" align="right">
<tr valign="top">
<td height="23" colspan="2" align="left" class="undermenu1_5">
<b>Forsendelses adresse</b></td>
</tr>
<tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Fornavn:</td>
<td height="23" colspan="2"><input type="text" name="shipfornavn" maxlength="15" size="15" value="<?php echo $_POST['shipfornavn']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Efternavn:</td>
<td height="23" colspan="2"><input type="text" name="shipefternavn" maxlength="50" size="15" value="<?php echo $_POST['shipefternavn']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Adresse:</td>
<td height="23" colspan="2">
<input type="text" name="shipadresse1" maxlength="50" size="15" value="<?php echo $_POST['shipadresse1']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Adresse:</td>
<td height="23" colspan="2"><input type="text" name="shipadresse2" maxlength="50" size="15" value="<?php echo $_POST['shipadresse2']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Postnr.:</td>
<td height="23" colspan="2"><input type="text" name="shippostnr" maxlength="4" size="4" value="<?php echo $_POST['shippostnr']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
By:</td>
<td height="23" colspan="2">
<input type="text" name="shipby" maxlength="50" size="15" value="<?php echo $_POST['shipby']; ?>"> </td>
</tr>
<tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Telefon:</td>
<td height="23" colspan="2"><input type="text" name="shiptelefon" maxlength="8" size="8" value="<?php echo $_POST['shiptelefon']; ?>"></td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
Mobil:</td>
<td width="85%" height="23">
<input type="text" name="shipmobil" maxlength="8" size="8" value="<?php echo $_POST['shipmobil']; ?>"> </td>
</tr>
<tr>
<td width="15%" height="23" align="left" valign="top" class="undermenu1_5">
E-mail:</td>
<td height="23" colspan="2"><input type="text" name="shipemail" maxlength="50" size="15" value="<?php echo $_POST['shipemail']; ?>"></td>
</tr>
</table>
</td>
</tr>
<td><table width="385" border="0" align="center" cellpadding="5">
<tr>
<td width="65"><font class="undermenu1_5"><b>antal</b></font></td>
<td width="35"><font class="undermenu1_5"><b>vare</b></font></td>
<td width="70"><font class="undermenu1_5"><b>navn</b></font></td>
<td width="70"><font class="undermenu1_5"><b>stk. pris</b></font></td>
<td width="70"><font class="undermenu1_5"><b>pris i alt</b></font></td>
<?php
$sessid = session_id();
$query = "SELECT * FROM carttemp WHERE carttemp_sess = '$sessid'";
$results = mysql_query($query)
or die (mysql_query());
$total = 0;
while ($row = mysql_fetch_array($results)) {
echo "<tr>";
extract($row);
$prod = "SELECT * FROM products " .
"WHERE products_prodnum='$carttemp_prodnum'";
$prod2 = mysql_query($prod);
$prod3 = mysql_fetch_array($prod2);
extract($prod3);
echo "<td width=\"65\"><font class=\"undermenu1_5\">
<form method=\"POST\" action=\"modcart.php?action=change\">
<input type=\"hidden\" name=\"modified_hidden\"
value=\"$carttemp_hidden\">
<input type=\"text\" name=\"modified_quan\" size=\"1\"
value=\"$carttemp_quan\">";
echo "</font></td>";
echo "<td width=\"35\" valign=\"middle\"><font class=\"undermenu1_5\">";
echo "<a href=\"varerbeskrivelse.php?prodid=" . $products_prodnum . "\">";
echo "<img src=" . $products_thumbnailimageurl . " width=\"25\" height=\"25\" border=\"0\"></a></font></td>";
echo "<td width=\"70\" valign=\"middle\">";
echo "<a href=\"varerbeskrivelse.php?prodid=" . $products_prodnum . "\" class=\"undermenu1_5\">";
echo $products_navn;
echo "</font></a></td>";
echo "<td width=\"70\" valign=\"middle\" align=\"right\"><font class=\"undermenu1_5\">";
$products_pris = $products_pris;
echo number_format($products_pris, 2 , ',' , '.');
echo "</font></td>";
echo "<td width=\"70\" valign=\"middle\" align=\"left\"><font class=\"undermenu1_5\">";
//get extended price
$extprice = $products_pris * $carttemp_quan;
echo number_format($products_pris * $carttemp_quan, 2 , ',' , '.');
echo "</td>";
echo "<td>";
echo "<a href=\"cart.php\" class=\"undermenu1_5right\">ændre indkøbspose</a>";
echo "</font></td>";
echo "</tr>";
//add extended price to total
$total = $extprice + $total;
}
echo "<tr>";
echo "<td width=\"240\" colspan=\"4\" align=\"right\" class=\"undermenu1_5\"><b>Pris i alt (incl. moms):</b></td>";
?>
<?php echo "<td width=\"70\" colspan=\"2\" align=\"right\" class=\"undermenu1_5\"><b>"; ?><?php echo number_format($total, 2 , ',' , '.'); ?><?php echo " Dkk"; ?>
<?php
echo "</b></td>";
echo "<td width=\"75\" colspan=\"2\">";
echo "</td>";
echo "</tr>";
?>
</table></td></tr>
</table>
<input type="hidden" name="total" value="<?php echo $total; ?>">
<p>
<input type="submit" name="Submit" value="Godkend ordre">
</form>
chechout 3 af 3:
<?php
session_start();
//connect to the database - either include a connection variable file
//or type the following lines:
$connect = mysql_connect("xxxxx", "xxxxx", "xxxxx")
or die ("Hey loser, check your server connection.");
mysql_select_db("designunltddk_shop");
//Let's make the variables easy to access in our queries
$fornavn = $_POST['fornavn'];
$efternavn = $_POST['efternavn'];
$adresse1 = $_POST['adresse1'];
$adresse2 = $_POST['adresse2'];
$by = $_POST['by'];
$postnr = $_POST['postnr'];
$telefon = $_POST['telefon'];
$mobil = $_POST['mobil'];
$email = $_POST['email'];
$shipfornavn = $_POST['shipfornavn'];
$shipefternavn = $_POST['shipefternavn'];
$shipadresse1 = $_POST['shipadresse1'];
$shipadresse2 = $_POST['shipadresse2'];
$shipby = $_POST['shipby'];
$shippostnr = $_POST['shippostnr'];
$shiptelefon = $_POST['shiptelefon'];
$shipmobil = $_POST['shipmobil'];
$shipemail = $_POST['shipemail'];
$total = $_POST['total'];
$sessid = session_id();
$today = date("Y-m-d");
//1) Assign Customer Number to new Customer, or find existing customer number
$query = "SELECT * FROM kunder WHERE
(kunde_fornavn = '$fornavn' AND
kunde_efternavn = '$efternavn' AND
kunde_adresse1 = '$adresse1' AND
kunde_adresse2 = '$adresse2' AND
kunde_by = '$by')";
$results = mysql_query($query)
or (mysql_error());
$rows = mysql_num_rows($results);
if ($rows < 1) {
//assign new custnum
$query2 = "INSERT INTO kunde (
kunde_fornavn, kunde_efternavn, kunde_adresse1,
kunde_adresse2, kunde_by,
kunde_postnr, kunde_telefon, kunde_mobil,
kunde_email)
VALUES (
'$fornavn',
'$efternavn',
'$adresse1',
'$adresse2',
'$by',
'$postnr',
'$telefon',
'$mobil',
'$email')";
$insert = mysql_query($query2)
or (mysql_error());
$custid = mysql_insert_id();
}
//If custid exists, we want to make it equal to custnum
//Otherwise we will use the existing custnum
if ($custid) {
$kunde_custnum = $custid;
}
//2) Insert Info into ordermain
//determine shipping costs based on order total (25% of total)
$fragt = $total + 35;
$query3 = "INSERT INTO ordermain (
ordermain_orderdato, ordermain_custnum,
ordermain_subtotal,ordermain_fragt,
ordermain_fragtstart, ordermain_fragtslut,
ordermain_fragtadresse1, ordermain_fragtadresse2,
ordermain_fragtby,
ordermain_fragtpostnr, ordermain_fragttelefon,
ordermain_shipemail)
VALUES (
'$today',
'$kunde_custnum',
'$total',
'$fragt'
'$shipfornavn',
'$shipefternavn',
'$shipadresse1',
'$shipadresse2',
'$shipby',
'$shippostnr',
'$shiptelefon',
'$shipemail')";
$insert2 = mysql_query($query3)
or (mysql_error());
$orderid = mysql_insert_id();
//3) Insert Info into orderdet
//find the correct cart information being temporarily stored
$query = "SELECT * FROM carttemp WHERE carttemp_sess='$sessid'";
$results = mysql_query($query)
or (mysql_error());
//put the data into the database one row at a time
while ($row = mysql_fetch_array($results)) {
extract($row);
$query4 = "INSERT INTO orderdet (
orderdet_ordernum, orderdet_qty, orderdet_prodnum)
VALUES (
'$orderid',
'$carttemp_quan',
'$carttemp_prodnum')";
$insert4 = mysql_query($query4)
or (mysql_error());
}
//4)delete from temporary table
$query = "DELETE FROM carttemp WHERE carttemp_sess='$sessid'";
$delete = mysql_query($query);
//5)email confirmations to us and to the customer
/* recipients */
$to = "<" . $email .">";
/* subject */
$subject = "Ordrebekræftelse";
/* message */
/* top of message */
$message = "
<html>
<head>
<title>Ordrebekræftelse</title>
</head>
<body>
Vi har modtaget din ordre:<br><br>
Ordre dato: ";
$message .= $today;
$message .= "
<br>
Ordre nummer: ";
$message .= $orderid;
$message .= "
<table width=\"50%\" border=\"0\">
<tr>
<td>
<p>Faktureres til:<br>";
$message .= $fornavn;
$message .= " ";
$message .= $efternavn;
$message .= "<br>";
$message .= $adresse1;
$message .= "<br>";
if ($adresse2) {
$message .= $adresse2 . "<br>";
}
$message .= $postnr . " " . $postnr$by;
$message .= "</p></td>
<td>
<p>Sendes til:<br>";
$message .= $shipfornavn . " " . $shipefternavn;
$message .= "<br>";
$message .= $shipadresse1 . "<br>";
if ($shipadresse2) {
$message .= $shipadresse2 . "<br>";
}
$message .= $shippostnr . " " . $shipby;
$message .= "</p>
</td>
</tr>
</table>
<hr width=\"250px\" align=\"left\">
<table cellpadding=\"5\">";
//grab the contents of the order and insert them
//into the message field
$query = "SELECT * FROM orderdet WHERE orderdet_ordernum = '$orderid'";
$results = mysql_query($query)
or die (mysql_query());
while ($row = mysql_fetch_array($results)) {
extract($row);
$prod = "SELECT * FROM products
WHERE products_prodnum = '$orderdet_prodnum'";
$prod2 = mysql_query($prod);
$prod3 = mysql_fetch_array($prod2);
extract($prod3);
$message .= "<tr><td>";
$message .= $orderdet_qty;
$message .= "</td>";
$message .="<td>";
$message .= $products_navn;
$message .= "</td>";
$message .= "<td align=\"right\">";
$message .= $products_pris;
$message .= "</td>";
$message .= "<td align=\"right\">";
//get extended price
$extprice = number_format($products_price * $orderdet_qty, 2, ',' , '.');
$message .= $extprice;
$message .= "</td>";
$message .= "</tr>";
}
$message .= "<tr>
<td colspan=\"3\" align=\"right\">
Pris i alt(uden fragt):
</td>
<td align=\"right\">";
$message .= number_format($total, 2, ',' , '.');
$message .= "
</td>
</tr>
<tr>
<td colspan=\"3\" align=\"right\">
Fragten koster:
</td>
<td align=\"right\">";
$message .= number_format($fragt, 2, ',' , '.');
$message .= "
</td>
</tr>
<tr>
<td colspan=\"3\" align=\"right\">
Beløbet i alt:
</td>
<td align=\"right\"> ";
$message .= number_format(($total + $fragt), 2, ',' , '.');
$message .= "
</td>
</tr>
</table>
</body>
</html>";
/* headers */
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: <mail@designunltd.dk>\r\n";
$headers .= "Cc: <mail@designunltd.dk>\r\n";
$headers .= "X-Mailer: PHP / ".phpversion()."\r\n";
/* mail it */
mail($to, $subject, $message, $headers);
//6)show them their order & give them an order number
echo "Oplysninger - trin 1 af 3<br>";
echo "Godkendelse - trin 2 af 3<br>";
echo "<b>Ordrebekræftelse - trin 3 af 3</b><br><br>";
echo $message;
?>
