<?php include_once "include/default-values.php" ?>
<?php
$res = $db_con->query("SELECT * FROM products ORDER BY PID DESC");
$error = mysqli_error($db_con);
$products = [];
while ($row = $res->fetch_assoc()) {
    if (isset($row["PPic"])) {
        $pics = explode(" ", $row["PPic"]);
        $row["PPic"] = $pics;
    } else {
        $row["PPic"] = ["imagecomingsoon.png"];
    }
    $products[] = $row;
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>EDEA - Shop</title>
    <link rel="stylesheet" href="<?= $siteroot; ?>css/style.css">
</head>

<body>
    <?php include "include/header.php"; ?>
    <main>
        <h1>EDEA shop</h1>
        <ul class="products">
            <?php
            foreach ($products as $product) {
            ?>
                <li class="product">
                    <h3><?= $product["PName"] ?></h3>
                    <div class="product-vital">
                        <div class="thumbnail">
                            <img src="<?= $siteroot; ?>assets/img/<?= $product["PPic"][0] ?>" alt="<?= $product["PName"] ?>">
                        </div>
                        <div class="stars">
                            <?php
                            for ($i = 0; $i < $product["PStars"]; $i++) {
                            ?>
                                <div class="star">
                                    <svg viewBox="0 0 512 512" fill="#FFD700">
                                        <path d="M512 255.1c0 11.34-7.406 20.86-18.44 23.64l-171.3 42.78l-42.78 171.1C276.7 504.6 267.2 512 255.9 512s-20.84-7.406-23.62-18.44l-42.66-171.2L18.47 279.6C7.406 276.8 0 267.3 0 255.1c0-11.34 7.406-20.83 18.44-23.61l171.2-42.78l42.78-171.1C235.2 7.406 244.7 0 256 0s20.84 7.406 23.62 18.44l42.78 171.2l171.2 42.78C504.6 235.2 512 244.6 512 255.1z" />
                                    </svg>
                                </div>
                            <?php
                            }
                            ?>
                        </div>
                    </div>
                    <div class="product-buy">
                        <h4><?= $product["PPrice"] ?>,-</h4>
                        <a href="<?= $siteroot ?>showProduct.php?PID=<?= $product["PID"] ?>"><button>Læs mere</button></a>
                    </div>
                    <div class="product-info">
                        <h4>Beskrivelse:</h4>
                        <p><?= $product["PDesc"] ?></p>
                    </div>
                </li>
            <?php
            }
            ?>
        </ul>
    </main>
    <?php include "include/footer.php"; ?>
    <script src="<?= $siteroot; ?>js/stars.js"></script>
</body>

</html>