<?php include "db.php"; include "functions.php" ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<style>
td{
border: 1px solid black;
}
</style>
</head>
<body>
<?php
$queries = ["SELECT * FROM producten
WHERE productid IN(
SELECT productid FROM voorraad
WHERE aantal = (
SELECT MIN(aantal) FROM voorraad
)
)", "SELECT * FROM producten
WHERE productid IN (
SELECT productid FROM verkoopprijzen
WHERE tot_prijs = (
SELECT MAX(tot_prijs) FROM verkoopprijzen
)
)", "SELECT emailadres FROM kopers
WHERE koperid IN(
SELECT koperid FROM verkopen
WHERE productid = 3
)", "SELECT * FROM leveranciers
WHERE productid IN(
SELECT productid FROM producten
WHERE productid IN(
SELECT productid FROM voorraad
WHERE aantal < 30000
)
)", "SELECT * FROM kopers
WHERE koperid IN(
SELECT koperid FROM verkopen
WHERE productid IN(
SELECT productid FROM producten
WHERE productid IN(
SELECT productid FROM voorraad
WHERE aantal < 30000
)
)
)", "SELECT SUM(aantal), productnaam FROM verkopen, producten
WHERE verkopen.productid = producten.productid
GROUP BY producten.productid",
"SELECT COUNT(inkoopid) FROM inkopen
GROUP BY productid"];
//echo formattable(mysqli_query($db, "SELECT * FROM producten"));
for($h = 0; $h < count($queries); $h++){
$result = mysqli_query($db, $queries[$h]);
echo formattable($result);
echo "<br><br>";
}
?>
</body>
</html>