';
$updateCart = $db->prepare('UPDATE bookuuidcart SET quantity = :qty WHERE ISBN = :isbn AND uuid = :uuid;');
$insertCart = $db->prepare('INSERT INTO bookuuidcart (uuid, ISBN, quantity) VALUES (:uuid, :isbn, :qty);');
$deleteCart = $db->prepare('DELETE FROM bookuuidcart WHERE uuid = :uuid AND ISBN = :isbn;');
$addISBN = (isset($_POST['addISBN'])) ? preg_replace("/[^0-9.X]+/i", "", $_POST['addISBN']) : false;
if ($addISBN && strlen($addISBN) > 0) {
if (array_key_exists($addISBN, $bookArray)) {
$bookArray[$addISBN] += 1;
$updateCart->execute(array(':uuid' => hex2bin($userUUID), ':isbn' => $addISBN, ':qty' => $bookArray[$addISBN]));
} else {
$bookArray[$addISBN] = 1;
$insertCart->execute(array(':uuid' => hex2bin($userUUID), ':isbn' => $addISBN, ':qty' => $bookArray[$addISBN]));
}
header('location: shoppingCart.php');
exit();
}
$deleteISBN = (isset($_POST['deleteISBN'])) ? preg_replace("/[^0-9.X]+/i", "", $_POST['deleteISBN']) : false;
if ($deleteISBN && strlen($deleteISBN) > 0) {
if (array_key_exists($deleteISBN, $bookArray)) {
$bookArray[$deleteISBN] -= 1;
if ($bookArray[$deleteISBN] <= 0) {
$deleteCart->execute(array(':uuid' => hex2bin($userUUID), ':isbn' => $deleteISBN));
unset($bookArray[$deleteISBN]);
} else {
$updateCart->execute(array(':uuid' => hex2bin($userUUID), ':isbn' => $deleteISBN, ':qty' => $bookArray[$deleteISBN]));
}
}
header('location: shoppingCart.php');
exit();
}
if (count($bookArray) > 0) {
$sql = "SELECT ISBN, title, price, pages from bookdescriptions WHERE ISBN = ?";
for ($i = 1; $i < count($bookArray); $i++) {
$sql .= " OR ISBN = ?";
}
$isbnArray = array_map('strval', array_keys($bookArray)); // PHP please stop casting things that look like integers to integers
$sql .= " ORDER BY title;";
$query = $db->prepare($sql);
$query->execute($isbnArray);
$total = 0;
$shipping = 0;
foreach ($query->fetchAll() as $row) {
$isbn = $row['ISBN'];
$qty = $bookArray[$isbn];
$itemTotal = $qty * $row['price'];
$pricef = sprintf("$%.2f", $row['price']);
$totalf = sprintf("$%.2f", $itemTotal);
$total += $itemTotal;
$shipping += $row['pages'] * $qty;
$content .= "$row[title]
![](\"//yorktown.cbe.wwu.edu/sandvig/mis314/assignments/bookstore/bookimages/$row[ISBN].01.THUMBZZZ.jpg\")
Price:
$pricefQuantity: $qty
Total:
$totalfSub total: $totalf
";
$content .= "Shipping: $shippingf
";
$content .= "Total: $grandTotal
";
$content .= "Shipping is the 4th root of the number of pages in your order.";
$content .= "";
} else {
$content = "No items in cart.
";
}
require 'template.php';
?>