<?php
session_start();
include('funkcie_projekt.php');
include('db.php');
hlavicka('Ponuka');

navigacia();
?>


<section>

<?php

//$mysqli = new mysqli('localhost', 'root', 'usbw', 'projekt');
//if ($mysqli->connect_errno) {
//  echo '<p class="chyba">Nepodarilo sa pripojiť (' . $mysqli->connect_errno . ' - ' . $mysqli->connect_error . ')</p>';
//} else {


?>
    <form method="post">
        <br>
        <strong>Zoradiť podľa:</strong>
        <input type="radio" name="zoradit" id="zoradit_nazov1" value="nazov1">
        <label for="zoradit_nazov1">názvu (A-Z)</label>

        <input type="radio" name="zoradit" id="zoradit_nazov2" value="nazov2">
        <label for="zoradit_nazov2">názvu (Z-A)</label>

        <input type="radio" name="zoradit" id="zoradit_cena1" value="cena1">
        <label for="zoradit_cena1">podľa ceny (od najvyššej)</label>

        <input type="radio" name="zoradit" id="zoradit_cena2" value="cena2">
        <label for="zoradit_cena2">podľa ceny (od najnižšej)</label>
        <br>
    <input type="submit" name="zorad" value="Zoradiť">
  </form><br>

<form method="post">
<?php

if(isset($_GET['add'])){
    if (!isset($_SESSION['user']['kosik'])) {
        $_SESSION['user']['kosik'] = [];
    }
    array_push($_SESSION['user']['kosik'], $_GET['add']);
}

if (!$mysqli->connect_errno){
    $sql = "SELECT * FROM `hlavne_jedlo` " ;
        if(isset($_POST["zoradit"]) && $_POST["zoradit"] == "nazov1") $sql = "SELECT *FROM `hlavne_jedlo` WHERE `pocet_kusov` >0 ORDER BY `hlavne_jedlo`.`nazov` ASC " ;  // abecedne A-Z  DO POST TREBA VALUE!!!!!
        if(isset($_POST["zoradit"]) && $_POST["zoradit"] == "nazov2") $sql = "SELECT * FROM `hlavne_jedlo` WHERE `pocet_kusov` >0 ORDER BY `hlavne_jedlo`.`nazov` DESC " ;  // abecedne Z-A
        if(isset($_POST["zoradit"]) && $_POST["zoradit"] == "cena1") $sql = "SELECT * FROM `hlavne_jedlo` WHERE `pocet_kusov` >0 ORDER BY `hlavne_jedlo`.`cena` ASC " ;  // od najvyssej ceny
        if(isset($_POST["zoradit"]) && $_POST["zoradit"] == "cena2") $sql = "SELECT * FROM `hlavne_jedlo` WHERE `pocet_kusov` >0 ORDER BY `hlavne_jedlo`.`cena` DESC " ;  // od najnizsej ceny

        if ($result = $mysqli->query($sql)) {  // vykonam dopyt
            while ($row = $result->fetch_assoc()) {
                echo '<p class="ponuka"><h2>' . $row['nazov'] . "</h2><br>";
                #echo ' (' . $row['cena'] . "&euro;)</h2>\n";
                echo $row['popis'] . "<br>";
                echo '<strong>cena: </strong>' . $row['cena'] . "&euro;</p>";
                echo '<a class="pridaj_do_kosika" href="?add=' . $row['kod'] . '">Pridaj do kosika</a>';


            }
            $result->free();
        } elseif ($mysqli->errno) {
            echo '<p class="chyba">Dopyt sa nepodarilo vykonat (' . $mysqli->error . ')</p>';
        }
} else{
    echo '<p class="chyba">Nepodarilo sa pripojiť (' . $mysqli->connect_errno . ' - ' . $mysqli->connect_error . ')</p>';
}
?>
</form>
</section>


<?php include('aside.php')?>

<?php footer()?>

</body>
</html>