"; ?> ?> "; // echo "Yesterday was $yesterday
"; $link = mysql_connect("localhost","expocraf_cartuse","expcrf88") or die("Cart Database Current Unavailable"); mysql_select_db (expocraf_expocart); $SQL = "DELETE FROM order_cart WHERE startdate<'$yesterday'"; $Result = mysql_query($SQL); //echo "SQL = $SQL
"; //echo "Result = $Result
"; if(!$_GET[q] and $_GET[pc]){ $_GET[q] = 1; } if($_POST[q]){ $_GET[q] = "$_POST[q]"; } if($_POST[pc]){ $_GET[pc] = "$_POST[pc]"; } if($_POST[pd]){ $_GET[pd] = "$_POST[pd]"; } if($_POST[p]){ $_GET[p] = "$_POST[p]"; } if($_POST[a]){ $_GET[a] = "$_POST[a]"; } if(!$_GET[a]){ $_GET[a]="view"; } $_GET[pd] = stripslashes("$_GET[pd]"); /* echo "link = $link
"; echo "dblink = $dblink
"; echo "_COOKIE[CartCookie] = $_COOKIE[CartCookie]
"; echo "_POST[q] = $_POST[q]
"; echo "_GET[q] = $_GET[q]
"; echo "_POST[pc] = $_POST[pc]
"; echo "_GET[pc] = $_GET[pc]
"; echo "_POST[pd] = $_POST[pd]
"; echo "_GET[pd] = $_GET[pd]
"; echo "_POST[p] = $_POST[p]
"; echo "_GET[p] = $_GET[p]
"; echo "_POST[a] = $_POST[a]
"; echo "_GET[a] = $_GET[a]
"; */ switch ($_GET[a]) { case "add": // insert into database new entry. $_GET[pd] = addslashes("$_GET[pd]"); $SQL = "INSERT INTO `order_cart` (`user_id`, `prd_code`, `prd_desc`, `prd_qty`, `prd_price`) VALUES ('$_COOKIE[CartCookie]','$_GET[pc]','$_GET[pd]','$_GET[q]','$_GET[p]')"; // $SQL = "INSERT INTO order_cart VALUES('$_COOKIE[CartCookie]','$_GET[pc]','$_GET[pd]','$_GET[q]','$_GET[p]')"; $Result = mysql_query($SQL); //echo "SQL = $SQL
"; //echo "Result = $Result
"; break; case "recal": // prd_qty in database. //echo "_POST[rpq] = $_POST[rpq]
"; foreach (array_keys($_POST[rpq]) as $kpq){ //echo "kpq = $kpq
"; $spq = $_POST[rpq][$kpq]; //echo "spq = $spq
"; $SQL = "UPDATE order_cart SET prd_qty='$spq' WHERE prd_code='$kpq' and user_id='$_COOKIE[CartCookie]'"; $Result = mysql_query($SQL); //echo "SQL = $SQL
"; } break; case "del": // delete prd_code in database foreach (array_keys($_POST[rpq]) as $kpq){ $spq = $_POST[rpq][$kpq]; if($spq==0){ $SQL = "DELETE FROM order_cart WHERE prd_code='$kpq' and user_id='$_COOKIE[CartCookie]'"; $Result = mysql_query($SQL); } } break; case "delall": // delete user_id in database $SQL = "DELETE FROM order_cart WHERE user_id='$_COOKIE[CartCookie]'"; $Result = mysql_query($SQL); break; case "shop": // go back to product catalog break; case "submit": // submit info, prepare for emailing. then delete from database break; case "view": // view shopping cart contents break; } ?>

"; echo ""; echo ""; echo ""; if(!$Result and $_GET[a]=='add') echo "Product Code $_GET[pc] is already in your order cart!
If you wish to add more of $_GET[pc], please change the quantity below and recalculate."; ?> "; $total = $total+$subtotal; //echo "total = $total
"; include("decimalzeroes2.php"); ?> "; ?>

Order Cart
QTY	CODE	PRODUCT DESCRIPTION	PRICE	SUBTOTAL
]" value="">
Total:

RECALCULATE.	Change the quantity then click on this button to recalculate the total.
REMOVE ITEM.	Type in zero "0" in the Qty of the product you want to remove then click on this button.
CLEAR OUT.	Click this button if you want to empty your cart.
SHOP FOR MORE.	Click to go back to the products list.
SUBMIT ORDER.	Press this button when you're finished choosing the product(s) you like to order.