From cda96d31939c7ea727c114b162f43bb4d18314a2 Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Mon, 8 May 2023 17:08:54 +0200
Subject: more website

---
 public/index.php | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)

(limited to 'public/index.php')
diff --git a/public/index.php b/public/index.php
index 0f268cb..653962c 100644
--- a/public/index.php
+++ b/public/index.php
@@ -1,4 +1,5 @@
 <!DOCTYPE html>
+<?php require "db.php"; ?>
 <html>
 <head>
 	<?php include 'head.php' ?>
@@ -11,9 +12,12 @@
 		<div class="s1">
 			<h1>hier zijn de aanbiedingen</h1>
 			<ul>
-				<li>Lorem ipsum dolor sit amet consectetur adipisicing elit. Fuga iure id repudiandae sapiente voluptatibus soluta ducimus? Molestiae pariatur optio saepe nihil fugit, commodi atque! Consequatur at omnis recusandae nostrum tenetur!</li>
-				<li>Ut, repudiandae? Iusto pariatur cupiditate, ipsam magni accusamus asperiores possimus nulla, magnam quas consectetur fugit vero quibusdam officiis quod, vitae soluta nostrum placeat itaque sit beatae quos laudantium? Temporibus, magni.</li>
-				<li>Ipsum fugiat corporis impedit iusto possimus neque alias at sunt commodi deserunt! Numquam perferendis rem ea provident velit dicta quae. Eveniet officia iure porro aliquid minus alias at commodi nam?</li>
+				<?php
+					$res = $cursor->query("select product.ID as 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>
-- 
cgit v1.2.3

