l105/PO Informatica P4/jumboProducten.php
<?php
$edit = $_GET['edit'];
$productid = $_GET['productid'];
$productNaam = $_GET['productNaam'];
$details = $_GET['productDetails'];
?>
<!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 href="style.css?t=<?php echo time();?>(>)" rel= "stylesheet" type=text/css>
<script src='ajax.js'></script>
<script>
window.onload = laadAjax;
function laadAjax() {
document.getElementById('zoekbalk').onkeyup = zoekAjax;
}
function zoekAjax() {
var zoeken = document.getElementById("zoekbalk1").value;
// document.write(zoeken);
ajax('jumboProductenDetails.php?zoeken=' + zoeken, 'zoekendiv');
}
</script>
</head>
<body>
<div class="logoomhulsel">
<img class="logo" src="images\Jumbo_Logo.svg.png" alt="">
</div>
<?php
include("navbarJumbo.php");
if(isset($_GET['edit'])){
$edit=$_GET['edit'];
echo "<button><a href='jumboProducten.php?'>Terug</a></button>";
}
else{
$edit=null;
}
include("db.php");
include("functies.php");
if(!$edit && !$details){
?>
<form action="" method="get">
<div style="text-align: center;" id="zoekbalk">
zoekbalk <input type="text" name="zoekbalk" id="zoekbalk1">
<input type="submit" name="zoeken" id="zoeken">
<div id="zoekendiv"><?php
$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>";
}
?>
</div>
<!-- <div id='ajaxtext'></div> -->
</div>
</form>
<?php
// $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));
// echo "<h3>Alle jumbo producten</h3>";
// while ($row = mysqli_fetch_array($resultJumboProducten)) {
// echo"<div>";
// echo "<a href='jumboProducten.php?productDetails=$row[0]'>$row[1]</a>, €$row[3] ";
// if($admin == true) {
// echo "|| <a 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 "<br> <br> <br>";
}
if($details) {
$details = $_GET['productDetails'];
echo "<div><a href='jumboProducten.php'>terug</a></div>";
$query =
"select *
from producten
where productID = $details";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$rowdetail = mysqli_fetch_array($result);
echo "<br>";
echo "<div>Product naam: $rowdetail[1]</div>";
echo "<br>";
echo "<div>vegatarisch: $rowdetail[2]</div>";
echo "<br>";
echo "<div>prijs: $rowdetail[3]</div>";
echo "<img src='images/$rowdetail[0].png' alt='productfoto'>";
}
if($edit) {
$edit = $_GET['edit'];
$query =
"select *
from producten
where productID = $edit";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$rowedit = mysqli_fetch_array($result);
echo "<br>";
echo "<form method='get'>";
echo "product naam: <input type='text' value='$rowedit[1]'> ";
echo "<br>";
echo "Vegetarisch: <input type='text' value='$rowedit[2]'>";
echo "<br>";
echo "prijs: <input type='text' value='$rowedit[3]'>";
echo "<br>";
echo "<input type='submit' value='aanpassen'>";
echo "<br>";
echo "<img src='images/$rowedit[0].png' alt='productfoto'>";
echo "</form>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse