l108/PO/getproducts.php

<?php include "db.php"; $tags = $_GET["tags"]; $min = $_GET["min"]; $max = $_GET["max"]; $query = "SELECT productnaam, afbeelding, producten.productid, type, prijs_eenheid FROM producten, verkoopprijzen WHERE producten.productid = verkoopprijzen.productid"; if(isset($tags)){ $query .= " AND producten.type LIKE ('%$tags%')"; } if(isset($min) && isset($max)){ $query .= " AND prijs_eenheid > $min AND prijs_eenheid < $max"; } // echo $query; $result = mysqli_query($db, $query); while($row = mysqli_fetch_row($result)){ echo "<a class='product $row[3]' data-prijs='$row[4]' href='productdetail.php?product=$row[2]'>"; echo "<div><img src='afbeeldingen/$row[1]'></div>"; echo "<div class='desc'><p class='productname'>$row[0]</p>"; echo "</div>"; echo "</a>"; } ?>

Resultaat

Made by Thijs Aarnoudse