Previous orders

Enter your email address to see previous orders.

'; if ($userCustID > 0) { $custID = $userCustID; $custIDs = htmlspecialchars($custID); $customer = $db->prepare('SELECT fname, lname, email FROM bookCustomers WHERE custID = ?;'); $customer->execute(array($custID)); if ($customer->rowCount() == 1) { $row = $customer->fetch(); $orders = $db->prepare('SELECT o.orderID, o.orderdate FROM bookorders o WHERE o.custID = ? GROUP BY o.orderID ORDER BY o.orderdate DESC;'); $orders->execute(array($custID)); if ($orders->rowCount() == 0) { $content .= "

No orders for customer $row[fname] $row[lname].

"; } else { $content .= "

Orders for customer $row[fname] $row[lname].

"; $books = $db->prepare('SELECT i.qty, i.price, d.ISBN, d.title, d.pages FROM bookorderitems i, bookdescriptions d WHERE i.orderID = ? AND i.ISBN = d.ISBN ORDER BY d.title;'); foreach ($orders->fetchAll() as $order) { $orderDate = date('F j Y \a\t g:i a', $order['orderdate']); $content .= "

Order #$order[orderID] on $orderDate

"; $books->execute(array($order['orderID'])); $content .= "
"; $orderTotal = 0; $pages = 0; foreach ($books->fetchAll() as $book) { $pricef = sprintf("$%.2f", $book['price']); $totalf = sprintf("$%.2f", $book['price'] * $book['qty']); $content .= "

$book[title]

Price: $pricef
Quantity: $book[qty]
Total: $totalf
"; $orderTotal += $book['price'] * $book['qty']; $pages += $book['pages'] * $book['qty']; } $orderTotalf = sprintf("$%.2f", $orderTotal); $shipping = sprintf("$%.2f", pow($pages, .25)); $totalf = sprintf("$%.2f", $orderTotal + pow($pages, .25)); $content .= "
Sub Total: $orderTotalf
Shipping: $shipping
Total: $totalf
"; } } } else { $content .= "Error: Customer with ID $custIDs not found in database."; } } else { header('location: account.php?orderHistory=true'); exit(); } require 'template.php'; ?>