aboutsummaryrefslogtreecommitdiff
path: root/public/index.php
blob: cf8e7d13638669d40e3cfa5c4c9a3fd4ab2f0b7c (plain)
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
<!DOCTYPE html>
<?php require "../lib/db.php"; ?>
<html>
<head>
	<?php include 'head.php' ?>
	<title>webshop</title>
	<link rel='stylesheet' type='text/css' media='screen' href='home.css'>
</head>
<body>
	<?php include 'navbar.php' ?>
	<div class="main limwidth">
		<div class="s1">
			<h1>hier zijn de aanbiedingen</h1>
			<ul>
				<?php
					$res = $cursor->query("select product.id, product.name as name from promotion join product on product.id = promotion.product");
					while ($product = $res->fetch_object()) {
						echo "<li><a href=\"/product.php?id=$product->id\">$product->name</a></li>";
					}
				?>
			</ul>
		</div>
	</div>
	<?php include 'footer.php' ?>
</body>
</html>