l105/PO Informatica P4/jumboProductenDetails.php


<?php
include("db.php");
include("functies.php");
$zoek = $_GET["zoeken"];



$query = "SELECT * 
FROM producten p, verkopen v
WHERE winkelID = 1 AND p.product_naam like '%$zoek%' AND v.productID = p.productID";


$result = mysqli_query($db, $query);
echo '<div><h2>Product</h2></div>';
while ($row = mysqli_fetch_array($result)) {
    echo"<div>";
                echo "<a class='productButton' href='jumboProducten.php?productDetails=$row[0]'>$row[1], €$row[3] </a>";
        
                if($admin == true) {
                    echo "||  <a class='wijzigInfoButton' href='jumboProducten.php?edit=$row[0]'>wijzig informatie</a>  <br>";
            
                }

        
                echo "<br><img class='productFoto' src='images/$row[0].png' alt='productfoto'><br>";
            echo"</div>";
}

// echo $zoek 




/*


$query = "SELECT * FROM afleveringen WHERE serienaam like '%$zoek%' OR titel like '%$zoek%'";
$result = mysqli_query($db, $query);
echo '<div><h2>Afleveringen</h2></div>';
while ($row = mysqli_fetch_array($result)) {
    echo "<div>$row[titel] - $row[serienaam]</div>";
}

$query = "SELECT * FROM films WHERE titel like '%$zoek%'";
$result = mysqli_query($db, $query);
echo '<div><h2>Films</h2></div>';
while ($row = mysqli_fetch_array($result)) {
    echo "<div>$row[titel]</div>";
}

$query = "SELECT * FROM series WHERE titel like '%$zoek%'";
$result = mysqli_query($db, $query);
echo '<div><h2>Series</h2></div>';
while ($row = mysqli_fetch_array($result)) {
    echo "<div>$row[titel]</div>";
}

$query = "SELECT * FROM streamingsdiensten WHERE naam like '%$zoek%'";
$result = mysqli_query($db, $query);
echo '<div><h2>Streamingsdiensten</h2></div>';
while ($row = mysqli_fetch_array($result)) {
    echo "<div>$row[naam]</div>";
}

*/
?>
Resultaat

Made by Thijs Aarnoudse