"; $personalize .= "Underbust: ".$_POST["underbust"]."
"; $personalize .= "Waist: ".$_POST["waist"]."
"; $personalize .= "Hips: ".$_POST["hips"]."
"; $personalize .= "Bra cup: ".$_POST["cup"]."
"; $personalize .= "Fabric selection: "; $fabric = $_POST["fabric"]; foreach ($fabric as $value) { $personalize .= $value.". "; } $personalize .= "
"; $personalize .= "Corset Type: ".$_POST["type"]."
"; $personalize .= "Comments: ".$_POST["comments"]."
"; } else { $personalize = ""; } /*print $idproduct." a
"; print $idcat." b
"; print $idsubcat." c
"; print $src." d
"; print $sku." e
"; print $onsale." p
"; print $price." f
"; print $quantity." g
"; print $color." h
"; print $size." i
"; print $today." j
"; print $personalize." k
"; exit();*/ $query="INSERT INTO cart (idsession,idcheck,idproduct,idcat,idsubcat,src,sku,onsale,price,quantity,color,size,personalize,lead,today) VALUES (\"$idsession\",\"$idcheck\",\"$idproduct\",\"$idcat\",\"$idsubcat\",\"$src\",\"$sku\",\"$onsale\",\"$price\",\"$quantity\",\"$color\", \"$size\",\"$personalize\",\"$lead\",\"$today\");"; $result=mysql_query($query) or die ("Query failed 1".$query); } elseif (isset($_POST['update'])) { //update database $update = $_POST; //print_r ($update); foreach ($update as $key => $value) { $quantity = $value; $idcart = $key; $idcart = $idcart / 2 / $idcheck; //print $idcart; $query="UPDATE cart SET quantity=\"$quantity\" WHERE id='$idcart';"; $result=mysql_query($query) or die ("Query failed1".$query); } } elseif (isset($_POST['updatedit'])) { //update database $idproduct =$_POST["idproduct"]; $quantity =$_POST["quantity"]; $color =$_POST["color"]; $size =$_POST["size"]; $personalize =$_POST["personalize"]; $idedit =$_POST["idedit"]; $idcart = $idedit / 2 / $idcheck; $query="UPDATE cart SET quantity=\"$quantity\",color=\"$color\",size=\"$size\", personalize=\"$personalize\" WHERE id='$idcart';"; $result=mysql_query($query) or die ("Query failed1".$query); } elseif (isset($_GET['remove'])) { $idcart= $_GET['remove']; $idcart = $idcart / 2 / $idcheck; $query="DELETE FROM cart WHERE id='$idcart';"; $result=mysql_query($query) or die ("Query failed"); } elseif (isset($_POST['giftkit'])) { $_SESSION['giftkit'] = $_POST['giftkit']; } //view goes here $queryver="SELECT * FROM cart WHERE idsession='$idsession' AND idcheck='$idcheck'"; $resultver=mysql_query($queryver) or die ("Query failedver"); $num_rowsver = mysql_num_rows($resultver); if (empty($num_rowsver)) { print ""; exit(); } ?> '; $total = '0.00'; $i = '0'; $query="SELECT * FROM cart WHERE idsession='$idsession' AND idcheck='$idcheck'"; $result=mysql_query($query) or die ("Query failed"); while ($row = mysql_fetch_array($result)) { $idcart =$row["id"]; $idproduct =$row["idproduct"]; $idcat =$row["idcat"]; $idsubcat =$row["idsubcat"]; $src =$row["src"]; $sku =$row["sku"]; $price =$row["price"]; $quantity =$row["quantity"]; $color =$row["color"]." "; $size =$row["size"]." "; $personalize ="
".$row["personalize"]; if ($src == 'Elegant Moments') { $sel = 'a'; } elseif ($src == 'Sensual Mystique') { $sel = 'b'; } elseif ($src == 'Pink Label Corsets') { $sel = 'c'; } $idedit = $idcart * $idcheck * 2; $subtotal = $price * $quantity; $total = $subtotal + $total; $query1="SELECT * FROM products WHERE id='$idproduct'"; $result1=mysql_query($query1) or die ("Query failed1"); $row1 = mysql_fetch_array($result1); $catname = $row1["catname"]; $prodname = $row1["prodname"]; $description = $row1["description"]; $photomini = $row1["photomini"]; $photomed = $row1["photomed"]; $photolarge = $row1["photolarge"]; mysql_free_result($result1); if ($i == 0) { print ''; $i++; } else { print ''; $i = 0; } print ' '; } mysql_free_result($result); if (isset($_SESSION['giftkit'])) { $giftkit = $_SESSION['giftkit']; if (($giftkit == 'Man') || ($giftkit == 'Woman')) { $giftkitamount = '2.99'; } } else { $giftkitamount = '0.00'; } $totalship = $total + 4.95 + $giftkitamount; $tax = $totalship * 0.08125; $tax = round($tax, 2); $totaltaxed = $totalship + $tax; $_SESSION['tax'] = $tax; $_SESSION['total'] = $total; print ' '; print ' '; print ' '; print ' '; print ' '; print'

Home > My Shopping Bag

Unit

Qty

Total

'.$prodname.' - Item # '.$sku.'
'.$color.' '.$size.' '.$personalize.'

'.money_format('%(#10n', $price).'

'.money_format('%(#10n', $subtotal).'

Subtotal

'.money_format('%(#10n', $total).'

Premium Gift Kit: Bag + Tissue Paper

*Will be entered during checkout

*Coupon

- $ 0.00

USPS Priority Mail®

Shipping

'.money_format('%(#10n', '4.95').'

**Texas residents only, will be applied during checkout

**Sales Tax

$ 0.00

Total

'.money_format('%(#10n', $totalship).'

'; //action="https://www.lookatmelingerie.com/checkout.php"> ?>