-
Notifications
You must be signed in to change notification settings - Fork 0
/
viewProduct.php
71 lines (59 loc) · 2.55 KB
/
viewProduct.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?php
include 'incs/header.php';
include 'classes/dbh.php';
$dbh = new Dbh();
?>
<body>
<?php
include 'incs/navBar.php';
?>
<?php
$id = $_GET['id'];
$stmt = $dbh->connection()->prepare("SELECT * FROM product INNER JOIN product_category ON product.product_category = product_category.category_id INNER JOIN product_image ON product_image.product_id = product.product_id WHERE product.product_id = $id;");
$stmt->execute();
$result = $stmt->fetchAll();
$rowCount = $stmt->rowCount();
if (!$rowCount < 1) {
foreach ($result as $row) {
if ($row['product_availability'] == 'true' && $row['product_quantity'] > 0) {
echo "
<div class = \"main-wrapper\">
<div class = \"container\">
<div class = \"product-div\">
<div class = \"product-div-left\">
<div class = \"img-container\">
<img src = \"imgs/$row[image_name]\" alt = \"Product foto\">
</div>
</div>
<div class = \"product-div-right\">
<span class = \"product-name\">$row[product_name]</span>
<span class = \"product-price\">€$row[product_price]</span>
<p class = \"product-description\">$row[product_description]</p>
<div class = \"btn-groups\">
<form action=\"shoppingCart.php?id=$row[product_id]\" method=\"post\">
<input type = \"number\" name = \"amount\" id = \"amount\" value = \"1\" min = \"1\" max = \"10\">
<input type = \"hidden\" name = \"name\" value = \"$row[product_name]\">
<input type = \"hidden\" name = \"price\" value = \"$row[product_price]\">
<input type = \"hidden\" name = \"image\" value = \"$row[image_name]\">
<br>
<br>
<button type = \"submit\" class = \"add-cart-btn\" name = \"cart\"><i class = \"fas fa-shopping-cart\"></i>Toevoegen aan winkelwagen</button>
<button type = \"button\" class = \"buy-now-btn\"><i class = \"fas fa-heart\"></i>Toevoegen aan verlanglijst</button>
</form>
</div>
</div>
</div>
</div>
</div>
";
} else {
header("Location: 400.php");
}
}
} else {
header("Location: 400.php");
}
?>
<?php
include 'incs/footer.php';
?>