setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {die('Could not connect to the Saint database:
' . $e);}
## Get Items In Cart -----------------------------------
$sql="SELECT * FROM CartItems WHERE UserID='$member' AND OrderNo='0' ORDER BY Date";
//$sql="SELECT * FROM CartItems ORDER BY Date";
//echo "$sql";
try {
// Prepare statement
$result = $db->prepare($sql);
$result->execute();
} catch(PDOException $e){ echo $sql . "
" . $e->getMessage();}
$num=$result->rowCount();
//echo "Number in cart ".$num;
if ($num == "0") {
echo "Your shopping cart is empty ";
} else {
# format Contents Display ---------------------------
echo "
| Thumbnail | "; echo ""; echo "Product Name"; echo " | "; echo ""; echo "Qty"; echo " | "; echo ""; echo "Cost"; echo " | "; echo ""; echo "Item Total"; echo " | "; echo "
|---|---|---|---|---|
![]() | $prettyItemsID | $ItemQuantity"; include("Quantity.php"); echo " | $ItemCost | $Itemtotal |