l105/PO Informatica P4/producten.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>

    <link rel="stylesheet" href="style.css">
    
    <style>
        .logo {
            width: 200px;
            height: 70px;
        }

        .logoomhulsel {
            text-align: center;

        }
    </style>


</head>
<body>

<div class="logoomhulsel">
<img class="logo" src="images\Jumbo_Logo.svg.png" alt="">
</div>
   
<div class="navbarjumbo">
    
    <a id="homeknop" href="Jumbo.php">Jumbo</a>

    <a href="producten.php">Bestellen</a>
    <a href="solliciteren.php">Solliciteren</a>
    <a href="producten.php">Bonussen</a>

</div>



<?php 


include('db.php');

$alleProducten = "
select * 
from producten";

$resultAlleProducten = mysqli_query($db, $alleProducten) or die(mysqli_error($db));


$jumboProducten = "
select * 
from producten p, verkopen v
where winkelID = 1 and p.productID = v.productID
";

$resultJumboProducten = mysqli_query($db, $jumboProducten) or die(mysqli_error($db));


$slagerProducten = "
select * 
from producten p, verkopen v
where winkelID = 3 and p.productID = v.productID
";

$resultSlagerProducten = mysqli_query($db, $slagerProducten) or die(mysqli_error($db));


$bakkerProducten = "
select * 
from producten p, verkopen v
where winkelID = 2 and p.productID = v.productID
";

$resultBakkerProducten = mysqli_query($db, $bakkerProducten) or die(mysqli_error($db));


$muziekProducten = "
select * 
from producten p, verkopen v
where winkelID = 4 and p.productID = v.productID
";

$resultMuziekProducten = mysqli_query($db, $muziekProducten) or die(mysqli_error($db));



echo "<h3>Alle producten</h3>";

while ($row = mysqli_fetch_array($resultAlleProducten)) {
    echo "$row[1] <br>";
}

echo "<h3>Alle jumbo producten</h3>";


while ($row = mysqli_fetch_array($resultJumboProducten)) {
    echo "$row[1] <br>";
}

echo "<h3>Alle slager producten</h3>";


while ($row = mysqli_fetch_array($resultSlagerProducten)) {
    echo "$row[1] <br>";
}

echo "<h3>Alle bakker producten</h3>";


while ($row = mysqli_fetch_array($resultBakkerProducten)) {
    echo "$row[1] <br>";
}

echo "<h3>Alle muziek producten</h3>";


while ($row = mysqli_fetch_array($resultMuziekProducten)) {
    echo "$row[1] <br>";
}




?>




</body>
</html>
Resultaat

Made by Thijs Aarnoudse