<?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)) {
