<?php include 'connectToDatabase.php'; include 'eshopLib.php'; $query = "Select * From tbl_collections_206 order by collectionId"; $result = mysqli_query($connection, $query); if (!$result) { die("Db query failed"); } $cartCountNumber = cartCount($userId, $connection); ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Get Your Cover | eShop</title> <script src="includes/jquery-2.2.0.min.js"></script> <link rel="stylesheet" type="text/css" href="includes/style.css"> <link href="https://fonts.googleapis.com/css?family=Amaranth" rel="stylesheet" type="text/css"> <link href="https://fonts.googleapis.com/css?family=Arimo" rel="stylesheet" type="text/css"> <script src="includes/script.js"></script> </head> <body> <header> <section id="DevicesNav"> <a id = "burger"></a> <ul id="mobileNav"> <li><a href="eshop.php">eShop</a></li> <li><a href="#">Log Out</a></li> </ul> </section>
<?php include 'connectToDatabase.php'; include 'eshopLib.php'; if (cartCount($userId, $connection) > 0) { if ($_POST['items'] == 'all') { $querySelect = "Select * From tbl_products_206 \n\t\t\tINNER JOIN tbl_cart_206\n\t\t\tON tbl_products_206.productId = tbl_cart_206.productId \n\t\t\tWHERE tbl_cart_206.userId =" . $userId; $result = mysqli_query($connection, $querySelect); if (!$result) { die("Db query failed 1"); } $sum = 0; $counter = 0; while ($row = mysqli_fetch_assoc($result)) { $sum += $row['productPrice']; $counter++; } $sum += $shiping; $today = date("F j, Y, g:i a"); $queryInsert = "INSERT INTO tbl_orders_206 (totalPrice,orderDate,user_id,orderStatus)\n\t\t\tVALUES (" . $sum . ",'" . $today . "'," . $userId . ",'pending');"; $resultInsert = mysqli_query($connection, $queryInsert); if (!$resultInsert) { die("Db query failed 3"); } $orderId = mysqli_insert_id($connection); $querySelect = "Select * From tbl_products_206 \n\t\t\tINNER JOIN tbl_cart_206\n\t\t\tON tbl_products_206.productId = tbl_cart_206.productId \n\t\t\tWHERE tbl_cart_206.userId = " . $userId; $result = mysqli_query($connection, $querySelect); if (!$result) { die("Db query failed 1"); } while ($row = mysqli_fetch_assoc($result)) {