Indkøbsvogn - individuel
Jeg har skrevet en indkøbsvogn til brug ved netshops. Mit problem er bare at når jeg tilføjer en vare til indkøbsvognen får ALLE tilføjet den. Jeg vil gerne gøre så den bliver individuel. Jeg kan vise alle mine scripts her:Showcart.php:
<?php
session_start();
{
//connect to database
$conn = mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("korczynski",$conn) or die(mysql_error());
$display_block = "<h1>Your Shopping Cart</h1>";
//check for cart items based on user session id
$get_cart = "select st.id, si.item_title, si.item_price, si.item_nr, st.sel_item_qty, st.sel_item_size, st.sel_item_color from store_shoppertrack as st left join store_items as si on si.id = st.sel_item_id where session_id = '$PHPSESSID'";
$get_cart_res = mysql_query($get_cart) or die(mysql_error());
if (mysql_num_rows($get_cart_res) < 1) {
//print message
$display_block .= "<P>You have no items in your cart.
Please <a href=\"seestore.php\">continue to shop</a>!</p>";
} else {
//get info and build cart display
$display_block .= "
<table celpadding=3 cellspacing=2 border=1 width=98%>
<tr>
<th>Titel</th>
<th>Pris</th>
<th>Antal</th>
<th>Samlet pris</th>
<th>Varenr</th>
<th>Slet</th>
</tr>";
while ($cart = mysql_fetch_array($get_cart_res)) {
$id = $cart['id'];
$item_title = stripslashes($cart['item_title']);
$item_price = $cart['item_price'];
$item_qty = $cart['sel_item_qty'];
$item_nr = $cart['item_nr'];
$total_price = sprintf("%.02f", $item_price * $item_qty);
$display_block .= "<tr>
<td align=center>$item_title <br></td>
<td align=center>\$ $item_price <br></td>
<td align=center>$item_qty <br></td>
<td align=center>\$ $total_price</td>
<td align=center>$item_nr<br></td>
<td align=center><a href=\"removefromcart.php?id=$id\">remove</a></td>
</tr>";
}
$display_block .= "</table>";
}
}
?>
<HTML>
<HEAD>
<TITLE>My Store</TITLE>
</HEAD>
<BODY>
<? print $display_block; ?>
<a href="bestilling.php">Fortsæt til kasse</a>
</BODY>
</HTML>
================
Bestilling.php:
<html>
<head>
<title>nix</title>
</head>
<body oncontextmenu="return false"ondragstart="return false"onselectstart="return false">
<div align="left">
<form action="bestilling.php?action=ok" method="POST">
<b>Dit navn:</b><br>
<input type="text" name="navn">
<br>
<b>Din E-mail:</b><br>
<input type="text" name="mail"><br>
<b>Adresse:</b><br>
<input type="text" name="adresse">
<br>
<b>Postnummer og by:</b><br>
<input type="text" name="postnummer">
<br><br>
<input type="submit" value="Send Besked" name="send">
<input type="reset" value="Tøm felterne">
<br>
</div>
</form>
<?
$conn = mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("korczynski",$conn) or die(mysql_error());
include("showcart.php");
if($_GET[action] == "ok") {
if($_POST[navn] == "") {
echo("Du skal udfylde feltet med dit <b>Navn</b>");
} else {
if($_POST[mail] == "") {
echo("Du skal udfylde feltet med din <b>Mail</b>");
} else {
if($_POST[adresse] == "") {
echo("Du skal udfylde feltet <b>Adresse</b>");
} else {
if($_POST[postnummer] == "") {
echo("Du skal udfylde feltet med dit <b>Postnummer</b>");
} else {
$showcart = $_POST[showcart.php];
$navn = $_POST[navn];
$mail = $_POST[mail];
$adresse = $_POST[adresse];
$postnummer = $_POST[postnummer];
$item_price = $_POST['item_price'];
$item_qty = $_POST['sel_item_qty'];
$item_nr = $_POST['item_nr'];
$cart = mysql_fetch_array($get_cart_res);
$item_price = $cart['item_price'];
$item_qty = $cart['sel_item_qty'];
$item_nr = $cart['item_nr'];
$total_price = sprintf("%.02f", $item_price * $item_qty);
$show = $_POST['$item_nr'];
$shaw = $_POST['item_qty'];
$display_block .= "
";
mail("bratsch@ofir.dk", "Emne: Order", $display_block, $_mail, "From: $mail\nX-Mailer: http://$HTTP_HOST$REQUEST_URI");
echo("<br>Din ordre er modtaget. Er De i tvivl med købeproceduren, så læs venligst købsvejledningen.");
}
}
}
}
}
?>
</div>
</body>
</html>
========
Addtocart.php:
<?php
session_start();
//connect to database
$conn = mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("korczynski",$conn) or die(mysql_error());
if ($_POST[sel_item_id] != "") {
//validate item and get title and price
$get_iteminfo = "select item_title from store_items where id = $_POST[sel_item_id]";
$get_iteminfo_res = mysql_query($get_iteminfo) or die(mysql_error());
if (mysql_num_rows($get_iteminfo_res) < 1) {
//invalid id, send away
header("Location: seestore.php");
exit;
} else {
//get info
$item_title = mysql_result($get_iteminfo_res,0,'item_title');
//add info to cart table
$addtocart = "insert into store_shoppertrack values ('', '$PHPSESSID', '$_POST[sel_item_id]', '$_POST[sel_item_qty]', '$_POST[sel_item_size]', '$_POST[sel_item_color]', now())";
mysql_query($addtocart);
//redirect to showcart page
header("Location: showcart.php");
exit;
}
} else {
//send them somewhere else
header("Location: seestore.php");
exit;
}
?>
=====
Removefromcard.php
<?php
session_start();
//connect to database
$conn = mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("korczynski",$conn) or die(mysql_error());
if ($_GET[id] != "") {
$delete_item = "delete from store_shoppertrack where id = $_GET[id] and session_id = '$PHPSESSID'";
mysql_query($delete_item) or die(mysql_error());
//redirect to showcart page
header("Location: showcart.php");
exit;
} else {
//send them somewhere else
header("Location: seestore.php");
exit;
}
?>
=======
Seestore.php:
<?php
session_start();
//connect to database
$conn = mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("korczynski",$conn) or die(mysql_error());
$display_block = "<h1>My Categories</h1>
<P>Select a category to see its items.</p>";
//show categories first
$get_cats = "select id, cat_title, cat_desc from store_categories order by cat_title";
$get_cats_res = mysql_query($get_cats) or die(mysql_error());
if (mysql_num_rows($get_cats_res) < 1) {
$display_block = "<P><em>Sorry, no categories to browse.</em></p>";
} else {
while ($cats = mysql_fetch_array($get_cats_res)) {
$cat_id = $cats[id];
$cat_title = strtoupper(stripslashes($cats[cat_title]));
$cat_desc = stripslashes($cats[cat_desc]);
$display_block .= "<p><strong><a href=\"$_SERVER[PHP_SELF]?cat_id=$cat_id\">$cat_title</a></strong><br>$cat_desc</p>";
if ($_GET[cat_id] == $cat_id) {
//get items
$get_items = "select id, item_title, item_price from store_items where cat_id = $cat_id order by item_title";
$get_items_res = mysql_query($get_items) or die(mysql_error());
if (mysql_num_rows($get_items_res) < 1) {
$display_block = "<P><em>Sorry, no items in this category.</em></p>";
} else {
$display_block .= "<ul>";
while ($items = mysql_fetch_array($get_items_res)) {
$item_id = $items[id];
$item_title = stripslashes($items[item_title]);
$item_price = $items[item_price];
$display_block .= "<li><a href=\"showitem.php?item_id=$item_id\">$item_title</a></strong> (\$$item_price)";
}
$display_block .= "</ul>";
}
}
}
}
?>
<HTML>
<HEAD>
<TITLE>My Categories</TITLE>
</HEAD>
<BODY>
<? print $display_block; ?>
</BODY>
</HTML>
=======
Showitem.php:
<?php
session_start();
//connect to database
$conn = mysql_connect("", "", "")
or die(mysql_error());
mysql_select_db("korczynski",$conn) or die(mysql_error());
$display_block = "<h1>My Store - Item Detail</h1>";
//validate item
$get_item = "select c.cat_title, si.item_title,
si.item_price, si.item_desc, si.item_image, si.item_nr
from store_items as si left join store_categories
as c on c.id = si.cat_id where si.id = $_GET[item_id]";
$get_item_res = mysql_query($get_item)
or die (mysql_error());
if (mysql_num_rows($get_item_res) < 1) {
//invalid item
$display_block .= "<P><em>Invalid item selection.</em>
</p>";
} else {
//valid item, get info
$cat_title = strtoupper(stripslashes(
mysql_result($get_item_res,0,'cat_title')));
$item_title = stripslashes(mysql_result($get_item_res,0,
'item_title'));
$item_price =
mysql_result($get_item_res,0,'item_price');
$item_desc = stripslashes(mysql_result($get_item_res,0,
'item_desc'));
$item_nr = stripslashes(mysql_result($get_item_res,0,'item_nr'));
$item_image = mysql_result($get_item_res,0,
'item_image');
//make breadcrumb trail
$display_block .= "<P><strong><em>You are viewing:</em>
<br>
<a href=\"seestore.php?cat_id=$cat_id\">$cat_title</a>
> $item_title</strong></p>
<table cellpadding=3 cellspacing=3>
<tr>
<td valign=middle align=center><img src=\"images/$item_image\">
</td>
<td valign=middle><P><strong>Description:</strong><br>
$item_desc</p><br>
<P><strong>Varenr:</strong><br>
$item_nr</p> <br>
<P><strong>Price:</strong> \$$item_price</p>
<form method=post action=\"addtocart.php\">";
//get colors
$get_colors = "select item_color from store_item_color where item_id ='" . $item_id ."' order by item_color";
$get_colors_res = mysql_query($get_colors) or die(mysql_error());
if (mysql_num_rows($get_colors_res) > 0) {
$display_block .= "<P><strong>Available Colors:</strong>
<select name=\"sel_item_color\">";
while ($colors = mysql_fetch_array($get_colors_res)) {
$item_color = $colors['item_color'];
$display_block .= "<option value=\"$item_color\">$item_color</option>";
}
$display_block .= "</select>";
}
//get sizes
$get_sizes = "select item_size from store_item_size where item_id ='" . $item_id ."' order by item_size";
$get_sizes_res = mysql_query($get_sizes) or die(mysql_error());
if (mysql_num_rows($get_sizes_res) > 0) {
$display_block .= "<P><strong>Available Sizes:</strong>
<select name=\"sel_item_size\">";
while ($sizes = mysql_fetch_array($get_sizes_res)) {
$item_size = $sizes['item_size'];
$display_block .= "
<option value=\"$item_size\">$item_size</option>";
}
$display_block .= "</select>";
}
$display_block .= "
<P><strong>Select Quantity:</strong>
<select name=\"sel_item_qty\">";
for($i=1; $i<11; $i++) {
$display_block .= "<option value=\"$i\">$i</option>";
}
$display_block .= "
</select>
<input type=\"hidden\" name=\"sel_item_id\" value=\"$_GET[item_id]\">
<P><input type=\"submit\" name=\"submit\" value=\"Add to Cart\"></p>
</form>
</td>
</tr>
</table>";
}
?>
<HTML>
<HEAD>
<TITLE>My Store</TITLE>
</HEAD>
<BODY>
<? print $display_block; ?>
</BODY>
</HTML>
